Course Outline
Create stored subroutines
- Compilation, object status, source codes
- Code encryption (wrap)
- Object dependency model
- Parameterization
Permissions and schemas in PL/SQL
- Owner and caller model
- Direct and role permissions
- Whitelist
- Assigning roles to procedures and inheriting permissions
Advanced Cursors
- Comparison of explicit cursors and cursor loops
- Pointers for weak and strong cursors
- Support for dynamic cursors
- FOR UPDATE cursors
Collections
- Associative tables (index by), nested tables and varrays
- Attributes, handling, initialization, memory allocation
- Bulk queries (BULK COLLECT) and bulk DML (FORALL)
- Bulk operations in dynamic SQL
- Exception handling in bulk operations
- Array and stream functions
Packages
- Package structure: specification and body
- Benefits of using packages
- Initialization section and global variables, memory management, package instance
Triggers
- DML triggers
- View triggers (INSTEAD OF)
- System Triggers
- Composite triggers
Application context and VPD
- Using built-in context
- Create your own private and global contexts
- Saving and reading context values
- Policies and Virtual Private Database
Appendix A - Examples of using embedded packages
- File handling (utl_file)
- Job scheduling (dbms_job and dbms_scheduler
Suggested pre-training
ORA_S1, ORA_P1
Suggested complementary training
ORA_SP3
Requirements
Knowledge of the basics of the SQL language in terms of queries, as well as DML, DDL and TCL commands, as well as the ability to interpret and create simple PL/SQL scripts.
Testimonials (8)
I like this training because it was interactive
Amalia - Banca Transilvania
Course - SQL Fundamentals
the practices and the trainer notes
Hamda AlMahri - Dubai Courts
Course - ORACLE PL/SQL Fundamentals
Luka is an excellent, patient teacher with a sense of humor. His relaxed style made the stressful experience of "be called to the blackboard" more pleasant. Also one student explaining or guiding the other was a very good idea. I will use the motto "KISS methodology" he shared with us in both my SQL exercises , private and professional life since I like to overcomplicate things. Luka also kept the good pace considering how much material was there for him to show and for us to learn.
IWONA KLIMASZEWSKA - GP Strategies Poland sp. z o.o.
Course - ORACLE SQL Fundamentals
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 liked the way the trainer explained the information about the topics and the fact that he paid attention to the details so that the lessons were very practical and logical.
Andreea
Course - Oracle SQL for beginners
Exercises are entertaining and the topics were nicely introduced.
Adrian-Madalin Chirita - DB Global Technology SRL
Course - Oracle SQL Advanced
I like fact, that after each section we had exercises. It helps to remember discussed topic.
Adam Bińczycki
Course - Oracle 11g - SQL language for developers - Workshop
Trainer expertise on SQL tuning