Classroom Training

Introduction to SQL

Classroom training course - online version also available

£695 + VAT for most venues (£795 + VAT for London)

2 days

You can use SQL to retrieve information from your corporate database (providing, of course, that you understand its structure). This two-day introductory course will show you how to create tables in SQL Server, and then how to write SQL to extract information from them. You'll learn about the WHERE clause (for setting criteria); the ORDER BY clause; how to aggregate data using GROUP BY; and how to create inner, outer and full joins!

Course details

Possible locations:London, Manchester, Online
Next classroom course:Thu 26 November 2020
Time:10.00-16.30

SCHEDULED DATES Course Contents - PDF

Course Contents

The contents of this course are as follows:

Using SQL Server

SQL Server Management Studio
Controlling windows
Using Object Explorer

Creating databases - overview

Designing databases
Primary keys

Working with tables

Creating tables
Allowing nulls or not
Identity fields
Creating relationships

Query Designer

Building queries
Editing queries in the designer

Simple Queries

Creating queries
Comments
Indentation and case

Setting criteria using WHERE

Wildcards (% and _)
Setting criteria for dates
Coping with nulls

Calculations

Calculated columns
Using aliases
String functions and concatenation

Calculations using dates

GetDate
Converting dates
Useful date functions

Basic joins

Inner joins
Table aliases
Left and right outer joins

Aggregation and grouping

SUM, AVG, MIN, MAX
Various ways to count
Grouping by fields
Using HAVING to filter results

Views

The view designer
Limitations of the designer
Scripting views

Covered if time allows If time

Subqueries

The concept of a subquery
Syntax of subqueries
Using subqueries in a query

Covered if time allows If time

Derived tables and CTEs

Using derived tables
Common Table Expressions (CTEs)
Multiple CTEs in a single query

There aren't any pre-requisites for this course, although you'll find it easier if you've already seen a relational database (one with lots of tables joined together). The course uses SQL Server Management Studio, although if you're booking an onsite SQL course we will on request use Azure Data Studio instead.

Why Choose Us?

No more than 5 people per class
Proper restaurant lunch included
528 references viewable online
Free USB stick containing course files
Genuine Wise Owl trainers only
Unbelievably good courseware

View full list of benefits

Sample customer feedback

Our thanks to everyone who agreed to share their thoughts (note that some of these reviews may be for our online courses).

"The trainer was great; really knowledgeable, enthusiastic and explained everything I asked him to. Colleagues recommended Wise Owl courses..... I can see why."

Lyndsey Bell (Greater Manchester Fire & Rescue Service)

"Great delivery of course, very knowledgeable and very helpful. This is the second course I have been on in the last 3 months, both have helped me enormously. Thank you!"

Deanne Yates (Manchester University NHS Foundation Trust)

"Very impressed. Great interactive course and well thought out structure. Small group gives real value."

David Bendy (Wiggin LLP)

"Loved the small group size and content. Great trainer & days well planned & spaced out. Recommendation came from a colleague."

Lianne Pierre John (Barbican Insurance / Arch Capital Gp Ltd)

"Excellent as always."

Lisa De Prudhoe (DataQ Ltd)

There are lots more where these came from (or just refresh this page to change the quotes shown).

Scheduled Introduction to SQL training dates

Here are the classroom Introduction to SQL courses we have scheduled for the next 3 months:

Dates	Days	Venue	Price	Booking
Thu/Fri 26-27 November 2020	2	London	£795	Book places
Thu/Fri 28-29 January 2021	2	Manchester	£695	Book places
Thu/Fri 04-05 February 2021	2	London	£795	Book places
Wed/Thu 03-04 March 2021	2	Manchester	£695	Book places
Tue/Wed 13-14 April 2021	2	London	£795	Book places
Tue/Wed 11-12 May 2021	2	Manchester	£695	Book places
Tue/Wed 22-23 June 2021	2	London	£795	Book places
Tue/Wed 22-23 June 2021	2	Manchester	£695	Book places
Thu/Fri 29-30 July 2021	2	Manchester	£695	Book places
Thu/Fri 19-20 August 2021	2	London	£795	Book places

Date(s)	Venue
26/11	London
28/01	Manchester
04/02	London
03/03	Manchester
13/04	London
11/05	Manchester
22/06	London
22/06	Manchester
29/07	Manchester
19/08	London

All prices exclude VAT. If you can't see the dates you want, ask us about running onsite SQL training at your offices (we'll even provide and set up the computers).