Instructor-led, Online

SQL Course, SQL Queries, 1 Day

SQL Course. 1 day, summary

With SQL Queries, 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.
This 1 Day course is packed with power query techniques.
This SQL Introduction Course is hands-on and practical with many excellent query examples.

SQL Course London Description

Relational Database Concepts:

What is a Relational Database?
Tables, Rows and Columns
Indexes, Primary Keys and Foreign Keys
Data Types

SQL Language Essentials:

The SQL Select Statement
SQL Conditions and the Where Clause: >,<,>=,<=,=,, Not, Between, AND, OR, Like, Wildcards
The SQL Order By Clause
SQL Arithmetic Operations, Expression Queries
SQL Column Aliases
Limit/Top, Distinct
Working with Null Values

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, Cross Joins
Alternative Join Syntax

Additional SQL Features:

Combining Queries
The Union, Intersect and Minus Operators
Basic Subqueries

What is included in the SQL Course:
  • SQL Course Certificate on completion
  • SQL Course notes
  • Practical SQL Course exercises, SQL Code Examples
  • After the course, 1 free session for questions online SQL Course via Gotomeeting.com.
  • Max group size, online and in classroom, on this SQL Course London is 4.
Special Offers
PCWorkshops London
Special Offer on the 'Visual Data with Power BI' Webinar
Read More
PCWorkshops Manchester
Special Offer: Python 3-weeks online Boot Camp
Read More
PCWorkshops Birmingham
Special Offer on the 'SQL Queries in 1-Day' webinar
Read More
PCWorkshops Southend-on-Sea
Special Offer on the 'Java Cross-Over for Coders' Webinar
Read More

Request a Free Webinar Demo

Try a 30 minutes webinar free. Choose you own topic from our course list.