This Oracel PL/SQL training course will teach you to increase the productivity, performance, scalability, portability, and security of your Oracle database. With this training, you will learn how to execute PL/SQL programs in Oracle, build stored procedures, design and execute modular applications, and increase the efficiency of data movement — essential skills for any Oracle developer.
TRAINING AT YOUR SITE
Our FlexVouchers help you lock in your training budgets without having to commit to a traditional 1 voucher = 1 course classroom-only attendance. FlexVouchers expand your purchasing power to modern blended solutions and services that are completely customizable. For details, please call 888-843-8733 or chat live.
*Events with the Partial Day Event clock icon run longer than normal but provide the convenience of half-day sessions.
Aug 10 - 14 9:00 AM - 4:30 PM EDT Online (AnyWare) Reserve Your Seat
Oct 5 - 9 9:00 AM - 4:30 PM EDT New York / Online (AnyWare) Reserve Your Seat
Dec 7 - 11 9:00 AM - 4:30 PM EST Ottawa / Online (AnyWare) Reserve Your Seat
Jan 11 - 15 9:00 AM - 4:30 PM MST Denver / Online (AnyWare) Reserve Your Seat
Feb 8 - 12 9:00 AM - 4:30 PM EST Herndon, VA / Online (AnyWare) Reserve Your Seat
Mar 22 - 26 9:00 AM - 4:30 PM EDT New York / Online (AnyWare) Reserve Your Seat
Guaranteed to RunWhen you see the "Guaranteed to Run" icon next to a course event, you can rest assured that your course event — date, time — will run. Guaranteed.
Partial Day EventLearning Tree offers a flexible schedule program. If you cannot attend full day sessions, this option consists of four-hour sessions per day instead of the full-day session.
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
This course is currently running on Oracle 12c.
Yes! We know your busy work schedule may prevent you from getting to one of our classrooms which is why we offer convenient online training to meet your needs wherever you want, including online training.