SQL for Developers
For developers who want to be genuinely good at the database layer: data modelling with keys and constraints, safe inserts, updates and deletes, transactions, views and schema changes, plus query plans and indexing. The capstone tunes analysis queries on a large event store using real execution plans.
1. Tracks
2. Capstone projects
- Advanced SQL performance and analysisAnswer real questions on 300,000 events and 100,000 orders, read query plans, add exactly the right indexes and rewrite slow patterns without changing a single result.
- Workforce and pay analyticsBuild Masar Holding's people report: headcount, turnover, pay against bands, spans of control, pay for performance and workforce mix.