This page will have a comprehensive list of SQL resources which you can use throughout the 8 Week SQL Challenge - the focus is on mainly free resources, blogs and courses identified by experienced SQL practitioners as the most useful!
All Case Studies By Date
Most Recent Posts
Case Study #8 - Fresh Segments - 9 July 2021
Case Study #7 - Balanced Tree Clothing Co. - 2 July 2021
June 2021
Case Study #6 - Clique Bait - 29 June 2021
Case Study #5 - Data Mart - 20 June 2021
Case Study #4 - Data Bank - 1 June 2021
May 2021
Case Study #3 - Foodie-Fi - 18 May 2021
Case Study #2 - Pizza Runner - 4 May 2021
Case Study #1 - Danny's Diner - 1 May 2021
Oldest Posts
Eric Weber’s SQL Recommendations
My good friend and mentor Eric Weber has given me permission to embed some of his super useful LinkedIn posts directly on this site so more people can benefit from his amazing work - you should definitely give him a follow and support his posts if you aren’t already doing so!
My aim is to make it to the top of Eric’s recommendations one day with my work here with the 8 Week SQL Challenge - so I will keep working hard to achieve my goal!!!
Eric also shares a ton of amazing SQL knowledge himself - below is a perfect example of this top quality knowledge sharing in action!
Other Free Resources
Below is a growing list of links you can checkout for more learning materials which aren’t on Eric’s list!
If you see anything which you think belongs in this section - please feel free to let me know in the Disqus comments at the bottom of this page and I’ll work on adding it below!
Blogs and Online Tutorials
Below are a mish-mash of random blogs, free courses and articles I’ve come across or people have shared with me in the past few months.
I usually recommend Mode to anyone looking for free resources as it has a super clean UI and covers a wide breadth of topics and questions.
- Mode SQL Tutorials
- Metrics Maven articles at compose.com
- https://www.postgresqltutorial.com/
- Tutorials Point PostgreSQL
- Guru99 Short Tutorials
- Exercism.io
- Interview Query SQL Interview Guide
YouTube Videos
If you’re anything like me - I could sit in front of YouTube for a whole day if I’m left alone to my own devices!
Checkout some useful and engaging content from the following creators - I especially enjoyed Dave, Ken, Tina, Alex and Jay’s videos as they are super practical and very down to earth - make sure to give them a subscribe and a follow on LinkedIn too!
Some of the videos below, especially the interview question related ones are going to be quite topical - but might be the sort of introduction that some people might be after.
- David Langer’s YouTube Channel
- Ken Jee’s Simple SQL Fundamentals
- Tina Huang’s SQL Series
- Alex The Analyst’s YouTube SQL Playlists
- Data Science Jay’s SQL Mock Interview
- Edureka Top 65 SQL Interview Questions and Answers
- FreeCode Camp & Giraffe Academy’s Database Course on YouTube
- Top 23 SQL Interview Questions
- Web Dev Simplified SQL in 60 minutes
Official Documenation
I am the first person to recommend reading the documentation for literally anything I’m working on - and SQL is no different!
I found over time, the best place to learn a lot of my own SQL knowledge, especially when I was learning on the job as a data analyst, was by reading the specific documentation for the specific dialect or implementation of SQL that I was working with.
There are many more implementations out there but these are the main few that might be worth learning without much practical work experience!
Final Thoughts
The 8 Week SQL Challenge is proudly brought to you by me - Danny Ma and the Data With Danny virtual data apprenticeship program.
We have a large student community active on the official DWD Discord server with regular live events, trainings and workshops available to all Data With Danny students, plus early discounted access to all future paid courses.
There are also opportunities for 1:1 mentoring, resume reviews, interview training and more from myself or others in the DWD Mentor Team.
You can find me on social media below:
From your friendly data mentor, Danny :)