computer training
enterprise training solutions

Home:: Oracle Training :: Training Classes

Oracle PL/SQL Training Class


oracle 10g dba certified

Tuition: $1,395.00

The PL/SQL training class has been designed for those application developers who are new to the Oracle RDBMS environment, and the course also provides those developers with a solid foundation which they can use to develop applications using PL/SQL. PL/SQL is the very lifeblood of virtually every Oracle application, making it an important concept for any student seeking employment in the database environment.

Upon completion of this foundation, the PL/SQL training class moves on to the relationship of PL/SQL to the Oracle database, the importance of building database level triggers, functions, packages and stored procedures.

Participants in the PL/SQL training class will also learn how errors can be propagated within the PL/SQL environment, and they will also learn important techniques required to deal with those errors. The course also includes an introduction to a number of built in Oracle packages which are part of the RDBMS package, allowing students to expand their knowledge of the concepts through hands on experience and work with real world PL/SQL applications.

Among the goals of the PL/SQL training course are the following:

  • Understanding and using PL/SQL commands
  • Understanding key PL/SQL concepts
  • Gaining hands on practical experience through the use of learning exercises and labs


Course Outline:

  • Overview
  • PL/SQL components and syntax
  • PL/SQL control structures
  • PL/SQL cursors
  • PL/SQL exception handling
  • PL/SQL stored program units
  • PL/SQL built-in packages
  • Database triggers
  • 10g new features
  • Miscellaneous tips and techniques
Oracle PL/SQL Training Class Schedule:
   
  3/12/07 - 3/14/07
  5/14/07 - 5/16/07
   
  Class Location:
  377 E. Butterfield Road
Suite 100
Lombard, IL 60148
     

 

 

 

Copyright © 2001-2010 CBT Planet All rights reserved. - Computer Based Training