What You'll Learn

  • SELECT, WHERE, ORDER BY, and GROUP BY fundamentals
  • INNER, LEFT, RIGHT, FULL JOINs and advanced join techniques
  • Subqueries, CTEs (Common Table Expressions), and temp tables
  • Window functions (ROW_NUMBER, RANK, LAG, LEAD)
  • Aggregate functions and statistical analysis in SQL
  • Query optimisation, execution plans, and performance tuning
  • ETL operations and real-world data manipulation
  • Database design principles and normalisation

Course Modules

1

Foundations & Setup

Learn SQL syntax, database concepts, and set up your local environment. Master SELECT, WHERE, and filtering data.

2

Joins & Multi-Table Queries

Deep dive into INNER, LEFT, RIGHT, and FULL JOINs. Combine data from multiple tables with confidence.

3

Advanced Queries & Aggregation

Master GROUP BY, HAVING, aggregate functions, and create subqueries for complex analytical problems.

4

Window Functions & Performance

Use window functions for ranking and running totals. Optimise queries and understand execution plans.

5

Real-World Projects & ETL

Build end-to-end data pipelines, work with large datasets, and tackle real-world analytics problems.

6

Database Design & Normalisation

Understand schema design, normalisation rules, and best practices for building scalable databases.

Tools & Technologies

PostgreSQL
MySQL
SQL Server
SQLite
BigQuery

Career Relevance

Data Analyst

Essential foundation for querying data, generating reports, and creating dashboards.

Data Scientist

Critical skill for data preprocessing, feature engineering, and accessing training data.

Data Engineer

Fundamental skill for building pipelines, ETL processes, and data warehouses.

Prerequisites

  • Basic computer literacy and familiarity with spreadsheets (Excel/Google Sheets)
  • No prior SQL or programming experience required
  • Access to a computer with internet connection
  • Willingness to practice with hands-on exercises

Ready to Master SQL?

Get access to this course, plus 13 more professional data & AI courses.

Get access for $34