After completing this course, the user should be able to:

	Answer practice questions in the format of the 1Z0-007 Introduction to Oracle 9i SQL exam
	Assess readiness to take the exam and identify topic areas requiring further practice

	SQL Plus reports
	Writing basic SQL select statements
	Restricting and sorting data
	Single-row functions
	Displaying data from multiple tables
	Aggregating data using group functions
	Subqueries
	Producing readable output with iSQL Plus
	Manipulating data
	Creating and managing tables
	Including constraints
	Creating views
	Creating other database objects
	Controlling user access

	Exercises that allow users to practice the application
	A file containing the text of the exercises
	Simulations that allow users to practice course skills, even if they don't have access to the application
	A glossary
	A Skill Assessment

	Oracle9i SQL 1Z0-007: Introduction to SQL
	Oracle9i SQL 1Z0-007: Intermediate Queries
	Oracle9i SQL 1Z0-007: Queries with Single-Row Functions
	Oracle9i SQL 1Z0-007: Combining Tables
	Oracle9i SQL 1Z0-007: Grouping and Summarizing Data
	Oracle9i SQL 1Z0-007: Advanced Queries and Views
	Oracle9i SQL 1Z0-007: Working with Data
	Oracle9i SQL 1Z0-007: Creating Tables and Constraints
	Oracle9i SQL 1Z0-007: Database Objects and User Security
	Oracle9i SQL 1Z0-007: SQL*Plus And iSQL*Plus Reporting and PL/SQL

Oracle9i™ is a trademark of the Oracle Corporation.