Learn SQL Course, 1-Day

    SQL Queries Course, 1-Day.
    Who should attend:
    Basic SQL syntax for beginners to SQL
    Many attendees are in-work IT Professional.
    Private individuals are also very welcome.
    Our Style: Hands-on, Practical
    Location: Online, Instructor-led
    Times: Arrange a time for your time zone
    Software and Sample Data: We will contact you upon booking to discuss software and sample data

Learn SQL Course, 1-Day

Learn the fundamentals of SQL in just one day with this engaging SQL Course in London, UK. You'll discover how to use SQL queries to extract essential, insightful business intelligence from your data. The course simplifies query writing, helping you avoid hours of self-guided online training. This 1-day, hands-on SQL Introduction Course is packed with powerful query techniques and real-world examples. Whether you're working with MySQL, PostgreSQL, or MS SQL Server, the training is fully platform-independent. Designed to be highly practical, the SQL course gives you the chance to build real query-writing skills in an interactive setting. You’ll have plenty of opportunities to ask your SQL questions in a small, friendly classroom environment. Delivered online, this instructor-led course features full screen sharing for a fully immersive SQL learning experience.

Hour 1: Learn SQL Relational Database Concepts:

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

Basics.
SQL Language Essentials:
The SQL Select Statement, the Where Clause, SQL Order By Clause, Working with Null Values
SQL Expression Queries; SQL Column Aliases; Limit/Top, Distinct

Hour 2: Summarizing and Grouping Data:

Group by
Aggregate Functions in SQL (Sum, Avg, Count, Max, Min)
The SQL Group By Clause
The Having Clause

Hour 3: Querying Multiple Tables:

Joins
Joining Tables
Inner Joins, Left, Right and Full Joins
Cross Joins

Combine Queries
The Union Operator
Intersect and Minus Operators
Simulating combine Intersect and Minus queries by using sub-queries

Hour 4: Working with dates

Dates Functions
Date parts, System date and time
Dates in the where clause
Formatting dates and times
Date calculations in SQL
Using dates and date parts in the group by clause
Date functions comparison for different databases

Hour 5: String Functions

Built-in SQL Examples
Using string functions in the FROM clause
Using string functions in the WHERE clause
Using string functions in the HAVING clause
String function reference
Comparing String functions in MySQl and MS SQL Server

Hour 6: Basic SQL Subqueries

SQL Sub-queries
Basics of CTE tables
SQL subqueries
Using subqueries in the FROM clause
Using subqueries in the WHERE clause
Using subqueries in the SELECT clause
Using subqueries in the HAVING clause

What is included
  • PCWorkshops Course Certificate on completion
  • SQL Course Notes
  • SQL Code Examples
  • Practical SQL Course exercises and Code Samples
  • After the course: 1-Hour personalised online revision session
Book the SQL Course
About us
Learn SQL
BOOK A FREE SQL TRIAL
Special Offers
PCWorkshops London
Special Offer on the 'Visual Data with Power BI' Webinar
Read More
PCWorkshops Manchester
Special Offer: Python Course
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