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 describe how to define database objects and manipulate the data stored within them in an Oracle9i database

Topics Covered

Creating and managing tables and constraints Creating and managing Oracle9i database tables Including constraints in an Oracle9i database Creating tables and constraints in Oracle9i Managing views, indexes, sequences, and synonyms Oracle database views Oracle database sequences, indexes, and synonyms Oracle9i database external tables Creating Oracle views, indexes, sequences, and synonyms Data manipulation Manipulating data in Oracle9i databases Using DML statements in an Oracle9i database Database transactions in Oracle9i databases Extensions to DML in Oracle9i databases

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