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:Tue 23 October 2018
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
492 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

"Good pace and explanations. Mix of exercises good too. I’m now booked in for the SSIS course in a few weeks, which is testament to the quality of the course!"

Steven Sharp (Penguin Random House Group Ltd)

"Good pace, knowledgeable tutor."

Bruce Moyes (Merlin Entertainments Group Ltd)

"Great website, easy to use and informative."

Claire White (DFDS Seaways)

"I gotta say that from someone who wasn’t looking forward to the course, I’m not a techy person so I was worried I would struggle, I actually really enjoyed the course. Not only is the trainer a very nice guy who is very good at putting people at ease but he is also a great trainer and really helped me to understand the course content. He had everything prepared really well, no waiting about for him to give us exercises to do. I don’t think he had a question he couldn’t answer for us and he structured the day well too and everything fitted in nicely with the schedule he gave us at the beginning of the course. He was also keen to show us your website and the helpful videos that we can look to after the course if we needed to refresh our memories. I also liked the little freebies he provided like the USB stick (really helpful for taking all you did on the course home) and the exercise and course books. Then sweets/chocolate was another good touch. I’ve always tried to steer myself away from getting too technical as I don’t have that kind of mind and hence I find it all a little boring and I knew of SQL before the course and never found it interesting but the trainer was able to keep me fully engaged and interested. If we ever need a course that you guys cover, I will definitely be pushing my boss to go with you guys again. "

Martin Mitchell (Penguin Random House Group Ltd)

"Easy to use website, good location, good material."

Yiannis Theologos Michelus (Adsensa)

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 23-24 October 2018	2	London	£795	Fully booked
Thu/Fri 15-16 November 2018	2	Manchester	£695	Book places
Tue/Wed 04-05 December 2018	2	London	£795	Book places
Thu/Fri 13-14 December 2018	2	Manchester	£695	Book places
Tue/Wed 08-09 January 2019	2	London	£795	Book places
Tue/Wed 29-30 January 2019	2	Manchester	£695	Book places
Tue/Wed 19-20 February 2019	2	London	£795	Book places
Thu/Fri 28th Feb/1st March 2019	2	Manchester	£695	Book places
Tue/Wed 26-27 March 2019	2	London	£795	Book places
Tue/Wed 09-10 April 2019	2	Manchester	£695	Book places

Date(s)	Venue
23/10	London
15/11	Manchester
04/12	London
13/12	Manchester
08/01	London
29/01	Manchester
19/02	London
28/02	Manchester
26/03	London
09/04	Manchester

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