SQL

Deep dive into GROUP BY, HAVING, COUNT, and DISTINCT in SQL

A beginner’s guide to using the CASE statement for conditional queries

Learn to store, manipulate, and format dates correctly in SQL for accurate querying and sorting

Understand how SQL JOINs work — including INNER, LEFT, RIGHT, FULL, and SELF JOIN

Core SQL concepts like SELECT, WHERE, ORDER BY, and LIMIT for beginners