COVID-19: Choose between our familiar (but now socially distanced) classroom training courses and our excellent new live online courses.
Classroom training -  Fast-track SQL

Classroom Training

Fast track SQL course (3 days)

Available as classroom training course only

3 days

We recognise that not everyone can devote two days to attend our SQL Introduction course and another two days to sit on our two-day Advanced SQL course, so we've combined the contents together into this single, intensive three-day SQL course.  The course will cover everything from creating basic SELECT statements all the way through to writing stored procedures and using CTEs, temporary tables and table variables. 

Our fast-track courses are only available as tailored training, either at your premises or at either our London or Manchester venues (here's why).

Course Contents

This fast-track course combines topics from the following other Wise Owl courses:

From our INTRODUCTION TO SQL course

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

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

Subqueries

  • The concept of a subquery
  • Syntax of subqueries
  • Using subqueries in a query

Derived tables and CTEs

  • Using derived tables
  • Common Table Expressions (CTEs)
  • Multiple CTEs in a single query
From our ADVANCED SQL course

Stored procedures

  • Creating stored procedures
  • Executing stored procedures
  • System stored procedures

Variables

  • Declaring variables
  • SET versus SELECT
  • Tricks with variables
  • So-called global variables

Parameters and return values

  • Passing parameters
  • Default values / WHERE clauses
  • Output parameters
  • Using RETURN

Covered if time allows If time

Scalar functions

  • What they are
  • Writing user-defined functions
  • Worked examples
  • Pros and cons of scalar functions

Testing conditions

  • IF / ELSE statement
  • Using CASE where possible

Looping

  • Syntax of WHILE
  • Breaking out of a loop

Covered if time allows If time

Error-handling

  • Using TRY / CATCH
  • System error functions
  • Custom error messages

Deleting using SQL

  • Ways to drop tables
  • DELETE versus TRUNCATE

Updating data in SQL

  • The UPDATE statement
  • Updating using joins

Inserting data

  • Making tables (SELECT INTO)
  • Appending data (INSERT INTO)
  • Inserting individual rows

Creating tables

  • Creating tables in SQL
  • Primary keys and indexes
  • Adding relationships

Covered if time allows If time

Transactions

  • Beginning a transaction
  • Committing / rolling back

Temporary tables and table variables

  • Scope (local versus global)
  • Using temporary tables
  • Creating table variables
  • Pros and cons of each approach

Covered if time allows If time

Table-valued functions

  • In-line table-valued functions
  • Mult-statement table-valued functions

Covered if time allows If time

Dynamic SQL

  • Building up dynamic SQL
  • Executing dynamic SQL
  • Disadvantages of dynamic SQL

Covered if time allows If time

Pivots

  • Assembling data for pivoting
  • Using PIVOT
  • Dynamic column headers

Covered if time allows If time

Triggers

  • Insert, update and delete triggers
  • Using generated tables (eg INSERTED)
  • Using INSTEAD OF

There are no special pre-requisites for you to satisfy to attend this course, other than to have a good level of IT literacy.  If you don't find it easy to create Excel formulae you should avoid this course!

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

"Excellent manuals. Knowledgeable trainer. Genuinely useful content. Great website and blogs. Competitive pricing."

Glenn Turner (Ministry of Defence)

"Excellent delivery of training and interactive exercises. Well delivered course. In-depth manual and exercises to go through in own time."

Ian Lynch (Manchester Metropolitan University)

"Very good tutor! Made a huge effort to make the course interesting and fun."

Josh Smith (PricewaterhouseCoopers)

"(SSIS) Enjoyed the training; examples clear and concise; thanks to the trainer for helping investigate particular issues that we had, in his own time, on top of the training. (SSRS) Very useful to be able to tailor the course to our requirements. Many thanks to the trainer for responding so quickly to our questions which went quite a long way off topic."

Lucy Gooda (The Cambridge Building Society)

"Excellent delivery by trainer. Patient with clear examples. Manual excellent quality."

David Goff (Devon County Council)

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

Related Courses

Introduction to SQL

Introduction

2 day course

Advanced SQL

Advanced

2 day course

Other SQL training resources

SQL exercises

SQL exercises

You can see the exercises we use for our SQL training here.

View SQL exercises

SQL videos

SQL videos

As an alternative to our classroom training, you could watch our SQL videos.

View Selecting data in SQL, SQL Server 2016, Advanced SQL (programming) or SQL Server 2017 videos

SQL skills assessment

SQL skills assessment

To see if you need fast-track training, take our SQL skils test.

View Test your SQL skills skills assessment tests

SQL blogs

SQL blogs

We've got lots of blogs on matters SQL on our website.

View SQL blogs

This page has 0 threads Add post