Book now

SQL Queries 1-Day Course

Course summary

Get interesting, insightful and essential business intelligence from data by using SQL queries. It is made easy and simple by this hands-on, practical course. Ask you questions in small, friendly class-room training. Save hours of online training.

This course is Platform Independant.

Course Outline

Relational Database Concepts

  • What is a Relational Database?
  • Tables, Rows and Columns
  • Indexes, Primary Keys and Foreign Keys
  • Data Types
  • The Data Dictionary
  • Getting Started

SQL Language Essentials

  • The Select Statement
  • The Select and From Clauses
  • Conditions and the Where Clause
  • The Order By Clause
  • Arithmetic Operations
  • Column Aliases

Summarizing and Grouping Data

  • Aggregate Functions
  • The Group By Clause
  • The Having Clause

Querying Multiple Tables

  • Joining Tables
  • Inner Joins
  • Column Qualification and Table Aliases
  • Outer Joins
  • Self Joins
  • Alternative Join Syntax

Additional SQL Features

  • Combining Queries
  • The Union, Intersect and Minus Operators
  • Basic Subqueries

Book this course

Choose from the start dates and other options below. Click on each row to get more information. When you have found your ideal combination click "Book now" to proceed.

Starting How long Where Price

Thu 21st Jun
11:00am - 6:00pm

1 day
Part time day
Portsmouth,
PO6 3EZ
Map

£350
per course

> Book now

Fri 22nd Jun
11:00am - 6:00pm

1 day
Part time day
London,
WC2N 5BY
Map

£350
per course

> Book now

Mon 25th Jun
11:00am - 6:00pm

1 day
Part time day
Southend-On-Sea,
SS1 1NE
Map

£300
per course

> Book now

Tue 26th Jun
11:00am - 6:00pm

1 day
Part time day
London,
WC2N 5BY
Map

£350
per course

> Book now

Wed 27th Jun
11:00am - 6:00pm

1 day
Part time day
Milton Keynes,
MK9 2UB
Map

£350
per course

> Book now

Wed 27th Jun
11:00am - 6:00pm

1 day
Full time
Manchester,
M2 4PD
Map

£350
per course

> Book now

Thu 28th Jun
11:00am - 6:00pm

1 day
Part time day
Portsmouth,
PO6 3EZ
Map

£350
per course

> Book now

Fri 29th Jun
11:00am - 6:00pm

1 day
Part time day
London,
WC2N 5BY
Map

£350
per course

> Book now

Mon 02nd Jul
11:00am - 6:00pm

1 day
Part time day
Southend-On-Sea,
SS1 1NE
Map

£300
per course

> Book now

Thu 05th Jul
11:00am - 6:00pm

1 day
Part time day
Portsmouth,
PO6 3EZ
Map

£350
per course

> Book now