Use Case
Database performance optimisation and future proofing
Core SQL
Advanced PostgreSQL
Problem
Our database is about to fall over. We need to move beyond basic SQL to secure its performance.
Outcome
Everyone on the team understands the performance implications of SQL queries they write. The slowest queries have all been identified, and sped up by orders of magnitude, and new code performs well since both writers and reviewers are looking out for improvements. Without needing to scale infrastructure further, our database can more than handle requirements.
Skills
Core SQL
Advanced PostgreSQL
Timeframe
3-6 months
(~3 hours of live learning per month)