Oracle 11g SQL for Users

Course code: O013

3 days £1,080.00

+ VAT

This iTrain Oracle 11g SQL for Users 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?

Oracle SQL Users
ANSI SQL Users

Prerequisites

PC Fundamentals

iTrain also offer all of these courses as closed courses on your site. Please call 020 7608 1835

COURSE DATES

22 Feb 2012	Edinburgh	Delegates:	£1,080.00
27 Feb 2012	Reading	Delegates:	£1,080.00
14 Mar 2012	Reading	Delegates:	£1,080.00
21 Mar 2012	Swindon	Delegates:	£1,080.00
26 Mar 2012	Edinburgh	Delegates:	£1,080.00
02 Apr 2012	London	Delegates:	£1,080.00
11 Apr 2012	Reading	Delegates:	£1,080.00
25 Apr 2012	Edinburgh	Delegates:	£1,080.00
09 May 2012	London	Delegates:	£1,080.00
16 May 2012	Reading	Delegates:	£1,080.00
23 May 2012	Edinburgh	Delegates:	£1,080.00
13 Jun 2012	Reading	Delegates:	£1,080.00
27 Jun 2012	Swindon	Delegates:	£1,080.00

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 Oracle 11g 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

Retrieving Data from Multiple

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 and Group By Function

Group Function Examples
Group Function 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