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

	Create, modify, rebuild, and remove tables
	Use the TRUNCATE command
	Create, modify and drop constraints
	Use primary key constraints
	Use foreign key contraints
	Add comments to SQL scripts and schema objects

	Creating tables
	Relational and temporary tables
	Adding comments
	Changing table structures
	Renaming, truncating and dropping tables
	Constraints
	Primary key, unique and foreign key constraints
	Table level and check constraints
	Adding, modifying and dropping constraints

	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: Database Objects and User Security
	Oracle9i SQL 1Z0-007: SQL*Plus And iSQL*Plus Reporting and PL/SQL
	Oracle9i SQL 1Z0-007: Practice Exam

Oracle9i™ is a trademark of the Oracle Corporation.