Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Complex data types, collections
- Subtypes
- Cursor variables and dynamic cursors
- Associative arrays, collections
- Actions mass, bulk, forall
- Exception handling bulk operations
Object orientation in an Oracle database
- Types (classes)
- methods of objects
- permanent Collections
- Functions Panel
- streaming Features
- Create your own aggregate functions
Calling functions in SQL, constraints, levels of purity, determinism
Organization of program units PL / SQL
- Permissions in PL / SQL
- Context name
Integration with other languages
- Using JAVA
- Linking procedures C language
- Native compilation of the C language
Ready solutions
- Create the application context
- Mechanism of Virtual Private Database (VPD)
- Support lobbying
- Profiling code
- Tracking code
Productivity PL / SQL code
- Bind variables in SQL statements and the statistical distribution of
- cursor Sharing
- Objective query optimization
- Feather short procedures at compile
- Caching functions and query results
Prevention before injecting code
Requirements
- The free use of the basics of SQL and knowledge of Oracle database environment (preferably Oracle 11g completion of training - Native SQL for Programmers - Workshops)
- Fluency in the basics of PL / SQL (preferably Oracle 11g completion of training - Programming with PL / SQL I - Workshops)
21 Hours
Testimonials (5)
The topic was interesting, and the trainer was very friendly and has adept knowledge of the subject.
Jacqueline - Tribal Grou[
Course - Developing Applications with Oracle Application Express (APEX)
During the training, all modules were discussed in great detail - for two days of training - and that was what I cared about the most.
Bernadetta - Urząd Komisji Nadzoru Finansowego
Machine Translated
Lot of content and exactly the requested one.
Pascal - Diehl
Course - Advanced SQL, Stored Procedures and Triggers for Microsoft SQL Server
Luke was opened to answer any question and explain multiple times until everyone understood the exercises.
Alexandra Popa - OTP BANK ROMANIA S.A.
Course - Oracle SQL Language
I like fact, that after each section we had exercises. It helps to remember discussed topic.