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

Thu 26th Oct
11:00am - 6:00pm

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

£350.00 17% off
£290.5
per course

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

Thu 26th Oct
11:00am - 6:00pm

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

£410.00 17% off
£340.3
per course

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

Thu 26th Oct
11:00am - 6:00pm

1 day
Part time day
Portsmouth,
PO6 3EZ
Map

£410.00 17% off
£340.3
per course

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

Thu 26th Oct
11:00am - 6:00pm

1 day
Part time day
London,
WC2N 5BY
Map

£410.00 17% off
£340.3
per course

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

Thu 26th Oct
11:00am - 6:00pm

1 day
Full time
Manchester,
M2 2AN
Map

£410.00 17% off
£340.3
per course

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

Fri 27th Oct
11:00am - 6:00pm

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

£350.00 17% off
£290.5
per course

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

Fri 27th Oct
11:00am - 6:00pm

1 day
Part time day
London,
WC2N 5BY
Map

£410.00 17% off
£340.3
per course

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

Fri 27th Oct
11:00am - 6:00pm

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

£410.00 17% off
£340.3
per course

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

Fri 27th Oct
11:00am - 6:00pm

1 day
Part time day
Portsmouth,
PO6 3EZ
Map

£410.00 17% off
£340.3
per course

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

Fri 27th Oct
11:00am - 6:00pm

1 day
Full time
Manchester,
M2 2AN
Map

£410.00 17% off
£340.3
per course

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