Back to Search Results

Training Course Summary:

This intensive course is intended for IT professionals who already have a through knowledge of SQL in another relational database environment, but who are now working in an Oracle environment, including Application Developers, System Analysts, Database Administrators and Technical Support Personnel. This course gives delegates an understanding of Oracle’s relational and object relational database management systems through the powerful SQL language. The SQL commands, functions and operators supported by oracle as extensions to standard SQL are emphasised. Delegates learn to create and maintain database objects such as tables, indices, views, constraints and sequences. Delegates also learn to store and retrieve by using advanced techniques such as grouping sets, SET operators and hierarchical retrieval. Delegates also learn how to manipulate data. Finally, delegates learn to write SQL script files using iSQL*Plus tool and to generate report-like output.

Course objectives

On completing this course, delegates will be able to:
Describe the Oracle database architecture
Review Oracle SELECT statement syntax to retrieve data
Use the Oracle 9i single row and group functions
Retrieve data by using advanced techniques such as subqueries, SET operators, hierarchical queries and Grouping sets
Create and maintain database objects such as tables, views, indices, sequences and constraints
Use the Oracle9i extensions for data manipulation and data definition language statements
Control transactions (commit, rollback and savepoint)
Control user access to the database objects and data
Retrieve information from the Oracle data dictionary Use iSQL*Plus commands to enhance reporting
Write SQL script to generate SQL script files

Course outline

Overview of the Oracle Environment
The Oracle SELECT Statement
Oracle Single-row Functions and CASE Expressions
Group Functions with ROLLUP and CUBE Operations
Oracle SQL Set Operators Writing Sub-queries Hierarchical Retrieval
Creating and Managing Tables, Constraints and Indexes
Other Oracle Database Objects
Controlling Transactions
Controlling User Access
Using iSQL*Plus commands

Pre-Requisites:

Delegates must have a thorough working knowledge of standard ANSI SQL or SQL in another relational database environment. Familiarity with relational database concepts is also required.