Data Deliverance Courseware

Oracle® 10g SQL Programming

Summary

This course is an introduction to the SQL database language used with Oracle® 10g databases. After this course the student will be able to use SQL to define, manipulate and control access to their data. The course thoroughly covers SQL syntax and facilities.

The course begins with a general introduction to databases, including the principles of relational databases. The Oracle SQL*Plus query tool is covered and will be used throughout the course. Data retrieval is discussed in depth, covering all of the pertinent features of SQL, including joins. Scalar and aggregate functions are covered. Data Manipulation Language is covered, including inserting, updating and deleting data. Transaction control and locking is discussed. Data Definition and Control statements are covered, including creating, altering and dropping tables, and the use of integrity constraints. Views and indexes are covered. The course concludes with an introduction to the reporting facilities in SQL*Plus.

Prerequisites
General familiarity with computers and data processing

Course Objectives
On completion of this course, the student should be able to
Intended Audience
Application developers, database administrators, system administrators and users who write applications and procedures that access an Oracle10g database.

Length
3 Days

Format
Instructor-led course, with practical computer-based exercises.

Course Outline

Hardware and Software Requirements

Course exercises require Oracle 10g running on a Microsoft Windows, Linux, or multi-user UNIX system. See the appropriate course Setup Guide for details.

A good minimal hardware profile for this course would have a Pentium 500-MHz or equivalent CPU, 512 MB of RAM, and at least 4 GB of free disk space for the Oracle installation.