Back to Search Results

Training Course Summary:

Delegates:

This course is designed for anyone who needs to access and work with an Oracle Database.

In conjunction with the Oracle PL/SQL course, this course is suitable for delegates intending to sit the; Introduction to Oracle: SQL and PL/SQL Oracle Certified Professional examination (1Z0-001).

In conjunction with the Oracle9i SQL Advanced course, this course is suitable for delegates intending to sit the; Introduction to Oracle9i: SQL Oracle Certified Professional examination (IZ0-007).

Objectives:

By the end of this course, the delegate will be able to:
Use the command line features of SQL*Plus and iSQL*Plus
Create complex SQL statements to select and analyze data from an Oracle Database
Use SQL*Plus control and run time parameters
Create and alter tables, indexes and views
Create, update and delete records
Grant and revoke user access privileges
Access the Data Dictionary

Topics Covered:

The Basic SQL Select Statement
Selecting Data from Multiple Tables
Inner Joins, Outer Joins and Self Joins
Hierarchical Queries
Sub-queries
Grouping and Sorting Output
CUBE and ROLLUP features
Character, Date and Numeric Functions
Run-time Parameters and Variables
SQL*Plus Control Parameters
Creating and Changing Tables and Views
Constraints and Indexes
Inserting, Updating and Deleting Data
Multi-Table Inserts and Merges
Basic Transaction Control
Controlling Access to the Database
Related Data Dictionary Tables and Views

Requirements:

Experience of using SQL with another relational database is required

Follow-On Courses:

PL/SQL

DBA Part I - Architecture & Administration