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.

Buy a voucher
Starting How long Where Price

Mon 27th Nov
11:00am - 6:00pm

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

£350.00 30% off
£245
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Mon 27th Nov
11:00am - 6:00pm

1 day
Part time day
London,
WC2N 5BY
Map

£350.00 30% off
£245
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Mon 27th Nov
11:00am - 6:00pm

1 day
Part time day
Portsmouth,
PO6 3EZ
Map

£410.00 30% off
£287
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Mon 27th Nov
11:00am - 6:00pm

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

£410.00 30% off
£287
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Mon 27th Nov
11:00am - 6:00pm

1 day
Full time
Manchester,
M2 2AN
Map

£410.00 30% off
£287
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Tue 28th Nov
11:00am - 6:00pm

1 day
Part time day
London,
WC2N 5BY
Map

£350.00 30% off
£245
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Tue 28th Nov
11:00am - 6:00pm

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

£350.00 30% off
£245
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Tue 28th Nov
11:00am - 6:00pm

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

£410.00 30% off
£287
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Tue 28th Nov
11:00am - 6:00pm

1 day
Part time day
Portsmouth,
PO6 3EZ
Map

£410.00 30% off
£287
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher

Tue 28th Nov
11:00am - 6:00pm

1 day
Full time
Manchester,
M2 2AN
Map

£410.00 30% off
£287
per course

> Book now
Buy a course voucher
Book now
Buy a course voucher