PDF Add to WishList
Increase the productivity, performance, scalability, portability, and security of your Oracle database with this comprehensive PL/SQL programming course. With this training, you learn to write PL/SQL programs, build stored procedures, design and execute modular applications, and increase the efficiency of data movement — essential skills for any Oracle developer.
Oracle 11g and 12c PL/SQL features
Maintaining data with DML statements
Managing data retrieval with cursors
Error handling using EXCEPTIONs
Debugging PL/SQL blocks
Writing stored procedures and functions
Coding user-written functions
Developing safe triggers
Bulk binding for high performance
Finessing the compiler
Types of dynamic SQL
Course Tuition Includes:
After-Course Instructor Coaching
When you return to work, you are entitled to schedule a free coaching session with your instructor for help and guidance as you apply your new skills.
Free Course Exam
You can take your Learning Tree course exam on the last day of your course or online at any time after class and receive a Certificate of Achievement with the designation "Awarded with Distinction."
Standard Course Hours: 9:00 am – 4:30 pm
*Informal discussion with instructor about your projects or areas of special interest: 4:30 pm – 5:30 pm
FREE Online Course Exam (if applicable) – Last Day: 3:30 pm – 4:30 pm
By successfully completing your FREE online course exam, you will:
“The section on triggers and the presentation of the listagg function have proven to be very useful in my daily programming.”
- S. Der, Software Developer