SQL: Zero to Data Analyst

SQL Home, Introduction & Syntax

Article · 14 min

SELECT & SELECT DISTINCT

Article · 12 min

WHERE, AND, OR & NOT

Article · 14 min

ORDER BY & SELECT TOP / LIMIT

Article · 12 min

INSERT, NULL, UPDATE & DELETE

Article · 16 min

Aggregate Functions: MIN, MAX, COUNT, SUM, AVG

Article · 15 min

LIKE, Wildcards, IN & BETWEEN

Article · 14 min

SQL Aliases

Article · 10 min

JOINs: Inner, Left, Right, Full & Self

Article · 18 min

UNION & UNION ALL

Article · 12 min

GROUP BY & HAVING

Article · 16 min

EXISTS, ANY & ALL

Article · 14 min

SELECT INTO & INSERT INTO SELECT

Article · 13 min

CASE & NULL Functions

Article · 14 min

SQL Operators & Comments

Article · 11 min

Stored Procedures — Introduction

Article · 12 min

CREATE DATABASE, DROP & BACKUP

Article · 13 min

CREATE, DROP & ALTER TABLE

Article · 15 min

Constraints: NOT NULL, UNIQUE, PK, FK, CHECK, DEFAULT

Article · 18 min

CREATE INDEX & AUTO INCREMENT

Article · 14 min

SQL Dates & Views

Article · 15 min

SQL Injection, Parameters & Prepared Statements

Article · 16 min

SQL Database Hosting

Article · 10 min

Data Types & Keywords Quick Reference

Article · 14 min

MySQL, SQL Server & Access Functions (Overview)

Article · 12 min

Common SQL Query Patterns

Article · 16 min

Quiz, Exercises & Study Plan

Article · 14 min

Practice: Reporting Queries

Article · 18 min

Practice: JOIN Drills

Article · 17 min

Mini Project: School Database Reports

Article · 22 min