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

	Create a well formatted report with SQL Plus
	Know when and how to use variables
	Use iSQL Plus
	Use Top-N Analysis
	Identify the basic concepts of PL/SQL

	SQL Plus reports
	Environment settings
	Using environment settings
	Variables and scripts
	Generating reports
	Reporting features
	Running reports
	Top-N queries
	PL/SQL
	Retrieving data in PL/SQL
	Dynamic SQL
	Control structures
	Iteration and repitition

	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: Practice Exam

Oracle9i™ is a trademark of the Oracle Corporation.