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:Manchester, London
Next course:Tue 25 June 2019
Time:09.30-16.30

SCHEDULED DATES Course Contents - PDF

Course Contents

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

Why Choose Us?

No more than 6 people per class
Proper restaurant lunch included
514 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

"Excellent course which was run at a good pace for all participants. Facilities and lunch were great, a well thought out and well taught course. Would recommend."

Paul Langton (Greater Manchester Health and Social Care Partnership)

"Everything was excellent; delivery, pace and content. Having never had any kind of coding 'experience,' I feel I can apply basics back at the workplace, with familiar data. Recommended by colleagues. The trainer somehow managed to inject fun into what is deemed by many to be quite a dry topic!"

Chris Charlton (Leeds City Council)

"Really great course, resources were extremely helpful and great to have a helpful trainer. It was also great to ask questions that may be slightly off topic but would help with a day to day job."

Adam Lambert (WorldPay UK Ltd)

"Absolutely great course, would recommend to anyone! Manual is very thorough and helpful exercises will keep what we've learned ticking over. Online content will be extremely helpful. My line manager signed me up but I will definitely come back if I'm allowed."

Michael Littlehales (Virgin Media)

"Great training environment and very good trainer. Well paced course that included time to cover additional topics."

Steven Ford (Canterbury Christ Church University)

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

You will get more out of the course if you are already familiar with at least one relational database, whether built in Access or SQL Server.

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
Tue/Wed 25-26 June 2019	2	Manchester	£695	Book places
Tue/Wed 16-17 July 2019	2	London	£795	Fully booked
Tue/Wed 23-24 July 2019	2	Manchester	£695	Book places
Tue/Wed 13-14 August 2019	2	London	£795	Book places
Tue/Wed 03-04 September 2019	2	Manchester	£695	Book places
Tue/Wed 17-18 September 2019	2	London	£795	Book places
Tue/Wed 01-02 October 2019	2	Manchester	£695	Book places
Thu/Fri 17-18 October 2019	2	London	£795	Book places
Tue/Wed 05-06 November 2019	2	Manchester	£695	Book places
Tue/Wed 12-13 November 2019	2	London	£795	Book places
Thu/Fri 05-06 December 2019	2	Manchester	£695	Book places
Thu/Fri 19-20 December 2019	2	London	£795	Book places

Date(s)	Venue
25/06	Manchester
16/07	London
23/07	Manchester
13/08	London
03/09	Manchester
17/09	London
01/10	Manchester
17/10	London
05/11	Manchester
12/11	London
05/12	Manchester
19/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).