Excel to SQL
Twelve short lessons, each starting from something you already do in a spreadsheet. By the end, VLOOKUP and pivot tables will feel like the long way round.
- a sheet→a table01A database is just a stack of spreadsheets
- Filter ▾→WHERE02Filter rows with WHERE
- Sort A–Z→ORDER BY03Sort with ORDER BY
- =SUM()→SUM()04SUM, COUNT and AVERAGE
- =COUNTIF()→WHERE + COUNT05COUNTIF and SUMIF are WHERE plus a total
- PivotTable→GROUP BY06A pivot table is GROUP BY
- Value Filters→HAVING07Filter a pivot table with HAVING
- =VLOOKUP()→JOIN08VLOOKUP is a JOIN
- =IF()→CASE WHEN09IF is CASE WHEN
- Remove Duplicates→DISTINCT10Remove Duplicates is DISTINCT
- =LEFT()→SUBSTRING()11Text functions: LEFT, CONCAT, UPPER, FIND
- =TEXT(date)→strftime()12Dates: months, weeks and days between