# # # #

Service Center

Oracle Certification Training Course for PL SQL Developer Associate Online or CD

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