JOINs in SQL — Combining Tables Like a Pro

What You Will Learn Why JOINs exist and what they solve The four JOIN types: INNER, LEFT, RIGHT, FULL How to read a JOIN query line by line How…

SQL GROUP BY Explained With Real Sales Data

What You Will Learn What GROUP BY does and why it is so important How to group by one column and by multiple columns The HAVING clause — filte…

SQL Aggregations — COUNT, SUM, AVG, MIN, MAX Explained

What You Will Learn The five core SQL aggregation functions How each one handles NULL values Using DISTINCT inside aggregations How aggregation…

Sorting and Limiting with ORDER BY and LIMIT in SQL

What You Will Learn The ORDER BY clause and how to sort ascending or descending Sort by multiple columns How NULLs are handled in sorting The L…

Filtering Data with WHERE, AND, OR, IN, BETWEEN in SQL

What You Will Learn The WHERE clause and how it filters rows Combine conditions with AND , OR , NOT Use IN , BETWEEN , LIKE , IS NULL The most dange…

SQL SELECT Statement — Your First Query

What You Will Learn What SQL is and what a query is The simplest possible SQL query: SELECT ... FROM ... How to select one column, several col…

Data Types Every Analyst Must Know (Numbers, Text, Dates, Booleans)

What You Will Learn The core data types used by SQL, Python, and spreadsheets How storage type differs from analytical type (from lesson 03) W…

Explaining Regex, SQL, and Other Dense Syntax