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
Join this SQL course in London, UK, where you'll build a strong foundation in SQL in just one engaging, hands-on day. You'll discover how to write effective SQL queries and extract valuable business insights from data. This practical training makes SQL easier to learn by guiding each participant individually, helping you master query techniques that would otherwise take hours to learn online. The one-day SQL Introduction Course is packed with real-world query examples and designed to give you a solid, working understanding of key SQL concepts. It’s platform-independent, so the skills you gain can be applied to databases like MySQL, PostgreSQL, MS SQL Server, and others. You'll benefit from live, instructor-led teaching in a small, friendly group with plenty of time for questions, all through an interactive online format with full screen sharing.
Hour 1: Learn SQL Relational Database Concepts:
Database:
Defining Relational Database and reviewing the general concepts of
tables, rows, columns, data types, indexes, primary and foreign keys.
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
Why Joining Tables, different types of join: Inner Joins, Left, Right and Full Joins
Cross Joins, when is it really useful, filtering on Cross Joins
Combine Queries
The Union and Union All Operators
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
in the FROM, WHERE, GROUP BY and HAVING clause
Date functions comparison for different databases
Hour 5: String Functions
Built-in SQL Examples
Using string functions in the FROM, WHERE, GROUP BY and 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, WHERE, JOIN, GROUP BY and 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