A practical introduction to SQL for people starting from zero. No previous SQL knowledge required.
A simple, practical journey from your first SQL query to answering real data questions.
SELECT query and explore a real dataset.WHERE, AND / OR, IN, BETWEEN, LIKE, NULL and ORDER BY.COUNT, SUM, AVG, GROUP BY and HAVING to turn rows into useful answers.INNER JOIN, LEFT JOIN and how to avoid common JOIN mistakes.CASE, simple subqueries and CTEs, then solve a final practical business question.