Whether you're completely new to databases or looking to build practical skills fast, this beginner SQL course is designed for you. Our 1-day SQL workshop is ideal for professionals, students, data analysts, marketers, and anyone who wants to learn SQL quickly and effectively. Delivered in London or online, the course focuses on hands-on SQL training, helping you understand how to write queries, use joins, filter data, and explore real-world database scenarios. If you're searching for an SQL course in London or want to learn SQL online, this workshop is the perfect starting point.
Learn the fundamentals of SQL in just one day with our hands-on 1-day SQL course in London, UK, or online. This beginner SQL course teaches you how to write effective SQL queries to extract valuable business insights from your data quickly and confidently. Avoid endless hours of self-guided online training by joining this practical SQL workshop designed for fast learning. Our 1-day SQL workshop is packed with powerful query techniques and real-world examples, suitable for users of MySQL, PostgreSQL, or MS SQL Server. The training is fully platform-independent and tailored for beginners looking for a comprehensive introduction to SQL. Designed to be highly interactive, this beginner SQL course offers plenty of opportunities to develop your query-writing skills in a small, friendly classroom setting. Whether you attend in London or learn SQL online, you'll benefit from instructor-led sessions with full screen sharing for an immersive learning experience.
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
Group by
Aggregate Functions in SQL (Sum, Avg, Count, Max, Min)
The SQL Group By Clause
The Having Clause
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
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
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
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
