Course Details

Learn SQL with this beginner-friendly course using W3Schools—no setup or servers needed. Start writing queries right away.

Explore key concepts like SELECT, WHERE, JOINS, AGGREGATES, and CASE. Use ChatGPT to help troubleshoot and explain code.

See how SQL fits into real industry roles and tools like Tableau. Build a strong foundation for your data career in just a few lessons.

  • Pre-requisite Knowledge/Skills

    • No prior SQL or programming experience is required.
    • Basic computer literacy and internet browsing skills are helpful.
    • Familiarity with Excel or other spreadsheet tools is a plus but not essential.

  • Software Requirements

    • No installations required: The course uses W3Schools SQL Tryit Editor for hands-on practice.
    • Optional tools:
      • A modern web browser (e.g., Chrome, Firefox, Safari)
      • ChatGPT account (free or paid) for AI assistance
      • Optional: Tableau Public (for exploring SQL integration with BI tools)

  • Course Outcomes

    • Write and run basic SQL queries using SELECT, WHERE, ORDER BY, and JOIN
    • Use aggregate functions (COUNT, SUM, AVG, MIN, MAX)
    • Apply filtering, subqueries, and conditional logic with CASE
    • Understand the role of SQL in data analysis and business intelligence
    • Use AI tools like ChatGPT to support learning and troubleshoot code
    • Be prepared for more advanced SQL topics and real-world projects

Course curriculum

    1. 01_01_Introduction to the Course and W3 Schools (Link)

    2. 01_02_Role of SQL in Industry as an Analyst, Engineer, Scientist

    3. 01_03_Select Statement - Running Queries - Proper Structure

    4. 01_04_Using ChatGPT AI to Help Us (Links)

    5. 01_05_Select Start, Top Rows and Limit Function

    6. 01_06_Where Clause with AND and OR

    7. 01_07_Order By Function

    8. 01_08_Aggregate Functions

    9. 01_09_Introduction to Joins

    10. 01_10_Unions - With and Without Duplicate, SubQueries, Aliases

    11. 01_11_Case Function

    12. 01_12_Arithmetic Operators

    13. 01_13_Commentary - 2 Methods

    14. 01_14_Finish

    1. 01_01_What is ChatGPT - Multiple Demonstrations

    2. 01_02_How ChatGPT Works Under The Hood

    3. 01_03_Gaining Access to ChatGPT - Paid vs Free (Links)

    4. 02_01_Iteration Discussion vs Establishing Context Immediately

    5. 02_02_Explaining your Skill Level to get Better Explanations

    6. 02_03_Outlining your Needs Prior to Prompting

    7. 02_04_Analyzing your Tone - JELLYMAN CREATIVE (LINKS)

    8. 03_01_Using ChatGPT to Assess our Finances and Buy a House

    9. 03_02_Computer Programming - Advanced Capabilities Demo

    10. 03_03_Using the Canvas Feature

    11. 03_04_Image Generation - Dall-E and Sora - Midjourney Sneak Peak

    12. 03_05_Custom GPTs and the GPT Store

    13. 03_06_Custom GPT Design

    14. 04_01_Finish

    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

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

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

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

    8. 01_08_Iterating your Script in Stages

    9. 01_09_Exporting Instant Reports - Using a Template

    10. 01_10_Aggregation Exercise Over Level and Year

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

    12. 01_12_Solving Problems when Data Doesn't Exist Yet

    13. 01_13_Finish

About this course

  • Free
  • 41 lessons
  • 4.5 hours of video content