SQL

About this course

Build SQL skills from relational thinking and filtering to joins, aggregation, window functions and query plans.

This foundation course is part of the Data Engineering & Platforms school. The curriculum includes an estimated 10 h of study content. Instructor-led delivery is available online or offline; session schedules are confirmed during enrollment.

Course curriculum

• Module 1 — Relational Thinking
• Module 2 — SELECT, Filtering and Sorting
• Module 3 — Joins and their Traps
• Module 4 — Aggregation
• Module 5 — Subqueries and CTEs
• Module 6 — Window Functions
• Module 7 — Modelling and Normalisation
• Module 8 — Indexes and Query Plans

Applied learning

• Case Study — The Numbers Behind the Board Pack
• Lab 1 — Answers for the board
• Lab 2 — Fix the wrong queries
• Lab 3 — A weekly store report, made fast
• Capstone — A Checked SQL Report

Who this course is for

Student / Beginner; Data Professional; Engineer / Architect

Prerequisites

No prerequisite course is listed in the academy catalog.

Course details

• Course code: NE-DE-102
• Level: Foundation
• Estimated duration: 10 h
• Delivery: Self-Paced