Back to Search Results

Training Course Summary:

This course gives a basic introduction to Oracle's version of SQL, introducing the concepts behind the SQL language and the basics of SQL*Plus.

Designed to introduce concepts and functionality in an accessible and friendly format, the course has been prepared to assist end-users understand how to retrieve and maintain information within a controlled Oracle 10g database environment.

Pre-Requisites:

PC Fundamentals

Who Should Attend:

Oracle SQL Users
ANSI SQL Users

Training Course Overview/Content:

Introducing Oracle
The Elements of the Oracle System
Relational Concepts
back to top
SQL*Plus and SQL Introduction
Logging on to SQL*Plus and Leaving SQL*Plus
Choosing and Describing Tables
Elements of the SQL Query
The SQL Buffer and Query Layout
Editing SQL Statements
The System Dummy Table
Selecting Columns
Duplicate Information (DISTINCT)
Sorting Information
back to top
SQL Functions
The Concatenation Operator
Elements of the SQL Query: Arithmetic
Column Aliases
String Functions
Arithmetic Functions
Date Functions
Mixed Functions
back to top
Advanced SQL Functions
Nesting Different Functions
SQL Bar Charts
Decode Crosstab
Decode with >, < & =
Select with Minus Union and Intersect
Connect By Prior
back to top
Filtering Data Using Where
Where Operators
Where with Keywords
Where and Logical Operators
Where and Soundex
back to top
Retrieve Data:Multiple Tables
Joining Tables (Equi-Joins)
Aliases for Table Names
Thinking behind Creating Joins
Joining Tables (Non-Equi-Joins)
Joining Tables (Outer Joins)
Joining Tables (Inner Joins)
back to top
Group By Functions
Group By Function Examples
Group By Functions with Having
back to top
Sub-Queries
Basic Subqueries
Multiple Column Subqueries
Subqueries with Having
Correlated Subqueries
Subquery Rules and Suggestions
back to top
Data Definition Language
Create, Drop Alter Keywords
Tables
Column
Views
Sequences
back to top
Data Manipulation Language
Insert
Update
Delete
back to top
SQL*Plus Reporting
Introducing SQL*Plus for Reporting
Using SQL*Plus