This course is designed for developers with basic SQL and PL/SQL language skills. This is a 5 days accelerated course specifically designed to provide students with an end-to-end training on programming with SQL and PL/SQL. This course starts by introducing the students with Oracle Database 10g technology, SQL and PL/SQL and then ends with providing them hands on training on advanced concepts such as develop stored procedures, functions, packages and database triggers.

Oracle Database 10g: SQL Fundamentals I is the first course of the bundle, which provides the essential SQL skills that allow students to write queries against single and multiple tables, manipulate data in tables, create database objects, and query meta data.

Oracle Database 10g: SQL Fundamentals II is the second course in the bundle in which students learn the advanced querying and reporting techniques. This also discusses schema objects that are useful for data warehousing and other application areas.

The third course of this bundle is Oracle Database 10g: PL/SQL Fundamentals. This course introduces students to PL/SQL and helps them understand the benefits of this powerful programming language. At this stage, students learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications.

Oracle Database 10g: Develop PL/SQL Program Units is the last course in which students learn to develop, execute and manage PL\SQL stored program units like procedures, functions, packages and database triggers. Students also learn to manage object dependencies and recompilation of invalid objects.