Course Status:	Released	Courseware Features
Course Language:	English
Course Duration:	4 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 introduce Oracle as a relational database management system (RDBMS) and to discuss how to use basic SQL statements

Topics Covered

The Oracle database management system Relational database concepts Defining an entity relationship model Oracle RDBMS and ORDBMS Basic SQL statements Writing basic SQL statements SQL statement features in an Oracle 9i database The Oracle9i database iSQL*Plus environment Using iSQL*Plus in an Oracle9i database Restricting and sorting data The WHERE clause in Oracle databases The ORDER BY clause in Oracle databases Using WHERE and ORDER BY clauses in an Oracle database

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