SQL Query 1-Day Course

An intensive, hands-on 1-day course on SQL queries!

SQL Queries 1-day course

Book Here

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

SQL Language Essentials
The Select Statement
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, Outer Joins, Self Joins, Full Joins, Alternative Join Syntax

Additional SQL Features
Combining Queries
The Union, Intersect and Minus Operators
Basic Subqueries

Program for the day

What will happen on the day
11:00 Arrivals and registration
11:10 Introductions, Lectures and practicals
13:00 Lunch break
13:30 Lectures and practicals
18:00 Finish

Course FAQ's

Click here


PCWorkshops at LONDON 8 Northumberland Avenue, London, WC2N 5BY
- Other Locations: Milton Keynes, Southend-on-Sea, Portsmouth

Why you will love PCworkshops

At PCWorkshops, we love our job.
Trainers are professional developers.
We are excellent at packaging the knowledge into excellent, well paced lessons.

Book here

Scroll for dates, then click book at the preferred date

Do you have questions?

Please call 020 7641 6359 or email training@pcworkshopslondon.co.uk to ask your questions!