Back to Search Results

Training Course Summary:

Describe the relational aspects of Oracle database management systems
Retrieve data in an Oracle database
Use iSQL*Plus to execute SQL statements

Pre-Requisites:

Familiarity with a graphical user interface (GUI)
Familiarity with data processing concepts and techniques

Training Course Overview/Content:

Relational Principals and Oracle Concepts
Describing the Lifecycle Development Phases
Discussing the Theoretical and Physical Aspects of a Relational Database
Describing the Oracle Implementation of the RDBMS and ORDBMS
Describing the Features of Oracle8i
Describing New Features of Oracle9i
Describing How SQL Is Used in the Oracle Product Set

Writing Basic SQL Statements
Listing the Capabilities of SQL SELECT Statements
Executing a Basic SELECT Statement
Differentiating Between SQL Statements and iSQL*Plus Statements

Restricting and Sorting Data
Limiting the Rows Retrieved by a Query
Sorting the Rows Retrieved by a Query

Single-Row Number and Character Functions
Describing the Various Types of Functions Available in SQL
Using Character and Number Functions in SELECT Statements

Single-Row Date and Conversion Functions
Using SYSDATE in Conjunction with SELECT Statements
Arithmetic Operations with Dates
Describing Conversion Functions Available in SQL
Using Date Functions in SELECT Statements

Displaying Data from Multiple Tables
Writing SELECT Statements Using Equality and Nonequality Joins to Access Data from More Than One Table
Describing the Cartesian Product
Joining a Table to Itself
Natural Join and Cross Join

Aggregating Data Using Group Functions
Identifying the Available Group Functions
Describing the Use of Group Functions
Using the GROUP BY Clause to Group Data

Writing Subqueries
Describing the Types of Problems that Subqueries Can Solve
Defining Subqueries
Listing the Types of Subqueries
Writing Single-Row and Multiple-Row Subqueries

iSQL*Plus
Producing Queries that Require an Input Variable
Customizing the iSQL*Plus Environment
Producing More Readable Output
Creating and Executing Script Files