Overview
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.
This training may be available onsite; please contact us if you are interested.
Audience
- Oracle SQL Users
- ANSI SQL Users
Prerequisites
Course Outline
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 ">", "
The training course outline shown above is a standardised version representing all
the dates shown and may vary from the course you attend. You will be sent the actual
course outline when you enquire about a specific date.