• Identify the major structural components of Oracle Database 10g
• Retrieve row and column data from tables with the SELECT statement
• Create reports of sorted, restricted and aggregated data
• Run data manipulation language (DML) statements to update data in Oracle Database 10g
• Obtain metadata by querying the dictionary views
• Use PL/SQL programming constructs and conditional control statements
• Write PL/SQL code to interface with the database
• Design PL/SQL program units that execute efficiently
• Handle run-time errors
• Describe stored procedures and functions
Duration: 60 hrs