Credit course · 2 credits · 8 weeks
SQL: From Questions to Answers
Real questions on real, messy databases: a college, a food delivery app, IPL ball-by-ball, a railway and a slow online shop. 8 weeks, 2 credits.
- Week 1Your first queries4 lessons · 4 graded tasks
- Week 2Finding the right rows4 lessons · 4 graded tasks
- Week 3Cleaning messy data4 lessons · 4 graded tasks
- Week 4Summing it up4 lessons · 4 graded tasks
- Week 5Joining tables4 lessons · 4 graded tasks
- Week 6Questions inside questions4 lessons · 4 graded tasks
- Week 7Designing tables4 lessons · 4 graded tasks
- Week 8Rankings, speed and a final case4 lessons · 4 graded tasks
Grade: weekly assignments 25% (best 7 of 8 weeks) and a supervised exam 75%, taken at your college on any laptop or computer. Lessons work on your phone too.