SQL Queries 1-Day Course, London, Classroom or Virtual Classroom

SQL Course summary

We offer the courses online, instructor-led. This 1-day course need no software on your laptop, but it would help if you have MySQL Workbencg, MS SQL Server Management studio or Azure Data Studio available..

Get interesting insightful and essential business intelligence from data by using SQL queries on this SQL Course. Queries are made easy and simple by this hands-on practical course. Ask your SQL questions in small friendly classroom SQL Course. Save hours of online training.

This course is Platform Independant.

SQL Course Outline

Relational Database Concepts

What is a Relational Database?

Tables Rows and Columns

Data Types

Indexes Primary Keys and Foreign Keys 

Relationships

SQL Language Essentials

The SQL Select Statement

SQL Conditions and the Where Clause:

>=

The SQL Order By Clause

SQL Column Aliases

Limit/Top

Distinct

SQL Arithmetic Operations

Expression Queries 

Working with Null Values

Case IIf

SQL Summarizing and Grouping

Data Aggregate Functions 

Sum Avg Count Max Min

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

WHAT IS INCLUDED:

SQL Course Certificate

Course notes

Tea coffees but no lunch

Max group size is 4.

You may also like the following events from PCWorkshops:

• Next Monday, 21st July, 11:00 am, Running Projects with MS Project. 1-Day, 1-1, Live Online Classroom in online