December 17, 2022
Want to learn SQL in 30 days, using completely FREE SQL resources? I've got you covered! 👇
For context, this 30-day SQL roadmap has been used by the hundreds of aspiring Data Analysts and Data Scientists I career coach, and I can personally vouch for every single resource listed here in its ability to teach you SQL! And if for some reason you only have a week, I put an abridged version of the roadmap at the end!
Work through the first 12 FREE interactive SQL lessons on SQL Bolt.
This will teach you SQL commands like:
Don't worry about the Update/Create/Alter table lessons - skip these because they are more for database administrators. The majority of Data Analyst and Data Science work is about querying – not updating/altering the database tables!
If you find yourself breezing through this tutorial, use any extra time in week 1 to play these 4 fun SQL games.
Work through the 38 short free SQL tutorials on W3Schools. This will cover similar material as SQL Bolt BUUUT It's absolutely worth repeating these SQL concepts so that they'll sink into your brain!
Word of advice: actually do every single SQL exercise in W3. While they aren't tough, there is a world of difference between reading a SQL tutorial,, and actually DOING the exercises from the SQL tutorial!
For the first half of the week, work through the Intermediate SQL lessons on Mode Analytics free SQL tutorial.
This will teach you more advanced SQL commands like:
If you are a speedy learner, I recommend their advanced SQL lessons as well, which are more open-ended SQL case studies, because it helps you start thinking like a proper data analyst!
For the second half of the 3rd week, work through Danny Ma’s 8 week SQL Challenge! Don't let the name fool you, because if you focus the 8 SQL case studies can be done in half a week!
These more open-ended questions will force you to combine and apply multiple SQL concepts which is a MUST for those learning SQL who hope to land Data Analytics & Data Science jobs.
Put your SQL knowledge to the test on DataLemur by practicing the 60+ real SQL interview questions asked by companies like Facebook & Google. Each question comes with a full solution and multiple hints, and you can filter the question list based on which SQL pattern the problem uses.
DataLemur also a comprehensive SQL Interview Guide for Data Analysts with tips on how to approach tricky SQL interview questions.
To start practicing, try the easy Amazon SQL interview question below.
Since you're in a hurry, you'll also like this guide on cramming for SQL interviews, which covers how to study for a SQL assessment if you've only got a few hours or few days to prep.
If this 30-day plan seems like too much work, I have an easier 7-day SQL study roadmap too.
It’s reasonable to learn the basics of SQL in one week, especially if you have past programming experience in a language like Python or R. By spending 2 hours a day, you’ll be able to finish this 14-hour SQL study plan in just 7 days.
Let’s face it – 30 days is enough to start with SQL, but not enough to master SQL. If you’ve got more than a month, check out the SQL book recommendations in the list 17 Best Books for Data Analysts.
4 SQL Games That Make Learning SQL FUN!