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