SQL Mastery Guide

A visual, practice-first Notion guide that moves from foundational SQL queries into joins, analysis, optimisation and practical database projects.

Learn and build

• Query foundations: SELECT, WHERE, ORDER BY and working with tables.
• Combine and analyse data: joins, GROUP BY and subqueries.
• Performance concepts: indexes and query optimisation.
• Project practice: work with e-commerce, sales-reporting and HR database scenarios.

Included with the resource

• Structured written lessons: beginner-to-advanced SQL topics with practical examples.
• Hands-on projects: database exercises connected to realistic business scenarios.
• Notes and resource vault: keep your explanations, links and useful references together.
• Practice tracker: plan regular query-writing sessions and monitor consistency.

Access and requirements

• Format: a written Notion guide with lessons, examples, projects and a practice tracker.
• Delivery: Gumroad provides access after purchase; use a Notion account for the workspace.
• Practice setup: use an appropriate SQL database or query environment for the exercises.
• Learning pace: work through the queries and projects yourself and record your results.

• Absolute beginners and students starting with databases.
• Developers, analysts, freelancers and working professionals who want structured SQL practice.
• Learners revisiting SQL and looking for projects and clearer query reasoning.

• Structured written lessons: beginner-to-advanced SQL topics with practical examples.
• Hands-on projects: database exercises connected to realistic business scenarios.
• Notes and resource vault: keep your explanations, links and useful references together.
• Practice tracker: plan regular query-writing sessions and monitor consistency.

• Write foundational queries before moving into joins, grouping and subqueries.
• Use project datasets to practise and check the rows each query returns.
• Keep notes on query decisions and revisit indexes and optimisation as your work becomes more complex.

• Format: a written Notion guide with lessons, examples, projects and a practice tracker.
• Delivery: Gumroad provides access after purchase; use a Notion account for the workspace.
• Practice setup: use an appropriate SQL database or query environment for the exercises.
• Learning pace: work through the queries and projects yourself and record your results.