Business Intelligence training - Introduction to SQL

SQL Training

SQL for Beginners Training Course

£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

Locations:London, Manchester
Next course:Thu 23 January 2020
Time:09.30-16.30

SCHEDULED DATES Course Contents - PDF

Course Contents

The content of this course are as follows:

Using SQL Server

Using Object Explorer
Hiding system objects

Creating databases - overview

Designing databases
Primary keys
Indexing fields

Working with tables

Creating tables
Allowing nulls or not
Identity fields

Database diagrams

Creating database diagrams
Joining tables with relationships

Simple Queries

Creating queries
Comments
Indentation and case

Setting criteria using WHERE

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

Outputting to Excel

Results, text and grid options
Copying and pasting column headings
Exporting using SQL
Exporting using the menu

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

More exotic joins

Cross joins
Full outer joins
Self 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
Using ALL, ANY and IN
Using EXISTS
Correlated subqueries

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 6 people per class
Proper restaurant lunch included
515 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

"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)

"Excellent course! Beginner to user straight in 2 days. Really enjoyed."

Fraser Dear (Marley Ltd)

"(Intro Power BI) Excellent pace for 2 days. Plenty of interaction and humour. Great lunch breaks. (DAX) Excellent course. Very well delivered on a "tricky" topic which could have sent me slightly mad. Great pace of delivery. This is the first time I felt I could do the same course again! (Advanced Power BI) Excellent delivery of a new course. Quick measures were very useful after the DAX course (a good compliment.)"

John Pelan (Coloplast Ltd)

"Great course with good content and pacing."

Alan Mort (Cheshire Datasystems Ltd)

"Great support material. Taught in a very digestible/relatable manner. "

Stephanie Gibb (WorldPay UK 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 Introduction to SQL courses we have scheduled for the next 3 months:

Dates	Days	Venue	Price	Booking
Thu/Fri 23-24 January 2020	2	Manchester	£695	Book places
Thu/Fri 30-31 January 2020	2	London	£795	Fully booked
Tue/Wed 18-19 February 2020	2	Manchester	£695	Book places
Thu/Fri 27-28 February 2020	2	Manchester	£695	Fully booked
Tue/Wed 03-04 March 2020	2	London	£795	Book places
Thu/Fri 19-20 March 2020	2	Manchester	£695	Book places
Thu/Fri 02-03 April 2020	2	London	£795	Book places
Tue/Wed 12-13 May 2020	2	Manchester	£695	Book places
Thu/Fri 28-29 May 2020	2	London	£795	Book places
Thu/Fri 04-05 June 2020	2	Manchester	£695	Book places
Thu/Fri 25-26 June 2020	2	London	£795	Book places
Tue/Wed 07-08 July 2020	2	Manchester	£695	Book places
Thu/Fri 13-14 August 2020	2	Manchester	£695	Book places
Tue/Wed 15-16 September 2020	2	Manchester	£695	Book places
Tue/Wed 22-23 September 2020	2	London	£795	Book places
Thu/Fri 15-16 October 2020	2	Manchester	£695	Book places
Tue/Wed 17-18 November 2020	2	Manchester	£695	Book places
Thu/Fri 26-27 November 2020	2	London	£795	Book places
Thu/Fri 17-18 December 2020	2	London	£795	Book places

Date(s)	Venue
23/01	Manchester
30/01	London
18/02	Manchester
27/02	Manchester
03/03	London
19/03	Manchester
02/04	London
12/05	Manchester
28/05	London
04/06	Manchester
25/06	London
07/07	Manchester
13/08	Manchester
15/09	Manchester
22/09	London
15/10	Manchester
17/11	Manchester
26/11	London
17/12	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).