Course 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.
Who should attend
Anyone who needs to understand and use SQL to manipulate a database.
Prerequisites
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.
Course Objectives
- Creating SQL statements to query a database table
- Using standard aggregate functions and related SELECT statement clauses
- Joining Tables
- Using basic subqueries and the set operators
English