Course Status:	Released	Courseware Features
Course Language:	English
Course Duration:	5 Hours
Deployment Options:	Online, Interactive CDs, Network, Downloads, Intranet

Audience

Junior database administrators, application developers, and database operators

Prerequisites

Familiarity with RDBMS technologies and programming techniques

Course Aim

This learning path provides an introduction for using SQL statements in an Oracle9i(TM) database. The learning path maps to Exam #1Z0-007: Introduction to Oracle9i: SQL. It comprises interactive graphical lessons, coding simulations, and mentored exercises.

Learning Objectives

To describe how to use SQL functions for data retrieval

Topics Covered

Single-row functions Oracle9i database character, number, and date functions Oracle9i database conversion functions Oracle9i database nested and conditional functions Using single-row functions in an Oracle9i database Date conversion in an Oracle9i database Displaying data from multiple tables Retrieving data from multiple Oracle9i database tables Using SQL 1999: join syntax Using Oracle9i database joins to retrieve data SET operators in Oracle databases Datetime and group functions Oracle database group functions The Oracle database GROUP BY clause Using Oracle database group functions GROUP BY clause enhancements in Oracle9i databases Using Oracle9i database GROUP BY enhancements Oracle9i database datetime functions

About Eno.com | Help | Terms of Use | Site Search | Contact Us | Site Map
Copyright © 1996-2002 E&A Inc. All rights reserved.