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 for Introduction to SQL coursesLocations:London, Manchester
  • Next Introduction to SQL course locationNext course:Tue 01 October 2019
  • Introduction to SQL course timesTime:09.30-16.30

Course Contents

The content of this course are as follows:

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

Calculations

  • 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

Views

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

Covered if time allows If time

Subqueries

  • Training topicThe concept of a subquery
  • Training topicUsing ALL, ANY and IN
  • Training topicUsing EXISTS
  • Training topicCorrelated subqueries

Covered if time allows If time

Derived tables and CTEs

  • Training topicUsing derived tables
  • Training topicCommon Table Expressions (CTEs)
  • Training topicMultiple 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?

View full list of benefits View full list of benefits

Sample customer feedback

"Really enjoyed the course, instructor clearly explained everything. Lots relevant to my work so very useful."

Sophie Kelly (Liverpool City Council)

"Very happy with the manuals and questions/exercises - very clear with steps mapped out and plenty to practice on."

Jamie Devonshire (Hoist Finance)

"Good course, well run and lively trainer! Good to take completed work/exercises home on USB. "

Michelle Vandyke (NHS South, Central and West CSU)

"Manual very comprehensive. Exercises practical and fed well into course structure."

Natalie Heppenstall (Royal College of Veterinary Surgeons)

"Great course, will come back for others!"

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 £695 Book places
Thu/Fri 17-18 October 2019 2 £795 Book places
Mon/Tue 04-05 November 2019 2 £695 Book places
Thu/Fri 14-15 November 2019 2 £795 Book places
Thu/Fri 05-06 December 2019 2 £695 Book places
Thu/Fri 12-13 December 2019 2 £795 Book places
Thu/Fri 09-10 January 2020 2 £695 Book places
Thu/Fri 30-31 January 2020 2 £795 Book places
Tue/Wed 18-19 February 2020 2 £695 Book places
Tue/Wed 25-26 February 2020 2 £795 Book places
Thu/Fri 26-27 March 2020 2 £695 Book places
Thu/Fri 02-03 April 2020 2 £795 Book places
Tue/Wed 12-13 May 2020 2 £695 Book places
Tue/Wed 19-20 May 2020 2 £795 Book places
Thu/Fri 04-05 June 2020 2 £695 Book places
Thu/Fri 25-26 June 2020 2 £795 Book places
Tue/Wed 07-08 July 2020 2 £695 Book places
Thu/Fri 13-14 August 2020 2 £695 Book places
Tue/Wed 15-16 September 2020 2 £695 Book places
Tue/Wed 22-23 September 2020 2 £795 Book places
Thu/Fri 15-16 October 2020 2 £695 Book places
Tue/Wed 17-18 November 2020 2 £695 Book places
Thu/Fri 26-27 November 2020 2 £795 Book places
Thu/Fri 17-18 December 2020 2 £795 Book places
Date(s) Venue
01/10
17/10
04/11
14/11
05/12
12/12
09/01
30/01
18/02
25/02
26/03
02/04
12/05
19/05
04/06
25/06
07/07
13/08
15/09
22/09
15/10
17/11
26/11
17/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