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 01 October 2019
Time:09.30-16.30
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
If time
Subqueries
- The concept of a subquery
- Using ALL, ANY and IN
- Using EXISTS
- Correlated subqueries
If time
Derived tables and CTEs
- Using derived tables
- Common Table Expressions (CTEs)
- Multiple CTEs in a single query
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.
Why Choose Us?
No more than 6 people per class- Proper restaurant lunch included
- 513 references viewable online
- Free USB stick containing course files
- Genuine Wise Owl trainers only
- Unbelievably good courseware
Sample customer feedback
Sophie Kelly (Liverpool City Council)
Jamie Devonshire (Hoist Finance)
Michelle Vandyke (NHS South, Central and West CSU)
Natalie Heppenstall (Royal College of Veterinary Surgeons)
Amy Thorpe (Retail Insight (RI))
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 |
|---|---|---|---|---|
| Tue/Wed 01-02 October 2019 | 2 | Manchester | £695 | Book places |
| Thu/Fri 17-18 October 2019 | 2 | London | £795 | Book places |
| Mon/Tue 04-05 November 2019 | 2 | Manchester | £695 | Book places |
| Thu/Fri 14-15 November 2019 | 2 | London | £795 | Book places |
| Thu/Fri 05-06 December 2019 | 2 | Manchester | £695 | Book places |
| Thu/Fri 12-13 December 2019 | 2 | London | £795 | Book places |
| Thu/Fri 09-10 January 2020 | 2 | Manchester | £695 | Book places |
| Thu/Fri 30-31 January 2020 | 2 | London | £795 | Book places |
| Tue/Wed 18-19 February 2020 | 2 | Manchester | £695 | Book places |
| Tue/Wed 25-26 February 2020 | 2 | London | £795 | Book places |
| Thu/Fri 26-27 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 |
| Tue/Wed 19-20 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 |
|---|---|
| 01/10 | Manchester |
| 17/10 | London |
| 04/11 | Manchester |
| 14/11 | London |
| 05/12 | Manchester |
| 12/12 | London |
| 09/01 | Manchester |
| 30/01 | London |
| 18/02 | Manchester |
| 25/02 | London |
| 26/03 | Manchester |
| 02/04 | London |
| 12/05 | Manchester |
| 19/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).
Related Courses
Other SQL training resources
SQL exercises
All of our SQL exercises are based on simple and interesting databases, as these exercises testify.
View SQL exercises
SQL videos
Learn SQL either by attending this two-day introduction course, or by looking at some of our SQL videos online.
View Selecting data in SQL, SQL Server 2016, Advanced SQL (programming) or SQL Server 2017 videos
SQL skills assessment
Find out how well you know SQL by taking one of our skills assessment tests.
View Test your SQL skills skills assessment tests
SQL blogs
Look through our blogs on SQL - there's even a full tutorial on SQL online.
View SQL blogs