Kirsten Kehrer from datamovesme.com does all kinds of super valuable stuff in SQL and end of 2019 she decided to share it with the world via a free SQL course.
The course is focused on data science and has 5 modules with video lectures:
- Intro Video
- Module 1 Video
- Module 2 Video 1 and Module 2 Video 2
- Module 3 Video 1 and Module 3 Video 2
- Module 4 Video 1 and Module 4 Video 2
- Module 5 Video 1 and Module 5 Video 2
Kirsten advises to take the course with dual monitors, as she also provides an online SQL query builder environment, where you can write your queries during the videos.
Moreover, Kirsten also published the slides and the code to go with the course, so you can really learn along:
- Module_2_Slides and Module 2 Queries
- Module_3_Slides and Module 3 Queries
- Module_4_Slides and Module 4 Queries
- Module_5_Slides and Module 5 Queries
A nice touch is that Kirsten simulated some data for a fictitious e-commerce company, that really allows you to get a feel for the type of data you’d be working with in practice: