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

	Describe the most commonly-used functions available in SQL
	Use character, number, and date functions in SELECT statements
	Use conversion functions
	Find online documentation for more information about functions as needed

	String functions
	Number functions
	Date functions
	Miscellaneous functions
	Conversion functions
	Combining functions

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

Windows NT® is a registered trademark of Microsoft Corporation.Oracle9i™ is a trademark of the Oracle Corporation.