Posts about SQL
Read a query plan in 10 minutes
EXPLAIN output looks like noise until you know the four things to look for. Open the SQL Lab, run one slow query from Mangrove's orders page, and learn to read the plan, fix it, and prove the fix.
What a data analyst actually does in week one
Less modelling, more asking what a number means. A day-by-day look at a new analyst's first week at Mangrove Market, and the skills that week actually uses.