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

	Use the WHERE clause to filter out rows from query results
	Format query results
	Use multiple filters in a query
	Query the DUAL table
	Sort query results using the ORDER BY clause
	Handle null values in query results

	Using the WHERE clause
	Formatting query results
	Using multiple filters
	Dual and pseudocolumns
	Using the ORDER BY clause
	Sorting rules for null values

	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: 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 SQL 1Z0-007: Practice Exam

Oracle9i™ is a trademark of the Oracle Corporation.