Events

Provides the knowledge and skills needed to retrieve and analyse data held in a database.  

Who Should Attend

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

Course Outline

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

SQL Language Essentials

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

Summarizing and Grouping Data

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

Querying Multiple Tables

• Joining Tables with Inner Joins
• Column Qualification and Table Aliases
• Outer Joins, Self Joins, Alternative Join Syntax
• Practical Exercises

Additional SQL Features

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