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

	Explain how group functions work
	Use aggregate functions
	Use DISTINCT and ALL clauses
	Group and sort rows using the GROUP BY clause
	Use the HAVING clause to restrict data
	Use the ROLLUP, CUBE, and GROUPING SETS clauses

	The GROUP BY clause and group functions
	Aggregate functions
	Grouping rows and sorting with GROUP BY
	Restricting Data
	Extending the GROUP BY clause

	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: 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.