Learning Outcomes

By the end of the course, participants will be able to:

• Use the ISQL*Plus web-based database interface and other traditional interfaces
• Write simple SQL queries and moderately complex SQL queries
• Summarize, group and sort data
• Handle advanced query techniques such as correlated sub queries
• Develop simple SQL*Plus reports
• Create database tables
• Maintain database tables
• Take advantage of new features such as the use of regular expressions
• Move beyond basic table definitions, consideration of defining the full range of database objects
• Employ the basic database security and object privileges
• Use the powerful set of built-in SQL functions
• Protect the database
• Extend the basic data model using declarative constraints
• Perform advanced SQL queries such as grouping and cube operations and SQL99 join syntax
• Develop complex SQL*Plus reports and using SQL*Plus scripts
• Use the SQL99 joins syntax