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

    1. 01_03_Select Statement - Running Queries - Proper Structure

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

    3. 01_05_Select Start, Top Rows and Limit Function

    4. 01_06_Where Clause with AND and OR

    5. 01_07_Order By Function

    6. 01_08_Aggregate Functions

    7. 01_09_Introduction to Joins

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

    9. 01_11_Case Function

    10. 01_12_Arithmetic Operators

    11. 01_13_Commentary - 2 Methods

    1. 01_14_Finish

About this course

  • Free
  • 14 lessons
  • 1.5 hours of video content

Categories