The FREE Complete SQL Roadmap with a 12-week learning plan, 8 ready-to-use queries, & 3 portfolio-building projects to land your first data analyst job.
No signup • Instant access • Proven path to a data career
Watching hours of videos but still can't write a simple JOIN query from scratch. Your confidence is sinking.
How do you get a data job without experience? How do you get experience without a data job? This roadmap is the answer.
You know SQL is essential, but the learning path is a confusing maze. This cheatsheet gives you a step-by-step plan.
This isn't just a cheatsheet; it's a structured roadmap to a new career.
Install your environment, learn core concepts like Tables, Rows & Columns, and master basic syntax.
Write SELECT statements, filter with WHERE, sort with ORDER BY, and control results with LIMIT.
Use string and date functions, math operations, handle NULLs, and remove duplicates with DISTINCT.
Aggregate data with GROUP BY, filter groups with HAVING, combine tables with INNER JOIN, and write subqueries.
Master all JOIN types (LEFT, RIGHT, FULL), use Window Functions like RANK(), and write readable CTEs.
Work with messy data from Kaggle, build portfolio projects, and integrate SQL with BI tools like Tableau or Power BI.
Go beyond theory. These 3 real-world projects will prove your skills to any employer.
Identify the top 10 customers by total purchase amount in the last 6 months. A classic business problem.
Compare average sales price vs. list price to find discounting patterns across product categories.
Find customers at risk of churning by identifying who purchased in Q1 but not in Q2. Includes an outreach campaign plan.
"I was stuck in tutorial hell for months. This roadmap gave me the structure I needed. The portfolio projects were the key to landing my first data analyst job!"
Junior Data Analyst
"The 12-week plan is brilliant. It breaks down a huge topic into manageable steps. I finally feel confident in my SQL skills."
Marketing Analyst
"As a hiring manager, I wish more candidates had portfolios like the ones in this cheatsheet. It shows real-world problem-solving skills, not just theory."
Data Science Manager
Stop dreaming, start doing. Your future self will thank you.