Oracle 9i SQL for Users (O015) Training Course

Training Course Objectives

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 Oracle9i database environment.

Who Should Attend

• Oracle SQL Users
• ANSI SQL Users

Training Course Prerequisites

• PC Fundamentals
• View Learning Path

Training Course Duration

3 Days

Training Course Contents

Oracle Overview

• Introducing Oracle
• The Elements of the Oracle System
• Relational Concepts

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

SQL Functions

• The Concatenation Operator
• Elements of the SQL Query: Arithmetic
• Column Aliases
• String Functions
• Arithmetic Functions
• Date Functions
• Mixed Functions

Advanced SQL Functions

• Nesting Different Functions
• SQL Bar Charts
• Decode Crosstab
• Decode with >, < & =
• Select with Minus Union and Intersect
• Connect By Prior

Filtering Data Using Where

• Where Operators
• Where with Keywords
• Where and Logical Operators
• Where and Soundex

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)

Group By Functions

• Group By Function Examples
• Group By Functions with Having

Sub-Queries

• Basic Subqueries
• Multiple Column Subqueries
• Subqueries with Having
• Correlated Subqueries
• Subquery Rules and Suggestions

Data Definition Language (DDL)

• Create, Drop Alter Keywords
• Tables
• Column
• Views
• Sequences

Data Manipulation Language

• Insert
• Update
• Delete

SQL*Plus Reporting

• Introducing SQL*Plus for Reporting
• Using SQL*Plus

Next Available Dates

iTrain delivers this course as company specific training. Please contact us for more information or course dates.