Oracle Database: SQL and PL/SQL Fundamentals (D80198)

Application Developers
Forms Developer
Technical Consultant
Functional Implementer
Portal Developer
Reports Developer
PL/SQL Developer

Run data definition language (DDL) statements to create and manage schema objects
Run data manipulation statements (DML) to update data in the Oracle Database
Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
Use cursors to process rows
Create reports of sorted and restricted data
Describe stored procedures and functions
Describe the features and syntax of PL/SQL
Design PL/SQL anonymous block that execute efficiently
Display data from multiple tables using the ANSI SQL 99 JOIN syntax
Create reports of aggregated data
Employ SQL functions to generate and retrieve customized data
Handle runtime errors
Retrieve row and column data from tables with the SELECT statement