DataDucky

Home

SQL Mastery

Introduction Setup SELECT, WHERE, Aggregations Grouping, Ordering, More Aggregations Functions & Dates JOINs Math & String Functions Subqueries Window Functions Data Definition Language (DDL) Views & Temporary Tables

Setup

Setting up everything you need before we start. Tools, structure, and what to expect going forward.

SSMS Link: https://learn.microsoft.com/en-us/ssms/install/install

Adventure works database: https://learn.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver17&tabs=ssms

SQL Server 2025 Express: https://www.microsoft.com/en-gb/sql-server/sql-server-downloads