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 technology, SQL and PL/SQL and then ends with providing hands on training on advanced concepts such as developing stored procedures, functions, packages and database triggers.
Oracle Database: 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: 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: 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: 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.
This is appropriate for a 10g audience too. There are few minor changes between 10g and 11g features.
Learn To:
- Create reports of sorted and restricted data
- Run data manipulation statements (DML) to update data
- Control database access to specific objects
- Create anonymous PL/SQL blocks of code
- Create triggers to solve business challenges
- Retrieve row and column data from tables
|
