Introduction to SQL — A 1 day course
Synopsis
This 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.
Note
There is an overlap between the content of this one day Introduction to SQL course and the content on the suggested follow-on Oracle and MySQL/MariaDB courses. You may wish to review the content of the three day Oracle SQL course, the three day Introduction to MySQL course or the three day Introduction to MariaDB course and if more suitable to your training needs attend one of those courses rather than this 1 day Introduction to SQL course.
Objectives
To provide the knowledge and skills needed to retrieve and update data held in a relational database. The delegates will practise:
- Creating SQL statements to query a database table
- Writing SQL statements to retrieve data from multiple tables
- Using standard aggregate functions
- Implementing Subqueries
Suitable For
Anyone who needs to understand and use SQL to manipulate a database.
Follow-On Courses
Prerequisites
There are no formal pre-requisites, although an understanding of databases and exposure to information technology in general would be useful. Some previous programming or database experience would be useful.
Publicly scheduled dates, locations, and prices
London — £425 (+VAT)
Contents
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
Summarising and Grouping Data
- Aggregate Functions
- The Group By Clause
- The Having Clause
- Practical Exercises
Querying Multiple Tables
- Joining Tables
- 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