Introduction to SQL — A 1 day course

contact usEnquire about this 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:

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

Select a date to enquire about availability of places. For dates after 1 February 2017, please call 0333 210 0140 or use our contact form to enquire about places and availability.

Birmingham — £425 (+VAT)

London — £425 (+VAT)

Manchester — £425 (+VAT)


Contents

Relational Database Concepts

SQL Language Essentials

Summarising and Grouping Data

Querying Multiple Tables

Additional SQL Features