Beginner

SQL & Database Querying

Query relational databases confidently: filter, join, aggregate and build analysis-ready tables.

3 modules · 7 lessons · about 4 hours of guided content

About this course

SQL is the common language of data teams. Practise every concept against real tables in the browser-based Coding Lab, from SELECT basics to window functions.

What you'll achieve

Retrieve and filter data from one or more tables
Aggregate data correctly with GROUP BY and HAVING
Combine tables with the right kind of JOIN
Use CTEs and window functions for analysis

What you'll deliver

Sales analysis queries
Certificate of completion

Prerequisites

• None

Curriculum

Module 1
Querying one tableThe core of SQL. · 3 lessons · quiz
- SELECT, WHERE and ORDER BYRetrieve exactly what you need.25 min
- Aggregation with GROUP BYTotals and averages by group.Free sample35 min
- HAVING vs WHEREFiltering before and after aggregation.20 min
- Quiz: SQL aggregation check · 2 questions · pass mark 70%
Module 2
Combining tablesJoins and set operations. · 2 lessons
- INNER and LEFT JOINMatching records across tables.35 min
- Avoiding duplicate countsJoin cardinality pitfalls.25 min
Module 3
Analytical SQLCTEs and window functions. · 2 lessons · assignment
- Common table expressionsReadable multi-step queries.30 min
- Window functionsRanking, running totals and moving averages.40 min
- Assignment: Sales analysis queries

Certificate requirements

• Complete every lesson
• Score at least 70% on every module quiz
• Hold an active enrollment

Certificates confirm completion of BDIM training. They are not an academic qualification or professional accreditation.

Request a quote

Tell us whether you are an individual learner, a group or an organization, and your preferred format. Pricing is negotiable.

Curriculum

Module 1

Querying one tableThe core of SQL. · 3 lessons · quiz

SELECT, WHERE and ORDER BYRetrieve exactly what you need.25 min
Aggregation with GROUP BYTotals and averages by group.Free sample35 min
HAVING vs WHEREFiltering before and after aggregation.20 min
Quiz: SQL aggregation check · 2 questions · pass mark 70%

Module 2

Combining tablesJoins and set operations. · 2 lessons

INNER and LEFT JOINMatching records across tables.35 min
Avoiding duplicate countsJoin cardinality pitfalls.25 min

Module 3

Analytical SQLCTEs and window functions. · 2 lessons · assignment

Common table expressionsReadable multi-step queries.30 min
Window functionsRanking, running totals and moving averages.40 min
Assignment: Sales analysis queries

Request a quote

Tell us whether you are an individual learner, a group or an organization, and your preferred format. Pricing is negotiable.