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
In this SQL course in London, UK, you can learn SQL in just one day, mastering the basics and gaining valuable business insights from data through SQL queries. The course simplifies query creation, saving you hours of online training with powerful query techniques. This one-day, hands-on SQL Introduction Course offers practical experience with numerous excellent query examples. It's platform-independent and designed to provide in-depth, practical knowledge of SQL topics. You'll have the opportunity to ask questions in a small, friendly classroom setting. The course is delivered online, instructor-led, and interactive, with full screen sharing.
Hour 1: Learn SQL Relational Database Concepts:
SQL Database:
Relational Database, Tables, Rows, Columns, Indexes, Primary Keys, Foreign Keys, Data Types.
Hour 2: Learn SQL Essentials:
SQL Basic statements.
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 3: Summarizing and Grouping Data:
SQL Group by
Aggregate Functions in SQL (Sum, Avg, Count, Max, Min)
The SQL Group By Clause
The SQL Having Clause
Hour 4: SQL Multiple Table Joins:
SQL Joins
Joining Tables
SQL Inner Joins, SQL Outer Joins, SQL Self Joins, SQL Full Joins,
Cross Joins
Alternative SQL Join Syntax
SQL Combine Queries
Combine Queries
The SQL Union and Union All
SQL Intersect, Minus Operators, Except
Simulating combine Intersect and Minus queries by using sub-queries
Hour 5: Working with dates
SQL Sub-queries
SQL CTE tables
SQL subqueries
Using SQL Subqueries in the FROM ,WHERE , SELECT and HAVING clause s
Hour 6: Basic SQL Subqueries
SQL Dates Functions
SQL Date parts, SQL System date and time
SQL Dates in the where clause
Formatting SQL dates and SQL times
SQL Date calculations in SQL
Using SQL dates and SQL date parts in the group by clause
SQL Date functions comparison for different databases
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
Our experienced trainers are award winners.
