SQL
SQL Basics
Learn to ask a database questions in its own language: pick columns, filter rows, sort them and group them.
Start the trackFree, no sign-up needed
What you'll learn
- Your first querySELECT and WHERE
- Sorting resultsSort with ORDER BY and cap the row count with LIMIT
- Combining conditionsConditions with AND, OR, IN and BETWEEN
- Pattern matchingLIKE with % and _
- Aggregate functionsCOUNT, SUM and AVG
- Grouping rowsThe GROUP BY clause
- Filtering groupsHAVING versus WHERE
- Missing valuesNULL and COALESCE
- Labeling with conditionsThe CASE WHEN expression
- Unique valuesDISTINCT and COUNT(DISTINCT)
Track contents
10 lessons, 2 hours in total- 1Your first querySQLSELECT and WHERE9 min
- 2Sorting resultsSQLSort with ORDER BY and cap the row count with LIMIT10 min
- 3Combining conditionsSQLConditions with AND, OR, IN and BETWEEN12 min
- 4Pattern matchingSQLLIKE with % and _11 min
- 5Aggregate functionsSQLCOUNT, SUM and AVG11 min
- 6Grouping rowsSQLThe GROUP BY clause12 min
- 7Filtering groupsSQLHAVING versus WHERE12 min
- 8Missing valuesSQLNULL and COALESCE12 min
- 9Labeling with conditionsSQLThe CASE WHEN expression11 min
- 10Unique valuesSQLDISTINCT and COUNT(DISTINCT)10 min