SQL Server training -  Introduction to SQL

SQL Training

Introduction to SQL (2 days)

£625 + VAT for most venues (£750 + VAT for London)

You can use SQL to retrieve information from your corporate database (providing, of course, that you understand its structure). This two-day 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 coursesLocations:Manchester, London
  • Next Introduction to SQL course locationNext course:Thu 27 October 2016
  • Introduction to SQL course timesTime:09.30-16.30

Course Contents

Using SQL Server

  • Training topicUsing Object Explorer
  • Training topicHiding system objects

Creating databases - overview

  • Training topicDesigning databases
  • Training topicPrimary keys
  • Training topicIndexing fields

Working with tables

  • Training topicCreating tables
  • Training topicAllowing nulls or not
  • Training topicIdentity fields

Database diagrams

  • Training topicCreating database diagrams
  • Training topicJoining tables with relationships

Simple Queries

  • Training topicCreating queries
  • Training topicComments
  • Training topicIndentation and case

Setting criteria using WHERE

  • Training topicWildcards (% and _)
  • Training topicSetting criteria for dates
  • Training topicCoping with nulls

Outputting to Excel

  • Training topicResults, text and grid options
  • Training topicCopying and pasting column headings
  • Training topicExporting using SQL
  • Training topicExporting using the menu


  • Training topicCalculated columns
  • Training topicUsing aliases
  • Training topicString functions and concatenation

Calculations using dates

  • Training topicGetDate
  • Training topicConverting dates
  • Training topicUseful date functions

Basic joins

  • Training topicInner joins
  • Training topicTable aliases
  • Training topicLeft and right outer joins

More exotic joins

  • Training topicCross joins
  • Training topicFull outer joins
  • Training topicSelf joins

Aggregation and grouping

  • Training topicSUM, AVG, MIN, MAX
  • Training topicVarious ways to count
  • Training topicGrouping by fields
  • Training topicUsing HAVING to filter results

Covered if time allows If time

More complicated grouping

  • Training topicUsing COMPUTE
  • Training topicUsing ALL when grouping
  • Training topicUsing ROLLUP
  • Training topicUsing CUBE


  • Training topicThe view designer
  • Training topicLimitations of the designer
  • Training topicScripting views

Covered if time allows If time

Overview of functions

  • Training topicTypes of function
  • Training topicCreating functions
  • Training topicPassing arguments

Covered if time allows If time

Overview of stored procedures

  • Training topicCreating stored procedures
  • Training topicPassing parameters
  • Training topicBasic variables

Why Choose Us?

View full list of benefits View full list of benefits

Sample customer feedback

"Good pace to the course, trainer explained everything really well. Manual looks to explain things in a detailed way."

Neil Parry (Towergate Insurance)

"Good course, really nice to have an extensive guide to come away with for future reference. Good pace & great to have a small class so free to ask questions."

Nick Stringle (IBM Business Consulting Services)

"Really liked the tasks. Manual looks good (although not enough time to digest this yet.) Content good and the trainer answered any questions I had."

Vickie Goddard (Gateway 6th Form College)

"I wish I had come on this course much sooner. I have attended something similar but no where near as fruitful. The trainer and location were great - I will be recommending."

Cassie Reilly (Biochemical Society)

"The course content and delivery was 100% spot on. The venue, trainer and refreshments were the best yet! The rooms, exercises and manuals are very good."

Alex Richardson (Met Office)

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.

Related Courses

Advanced SQL


2 day course

Reporting Services RECOMMENDED


2 day course

Integration Services


2 day course

Other T-SQL programming 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 SQL videos

SQL skills assessment

SQL skills assessment

Find out how well you know SQL by taking one of our skills assessment tests.

View SQL 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