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 Oracle PL/SQL course was informative and opened me up to tasks I hadn’t previously done in my job. My new knowledge and skills have created new opportunities for me. The instructor was very engaging and used lots of real-world examples, which was very useful.”
- M. Faridi, Senior Programmer/Analyst