Course Details

Learn the fundamentals of SQL in a clear and practical way, perfect for beginners stepping into data analysis or programming. This course introduces you to the most essential SQL commands you'll use to explore, filter, and understand data.


Each chapter focuses on a specific command like SELECT, WHERE, ORDER BY, and AVG, paired with real-world examples and sample datasets. You'll see how to write the query, what data it starts with, and exactly what result it produces—making learning visual and intuitive.


By the end of the course, you'll not only understand how SQL works—you’ll be confident using it to pull insights, clean data, and think analytically like a professional. No fluff. Just pure SQL skills, built one line at a time.

  • Prerequisite Knowledge / Skills

    • No prior SQL experience required — beginners are welcome.
    • Basic familiarity with how data is stored in tables can help.
    • Some exposure to databases or Excel-style logic is useful, but not mandatory.
    • ChatGPT will guide you through problem-solving — even if you're just starting out.

  • Software Requirements

    • Access to ChatGPT Free (available at chat.openai.com).
    • ChatGPT Plus is highly recommended for memory, faster responses, and better context handling.
    • Any SQL editor or interface (e.g., BigQuery, MySQL Workbench, SQLite Studio).
    • Alternatively, you can follow along using a text editor and guided thinking.

  • Course Outcomes

    • Gain confidence solving real-world SQL challenges from scratch.
    • Learn how to use ChatGPT as your AI coding assistant to brainstorm, debug, and improve your queries.
    • Develop hands-on skills through guided practice, realistic datasets, and clear examples.
    • Understand and apply SQL logic like a professional data analyst.

Course curriculum

    1. 01_01_Welcome to the Course - Outline, Pre Requisite Knowledge and Software

    2. 01_02_getting Started with ChatGPT and Teaching it how to Solve Problems - Uploading Structures

    3. 01_03_Uploading your Data Set - Privacy Warning

    4. 01_04_Custom GPTs to make your Life Much Easier

    1. 01_05_Problem 1 - Starting Easy. Library Data. Single and Multi Queries.

    2. 01_06_Problem 2 - Dealing with Joins. Creafting a Powerpoint Slide

    3. 01_07_Problem 3 - Analyzing More Complex Problems - Storing in Memory

    4. 01_08_Iterating your Script in Stages

    5. 01_09_Exporting Instant Reports - Using a Template

    6. 01_10_Aggregation Exercise Over Level and Year

    7. 01_11_Top Students - Regenerating the Report - Formatting the Report

    8. 01_12_Solving Problems when Data Doesn-t Exist Yet

    1. 01_13_Finish

About this course

  • 13 lessons
  • 1.5 hours of video content