Loading...

Oracle 9i SQL for Users

Course code: O015

3 days

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.

Course content >

Who Should Attend?

Everybody

Prerequisites

None

Course Contents

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.

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
Contact us for more information