Oracle 11g/12c Developer: PL/SQL Complete
Duration: 5 Days
This course will cover the Oracle 11g/12c PL/SQL programming language. You will be able to control data sharing and locking, develop an understanding of multi-user and concurrent transactions and develop triggers, procedures, functions and packages.
This course can also be presented with content specific to Oracle 10g.
Topics Covered In This Course
Introduction to PL/SQL
Working with Database Data
Selecting Multiple Rows Using Cursors
Introduction to Procedures and Functions
Creating DML Triggers
PL/SQL Composite Datatypes and Collections
Bulk-Bind Data Loading Using PL/SQL
Using Oracle Supplied Packages
Writing Native Dynamic SQL
Large Object Management in PL/SQL
Java in PL/SQL
What You Can Expect
On successfully completing this course, participants can expect to be able to:
Who Should Take This Course
Application Developers and Database Administrators who need a comprehensive understanding of Oracle 11gR2 PL/SQL language and those seeking OCA or OCP certification.
Oracle 11gR2 Foundation: SQL Basics & SQL*Plus or equivalent experience.
Short lecture sessions (60%) along with hands-on lab sessions (40%).
Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]