Our training for Oracle PL/SQL Developer will prepare you for the certification exam, and will help you improve your efficiency and performance. When you acquite the Oracle PL/SQL Developer Certified Associates certification you have demonstrated expertise in building database-centric Internet applications for Oracle 10g & 11g databases.
PL/SQL (Procedural Language/Structured Query Language) is a programming language embedded in the Oracle databasea. PL/SQL is required to create procedures, database triggers, packages and functions.
 Our Training Includes
24 x 7 Unlimited Online Access
Full Multi Media Lessons
Simulated Exercises to test ones understanding.
Review Questions to test ones retention
Printable Transcripts of Lessons
Certification Path
- 1Z0-047 Oracle Database SQL Expert
- 1Z0-051 Oracle Database 11g: SQL Fundamentals I
- 1Z0-144 Oracle Database 11g: Program with PL/SQL
Course Outline
Z0-051 Oracle Database 11g: SQL Fundamentals I
- Using SQL to Query Your Database
- Conversion Functions, Group Functions, and Joins
- Subqueries, Set Operators, and Data Manipulation
- Using DDL, Views, Sequences, Indexes, and Synonyms
1Z0-047 Oracle Database SQL Expert
- Using SQL to Query
- Conversion Functions, Group Functions, and Joins
- Subqueries, Set Operators, and Data Manipulation
- Using DDL, Views, Sequences, Indexes, and Synonyms
- Controlling User Access and Managing Schema Objects
- Data Dictionary Views and Large Data Sets
- Managing Data in Different Time Zones
- Using Subqueries and Regular Expressions
1Z0-144 Oracle Database 11g: Program with PL/SQL
- Getting Started
- Using DML, DDL, Cursors, Control Structures, and Loops
- Using Data Types, INDEX BY Tables, and Cursors in PL/SQL
- Working with Exceptions, Subprograms, JDeveloper, and REF Cursors
- Subprograms, Packages, and Exception Handling
- Packages, Dynamic SQL, and Coding Considerations
- Using Triggers and the PL/SQL Compiler
- PL/SQL Code and Dependencies
|
