Anyone who needs to understand and use SQL to manipulate a database.
There are no formal pre-requisites for this Introduction to SQL course, although an understanding of databases and exposure to information technology in general would be useful.

• Creating SQL statements to query a database table
• Writing SQL statements to retrieve data from multiple tables
• Using standard aggregate functions
• Implementing Subqueries

Session 1: RELATIONAL DATABASE CONCEPTS

• What is a Relational Database?
• Tables, Rows and Columns
• Indexes, Primary Keys and Foreign Keys
• Data Types
• The Data Dictionary
• Getting Started

Session 2: SQL LANGUAGE ESSENTIALS

• The Select Statement
• The Select and From Clauses
• Conditions and the Where Clause
• The Order By Clause
• Arithmetic Operations
• Column Aliases

Session 3: SUMMARISING AND GROUPING DATA

• Aggregate Functions
• The Group By Clause
• The Having Clause

Session 4: QUERYING MULTIPLE TABLES

• Joining Tables Inner Joins
• Column Qualification and Table Aliases
• Outer Joins
• Self Joins
• Alternative Join Syntax

Session 5: ADDITIONAL SQL FEATURES

• Combining Queries
• The Union, Intersect and Minus Operators
• Basic Subqueries

• OSI, Oracle SQL