← All paths
FreeData Science

SQL

Go from your first SELECT to real analytics: joins, subqueries, window functions, designing your own schema, and a full analytics project on a real public dataset.

Your progress0 / 9 videos

Sign in to save your progress across devices.

Learn to query a relational database: SELECT, WHERE, GROUP BY, and aggregate functions.

  • freeCodeCamp.org
    • Write SELECT statements with filtering and sorting
    • Use WHERE, GROUP BY, and HAVING
    • Apply aggregate functions (COUNT, SUM, AVG)
    • Understand primary and foreign keys