Oracle Database 11g: SQL Fundamentals I

• Employ SQL functions to generate and retrieve customized data
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• Identify the major structural components of the Oracle Database 11g
• Create reports of aggregated data
• Write SELECT statements that include queries
• Retrieve row and column data from tables with the SELECT statement
• Run data manipulation statements (DML) to update data in the Oracle Database 11g
• Create tables to store data
• Utilize views to display and retrieve data
• Write multiple-column sub-queries
• Use scalar and correlated sub-queries Use
• the regular expression support in SQL
• Create reports of sorted and restricted data 

Oracle Database 11g: Program with PL/SQL

• Create and debug stored procedures and functions
• Use conditional compilation to customize the functionality in a PL/SQL application without removing any source code
• Design PL/SQL packages to group related constructs
• Create overloaded package subprograms for more flexibility
• Design PL/SQL anonymous blocks that execute efficiently
• Use the Oracle supplied PL/SQL packages to generate screen output, file output and mail output
• Write dynamic SQL for more coding flexibility
• Describe the features and syntax of PL/SQL
• Use PL/SQL programming constructs and conditionally control code flow (loops, control structures, and explicit cursors)
• Manage dependencies between PL/SQL subprograms
• Handle runtime errors
• Create triggers to solve business challenges
• Design PL/SQL code for predefined data types, local subprograms, additional pragmas, standardized constants and exceptions

 Oracle Database 11g: Advanced PL/SQL 

• Design PL/SQL packages and program units that execute efficiently
• Write code to interface with external applications and the operating system
• Create PL/SQL applications that use collections
• Write and tune PL/SQL code effectively to maximize performance
• Implement a virtual private database with fine-grained access control
• Write code to interface with large objects and use SecureFile LOBs