Skip to content

About: SQL For Data Analysis

← Back to deck

120 cards

Overview

deck is a focused introduction to the SQL skills you'll use every day as a data analyst. The cards walk you through the building blocks of querying data, from basic SELECT statements and filtering with WHERE and HAVING, to sorting with ORDER BY, paging through results with LIMIT and OFFSET, and handling missing values with NULL checks and COALESCE. It's the kind of foundational knowledge that pays off in every database you touch, whether you're pulling reports in MySQL, PostgreSQL, or another dialect.

It's a great fit if you're new to SQL or preparing for a data analyst interview, bootcamp, or your first analytics role. Even if you've written queries before, the cards are useful for shoring up small but important details, like how COUNT(*) differs from COUNT(column) or what default sort ORDER BY applies. Working through them is also a handy way to build confidence before sitting down at a real database and exploring on your own.

Because the concepts build on each other, try reviewing a few cards at a time rather than cramming everything in one sitting. Spacing your practice over several days helps the syntax stick, and pairing the flashcards with hands-on exercises against a sample database will deepen your understanding even further. Don't worry about getting every card right on the first pass — repeated review is exactly how these patterns become second nature.

Start studying