Learn SQL in 30 days for FREE with these 5 amazing resources:
(be sure to bookmark this 30-Day SQL Roadmap)
A threadπ§΅π
(be sure to bookmark this 30-Day SQL Roadmap)
A threadπ§΅π
Week 1 ποΈ
Work through the first 12 free interactive lessons on SQL Bolt.
This will teach you
β SELECT
β WHERE
β JOINS
β Aggregate Functions
Don't worry about the Update/Create/Alter table lessons - skip these!
sqlbolt.com
Work through the first 12 free interactive lessons on SQL Bolt.
This will teach you
β SELECT
β WHERE
β JOINS
β Aggregate Functions
Don't worry about the Update/Create/Alter table lessons - skip these!
sqlbolt.com
Week 2 ποΈ
Work through the 38 short 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 π§
w3schools.com
Work through the 38 short 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 π§
w3schools.com
Week 3 ποΈ (Part 1)
For the first half of the week, work through the Intermediate SQL lessons on Mode Analytics SQL tutorial.
This will teach you:
β GROUP BY
β CASE
β WHERE vs. HAVING
β UNION
β SELF-JOINs
mode.com
For the first half of the week, work through the Intermediate SQL lessons on Mode Analytics SQL tutorial.
This will teach you:
β GROUP BY
β CASE
β WHERE vs. HAVING
β UNION
β SELF-JOINs
mode.com
Week 3 ποΈ (Part 2)
For the second half of the week, work through Danny Ma's SQL Case Studies.
These more open-ended questions will force you to combine and apply multiple SQL concepts which is a MUST for Data Analytics & Data Science jobs.
8weeksqlchallenge.com
For the second half of the week, work through Danny Ma's SQL Case Studies.
These more open-ended questions will force you to combine and apply multiple SQL concepts which is a MUST for Data Analytics & Data Science jobs.
8weeksqlchallenge.com
Week 4 ποΈ
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 the entire platform is FREE!
datalemur.com
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 the entire platform is FREE!
datalemur.com
For example, here's an "EASY" interview question from Facebook on DataLemur.com
You can write code directly in the browser, have your query automatically graded, and get help on the discussion board!
You can write code directly in the browser, have your query automatically graded, and get help on the discussion board!
Hope this helps kickstart your SQL journey!
1. Follow me @NickSinghTech for more SQL resources
2. RT the tweet below to share this thread with your audience
1. Follow me @NickSinghTech for more SQL resources
2. RT the tweet below to share this thread with your audience
Loading suggestions...