You are reading this, because it's your job to get data out of a warehouse, and get insights out of your data. Maybe you are doing it full time, maybe you have other responsibilities. If you want to get highly proficient at SQL fast and save yourself time in the long-run - this post is for you.
In this post we discuss the fastest way to get to a very high level of SQL proficiency.
As anything in life, at some point, learning a skill has diminishing returns. We want to help you get to a high level of proficiency fast. You will be able to solve your use cases rather quickly. Anything beyond that point needs additional effort and the return of (learning) investment is not that high anymore. Based on your job or where you wanna go, it might still be worth the investment.
Playing through Super Mario might be worth the time, solving the whole game within 5 min might not be worth the effort.
… I take it back. Totally worth the effort.
Enough chit-chat, let's get started.
Based on your proficiency with coding & numbers, it might only take you a few days to get really proficient with SQL.
For people with no experience with coding & numbers - 1-2 months, and you will be highly proficient. From zero to SQL wizard.
- It's all about the fundamentals - Know the basics of SQL
- Do it like Naruto - Practice, Practice, Practice
- Only reality is real, bro - Do real life use cases as soon as possible
- Be German - Know in which order Queries are executed
- How deep is your love - Learn Subqueries & CTEs
- Feel the queries - Know the most essential SQL commands by heart
- Shortcuts are things you should take - Know the most important shortcuts
- Finding Mister Miyashi - Ask people who are very good at coding for their best productivity hacks
- Ascend to the cloud - Learn how to use a data warehouse
- not typing is faster than typing - Know a little bit of coding to automate your queries
1-7 are basics to advanced
8-10 will get you to Super Saiyan Level
A great way to get started is the tutorial from Mode. It's very well done and has some exercises to go along with the lessons. You can also sign up for free and use their sample data sets to practice your SQL.
When you already know a coding language, then this course will take you around 1-5 full days to finish.
If know are completely new to coding and come from an Excel background (i.e. are proficient with numbers) this might take you 2 weeks.
Best to do points 1 and 2 together - meaning - do a bit of theory and then practice.
When you know your basics, start practicing right away. Don't get stuck on theory. You didn't become a great football player, dancer, gamer [insert something you are really good at here] by knowing the rules in and out. Why would you with SQL?
This is a great place with many SQL exercises (around 50-60)
Should take you a few days to solve them.
1-4 days for proficient SQL users, 1-2 weeks for newcomers.
If you can't solve the hard ones, that's totally fine. In real life, you don't have to solve such hard problems and when you do, you'll figure it out.
Here are some ideas.
Or just search for
SQL projectson Google
Or do the work you were hired for…
A project could take you a few days or longer
Knowing this will help you understand, why some of your queries don't work like you intend them to. This is really important on your way to becoming a SQL Sage.
This should take you less than 1h
Learn what they are, why to use them, how to use them and practice.
This should just take you an hour.
Don't go too deep into subqueries - it's unreadable —> hard to debug —> bad practice at some point
Don't worry, if you have followed this far, you should be good. Also in Y42 we do a lot of auto-completion for you.
This is basically a freebie.
Unlike in life, in code you should take shortcuts. You should do it a lot. They help you become so blazingly fast, that people will think you have super powers.
At least know the most important ones for now:
It might take a bit to get used to them, but once you do, you'll be much faster.
maybe 1h investment
Ask people for tips as much as you can. Sometimes they'll tell you things you didn't even know you needed but help you improve your skills significantly.
Ask for productivity hacks, how they would go about a problem in general, how they organize their coding environment etc.
What helped them get really proficient.
What concepts, code snippets they use most often
In the future, you will most probably work with modern data warehouses like Big Query & Snowflake. Know how to use them to save time and money.
More advanced BigQuery
Use your data warehouse to it's fullest:
Now we are entering advanced land. You don't need this, but a little bit of an investment goes a long way towards SQL sagehood.
I mean, now that you know how to SQL, might as well learn to code a little 🤷♂️
This is almost like learning a coding language. You will be able to write SQL code in a very scalable way. People will think, how on earth does this person manage to pull it off? If you get here, you are playing the SQL game on the highest level.
Updated about 1 year ago