This course covers the use of ANSI-standard SQL, Oracle extensions to ANSI SQL, and Oracle's SQL*PLUS SQL interface. Students are presented with an overview of the Oracle development environment, Oracle's client/server model, and typical development  toolsets and environments.

Students will create data tables using Oracle table constraints to enforce referential integrity and learn the SQL language to insert, update, delete, and select data from the tables in the database. Students will learn how to control data sharing and locking, and develop an understanding of multi-user, concurrent transactions.

At the end of this course, the student will be prepared to: 

Describe Relational Databases and SQL. 

Use the SQL language to add, change and delete rows from structures in an Oracle database. 

Describe the basic architecture of an Oracle server.

This course will prepare candidates for the SQL topics in the first Oracle Certified Professional (OCP) exam.

Outline

I. Relational overview 

II. Oracle Server Architecture

III. Getting started with SQL

IV. Getting started with SQL Plus

V. Tables and Indexes

VI. Views, Synonyms, and More

VII. Database Constraints

VIII. SQL Operators

IX. Single Row Functions

X. Summary Data

XI. Building Advanced Queries

XII. Working with the Data

XIII. SQL*Plus reports