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)
Testimonials (7)
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)
The way trainer demonstrated everything
Manveen - 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
- I really liked that the entire training was tailored to the level of all users and to different environments. It was cool to see how queries differ in different environments. - A huge advantage here is that the presenter's goal was to share his knowledge with us, and not to show the participants how smart he is:) - I also consider learning from my own and other people's mistakes to be very valuable because it significantly broadens your horizons.
Kasia
Course - SQL Advanced
Machine Translated
Exercises are entertaining and the topics were nicely introduced.
Adrian-Madalin Chirita - DB Global Technology SRL
Course - Oracle SQL Advanced
The trainer knowledge and style of explication
Vlad-Mihai Nicolae - DB Global Technology SRL
Course - Oracle SQL Advanced
I appreciated Folio's wide breadth of knowledge. Not only was he familiar with the course content, but he also knew of constructs in languages we were familiar with to make examples more meaningful to us. During intervals he shared his knowledge of technologies and solutions outside the training scope to provide insights into other solutions we could use in future (and future training).