WiseOwl Training - Established 1992 Wise Owl Training

Established May 1992
30 years in business
Wise Owl Training
30 years in business
See 482 reviews for our classroom and online training
Classroom training -  Introduction to SQL

Classroom Training

Introduction to SQL

Classroom training course - online version also available

£850 + VAT for most venues (£995 + 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 for Introduction to SQL coursesPossible locations:London, Manchester, Online
  • Next Introduction to SQL course locationNext classroom course:Wed 15 June 2022
  • Introduction to SQL course timesTime:09:30-16:30

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?

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

"Our trainer was fantastic, went at a good pace, was patient and great at explaining the examples."

Ganesh Patel (e-foods)

"Thanks for running with just one person on the course. I have been on a few Wise Owl courses before and enjoy the style/approach employed (course materials, writing style, atmosphere in the classroom etc.)"

Magnus Windsor (Coloplast Ltd)

"Amazing enthusiasm from the course tutor, made learning a pleasure."

Idris Whitlock (Unity College)

"The trainer was absolutely amazing! Clear, easy content to follow and understand. My line manager said she enjoyed her SQL course with Wise Owl and after attending, I can see why."

Jattu Kallon (CFC Underwriting)

"Great course, useful content, fun trainer. Moved at a good pace. Really enjoyed it and will recommend to colleagues. (Loved the lunches - nice touch!) Colleague's recommendation - who had previously attended."

Sarah Berryman (Southbank Centre)

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
Wed/Thu 15-16 June 2022 2 £850 Fully booked
Tue/Wed 12-13 July 2022 2 £995 Book places
Mon/Tue 18-19 July 2022 2 £850 Book places
Thu/Fri 01-02 September 2022 2 £850 Book places
Tue/Wed 13-14 September 2022 2 £995 Book places
Tue/Wed 04-05 October 2022 2 £850 Book places
Thu/Fri 13-14 October 2022 2 £995 Book places
Mon/Tue 07-08 November 2022 2 £850 Book places
Tue/Wed 15-16 November 2022 2 £995 Book places
Tue/Wed 06-07 December 2022 2 £850 Book places
Date(s) Venue
15/06
12/07
18/07
01/09
13/09
04/10
13/10
07/11
15/11
06/12

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

Advanced SQL

Advanced

2 day course

Reporting Services RECOMMENDED

Introduction

2 day course

Introduction to SSIS

Introduction

2 day course

Other SQL training resources

SQL exercises

SQL exercises

All of our SQL exercises are based on simple and interesting databases, as these exercises testify.

View SQL exercises

SQL videos

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

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

SQL blogs

Look through our blogs on SQL - there's even a full tutorial on SQL online.

View SQL blogs

This page has 0 threads Add post