Oracle Database Training
Introduction to SQL
Overview
The Introduction to SQL course is designed to give delegates practical experience in using ANSI standard SQL. As it is a generic course, some of the differences between different vendors' implementations will be noted.
Prerequisites
Some previous programming or database experience would be useful.
Objectives
To provide the knowledge and skills needed to retrieve and update data held in a relational database.
Outline
Course Contents - DAY 1
Course Introduction
- Administration and Course Materials
- Course Structure and Agenda
- Delegate and Trainer Introductions
Session 1: RELATIONAL DATABASE CONCEPTS
- What is a Relational Database?
- Relational Database Structures
- Tables, Rows and Columns
- Indexes, Primary Keys and Foreign Keys
- Data Types
- The Data Dictionary
Session 2: RETRIEVING DATA WITH THE SELECT STATEMENT
- The Select Statement
- The Select and From Clauses
- Conditions and the Where Clause
- Other Conditional Operators
- Logical Operators
- The Order By Clause
- Column Aliases
- Arithmetic Operations
- Precedence of Operators
Session 3: AGGREGATE FUNCTIONS
- Overview of Built in Aggregate Functions
- The Group By Clause
- The Having Clause
Session 4: JOINING TABLES
- Overview of Table Joins
- Inner Joins
- Table Aliases
- Outer Joins
- Self Joins
- ANSI Join Syntax
Session 5: BASIC SUBQUERIES AND SET OPERATORS
- Overview of Subqueries
- Basic Subqueries
- Set Operators