SQL Learning and Reference Resources for Data Roles

Top 7 Platforms for Mastering SQL (2026 Edition) As a Data Analyst, I can tell you that "mastering" SQL isn't just about learning the syntax (the SELECT and FROM); it’s about understanding how to manipulate data to answer business questions. To help you move from a beginner to an expert in 2026, here are my top 7 go to platforms and resources you can avail; 1. SQLBolt (Best for Absolute Beginners) - https://sqlbolt.com/ If you are starting from zero today, go here first. • Why it’s great: It’s a free, interactive, text-based site that gets you writing your first query within 30 seconds. No setup required. 2. LearnSQL.com (Best for Comprehensive Depth) - https://learnsql.com/ Unlike general platforms, this is dedicated entirely to SQL. It offers 75+ interactive courses. • Why it’s great: It has specific tracks for "Reporting in SQL" and "Revenue Trend Analysis," which are the bread and butter of daily data analyst work. 3. Mode Analytics (SQL Tutorial) (Best for Practical Business Context)- https://lnkd.in/gH6qhiQs Mode is actually a data collaboration platform used by companies, and their free tutorial is legendary in the analyst community. • Why it’s great: It teaches you SQL within an environment that looks exactly like the one you’ll use on the job. 4. DataLemur (Best for Interview Preparation) - https://datalemur.com/ Founded by a former Facebook/Google Data Scientist, this platform is specifically designed to help you ace the technical interview. • Why it’s great: It features actual SQL interview questions from top tech companies like Amazon, Spotify, and Netflix. 5. Dataquest (Best for Hands-on, No-Video Learning) - https://lnkd.in/gxYyijm6 If you find video tutorials slow or distracting, Dataquest is the best alternative. • Why it’s great: You learn by writing code directly in the browser. It follows a "learn by doing" philosophy that builds muscle memory quickly. 6. StrataScratch (Best for Advanced Analysts) - https://lnkd.in/gAQS4tSD Once you know the basics, StrataScratch bridges the gap between "knowing SQL" and "solving problems." • Why it’s great: It provides access to 1,000+ real interview questions and focuses on the analytical logic behind the query. 7. YouTube: Data with Baraa (Best Free Resource) - https://lnkd.in/gvGWUmJd For a structured, free roadmap, Baraa Khatib Salkini provides one of the best curated "Data Analyst free course" on YouTube. • Why it’s great: He explains the why behind the concepts and provides walkthroughs of end-to-end projects you can put in your portfolio.

If you're learning SQL in 2025, this mindmap is your best friend. From beginners writing SELECT queries to advanced analysts optimizing joins and using window functions, this guide has it all: 1. 𝐒𝐐𝐋 𝐁𝐚𝐬𝐢𝐜𝐬 – SELECT, WHERE, ORDER BY, GROUP BY, and more. 2. 𝐅𝐢𝐥𝐭𝐞𝐫𝐢𝐧𝐠, 𝐒𝐨𝐫𝐭𝐢𝐧𝐠 & 𝐀𝐠𝐠𝐫𝐞𝐠𝐚𝐭𝐢𝐨𝐧s – Learn to slice data with conditions, BETWEEN, IN, and logical operators. 3. 𝐉𝐨𝐢𝐧𝐬 – Understand how to combine data from multiple tables with INNER, LEFT, RIGHT, and FULL OUTER joins. 4. 𝐖𝐢𝐧𝐝𝐨𝐰 𝐅𝐮𝐧𝐜𝐭𝐢𝐨ns – Use RANK(), LEAD(), LAG(), and ROW_NUMBER() for advanced analytics. 5. 𝐃𝐚𝐭𝐞 𝐅𝐮𝐧𝐜𝐭𝐢𝐨𝐧s – Work with time-based data using DATE_TRUNC(), EXTRACT(), NOW() etc. 6. 𝐀𝐝𝐯𝐚𝐧𝐜𝐞𝐝 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬 – Perform statistical analysis and integrate with ML tools like BigQuery ML and Snowflake ML. 7. 𝐂𝐓𝐄𝐬, 𝐓𝐞𝐦𝐩 𝐓𝐚𝐛𝐥𝐞𝐬 & 𝐒𝐮𝐛𝐪𝐮𝐞𝐫𝐢𝐞s – Reuse logic with WITH clauses, recursive queries, and subqueries. 8. 𝐏𝐞𝐫𝐟𝐨𝐫𝐦𝐚𝐧𝐜𝐞 𝐎𝐩𝐭𝐢𝐦𝐢𝐳𝐚𝐭𝐢𝐨n – Learn indexing, query planning, and writing efficient queries for dashboards. 𝐎𝐩𝐭𝐢𝐦𝐢𝐳𝐚𝐭𝐢𝐨𝐧 𝐓𝐢𝐩𝐬: - Use indexes on columns you frequently filter or join - Avoid SELECT * and only fetch the necessary columns - Use EXPLAIN or ANALYZE to understand query execution plans - Limit joins and subqueries when possible for better performance - Rewrite complex logic using CTEs or temp tables to improve readability 𝐇𝐨𝐰 𝐭𝐨 𝐋𝐞𝐚𝐫𝐧 𝐒𝐐𝐋 𝐄𝐟𝐟𝐞𝐜𝐭𝐢𝐯𝐞𝐥𝐲: – Practice simple SELECT, WHERE, and GROUP BY queries – Use sample datasets to understand INNER, LEFT, and FULL joins – Try window functions, date functions, and subqueries – Build dashboards or solve business problems using real-world data – Participate in SQL competitions or daily practice series Whether you're prepping for interviews, optimizing dashboards, or building data pipelines, this mindmap is your go-to reference. ♻️ Save it for later or share it with someone who might find it helpful! 𝐏.𝐒. I share job search tips and insights on data analytics & data science in my free newsletter. Join 15,000+ readers here → https://lnkd.in/dUfe4Ac6

These are the 3 SQL resources you need to know from my 5+ years of experience in data science and analytics: 1. DataCamp Associate Data Analyst in SQL ↳ Even as a working professional, I have returned to DataCamp many times to improve my skills because it offers real world datasets to practice. You can also practice performing exploratory data analysis and learn data driven decision making using SQL. 2. Analyst Builder MySQL for Data Analytics ↳ I have personally followed Alex since the start of my data journey and I absolutely love how simply he breaks down complex concepts. You will get hands-on experience similar to how we use MySQL in the industry by learning about production databases and naming conventions. 𝗕𝗼𝗻𝘂𝘀 𝗧𝗶𝗽: You can also prepare for interviews by taking the MySQL interview crash course, which is great for job interview prep. 3. W3Schools.com ↳ Five or six years ago, when I started learning SQL, this was my go to platform and it is still one of the best places to start. If you are one of those people who hate creating new accounts the good news is, you don’t even need an account to practice. DataCamp: https://lnkd.in/g6UENyqQ Analyst Builder: https://lnkd.in/gvS7mjJd W3Schools.com: https://lnkd.in/gU_9AJVZ

Here’s how I would prepare for SQL rounds at Amazon if I were appearing for roles like Data Engineering, Data Analyst & Business Intelligence Engineer in 2025. This is your roadmap created by a veteran senior data engineer who has spent 8 years at Amazon…. ♦ PHASE 1: SQL FUNDAMENTALS (Don’t Skip This) Goal: Learn how to query, manipulate, and understand relational databases. → Understanding Databases & SQL Basics What is SQL, and why do 99% of companies rely on it? Difference between OLTP (Transactional) vs OLAP (Analytical) databases. Learn data types (VARCHAR, INT, DECIMAL, TIMESTAMP) and when to use them. Download PostgreSQL, MySQL, or SQL Server & set up a practice database. → Writing Basic SQL Queries Retrieving Data: SELECT, FROM, WHERE, ORDER BY, LIMIT/OFFSET. Filtering Data: LIKE, BETWEEN, IN, IS NULL, NOT IN. Sorting & Aggregation: GROUP BY, HAVING, COUNT(), SUM(), AVG(), MIN(), MAX(). Basic Date & Time Operations (CURRENT_DATE, DATEADD, DATEDIFF). → Modifying Data Creating & Deleting Tables: CREATE TABLE, ALTER TABLE, DROP TABLE. Adding, Updating & Removing Data: INSERT INTO, UPDATE, DELETE FROM. Primary Keys & Foreign Keys: Why constraints matter for data integrity. ◄ Real-World Application: → Load a CSV file into PostgreSQL/MySQL and query it. → Write a query to find all users who signed up in the last 30 days. ◄ Common Interview Questions: → Find the second highest salary from an employee table. → Write a query to delete duplicate rows from a table. ♦ PHASE 2: INTERMEDIATE SQL (Where You Build Real Confidence) Goal: Handle complex data, optimize queries, and learn joins, subqueries, and performance tricks. → Mastering SQL Joins (Every Interviewer Will Ask This) INNER JOIN (Most common, only matches where both tables have a value). LEFT JOIN (Keeps all rows from the left, even if no match on the right). RIGHT JOIN (Opposite of LEFT JOIN, rarely used). FULL OUTER JOIN (Gets all data, even if no matches exist). CROSS JOIN (Cartesian Product, used sparingly). SELF JOIN (When you need to join a table to itself). Ran out of space, here’s the full roadmap: https://lnkd.in/gQYezNCk – Follow me, Shubham, for more insights like these Repost if you learned something new today!

🚀 Someone asked me to share SQL Roadmap. Here is the Roadmap of SQL for aspiring analyst: If you want to strengthen your data handling abilities and dive deeper into the world of databases. SQL is an essential tool for anyone working with data. Whether you're a beginner or an experienced data professional, having a roadmap can guide your learning journey and help you reach your goals. 🔹 Level 1: Foundations Introduction to SQL: Start by familiarizing yourself with basic SQL syntax, commands, and concepts such as SELECT, INSERT, UPDATE, DELETE, and WHERE clauses. Database Basics: Understand fundamental database concepts including tables, rows, columns, and primary keys. 🔹Level 2: Querying Data Data Retrieval: Learn to retrieve data from a single table using SELECT statements with various clauses like WHERE, ORDER BY, and LIMIT. Joins: Master the art of joining multiple tables together using INNER JOIN, LEFT JOIN, RIGHT JOIN, and OUTER JOIN. Aggregation Functions: Explore aggregate functions such as SUM, AVG, COUNT, MIN, and MAX to analyze and summarize data. 🔹Level 3: Advanced SQL Subqueries: Dive into the world of subqueries to perform complex operations and enhance your querying capabilities. Indexes and Performance Tuning: Understand how indexes work and utilize them to improve query performance. Views and Stored Procedures: Learn to create and utilize views for simplifying complex queries, and stored procedures for reusable code blocks. 🔹Level 4: Database Administration Database Design: Gain expertise in database design principles, normalization, and denormalization. Data Manipulation: Explore advanced data manipulation techniques including transactions, triggers, and user-defined functions. 🔹Level 5: Specializations Data Analytics: Apply SQL for data analysis, including window functions, CTEs (Common Table Expressions), and advanced statistical functions. Data Engineering: Learn ETL (Extract, Transform, Load) processes, data warehousing concepts, and big data technologies. Business Intelligence: Utilize SQL for creating reports, dashboards, and visualizations to drive business insights. 🔹Level 6: Continuous Learning Stay Updated: Keep abreast of the latest developments in SQL and database technologies by following industry blogs, attending webinars, and participating in online communities. Hands-On Practices: Practice your skills by working on real-world projects, contributing to open-source databases, or participating in hackathons. #dataanalyst

🚀 3-Month Data Analyst Roadmap: From Zero to Hero (with Free Resources!) No fluff. No distractions. Just what you need to land your first job. My last post on how to become a data analyst in 3 months sparked much interest, and many of you jumped into my DMs asking for a detailed roadmap. That’s exactly what this post is for. Because the biggest mistake beginners make? Learning everything except what matters. Here’s a laser-focused, beginner-friendly roadmap that takes you from clueless to confident, with free, high-quality resources at every stage. 📅 Month 1: Excel – The Foundation of Analysis 🔹 Week 1–2: Excel Basics Learn formulas, pivot tables, lookups, charts, everything foundational. 🎓 Resource: Complete Excel Course: Beginner to Expert by Simplilearn 🔗 Link: https://lnkd.in/dUB3-R6S 🔹 Week 3–4: Dashboard Building in Excel Build at least 3 interactive dashboards for your portfolio. 🎓 Resource: Creating Interactive Excel Dashboards by Data Decisions 🔗 Link:  https://lnkd.in/dmZR-ubH 📅 Month 2: SQL – Speak the Language of Data 🔹 Week 5: SQL Basics (We’ll use MySQL, but PostgreSQL is fine too) 🎓 Resource: MySQL Tutorial Series by Alex the Analyst 🔗 Link:https://lnkd.in/dY-f9AcW 🔹 Week 6: Advanced SQL – Joins, CTEs, Window Functions 🎓 Resource: SQL from Beginner to Advanced (4 Hours) 🔗 Link: https://lnkd.in/djmgpWeZ 🔹 Week 7–8: Data Storytelling + Report Writing This is where many learners fail. Learn how to communicate insights. 🎓 Resource: Data Storytelling & Visualization Playlist 🔗 Link: https://lnkd.in/dGQhmq4b 📅 Month 3: Microsoft Power BI – Bring Your Data to Life Learn Power BI directly from the official Microsoft learning path. Build beautiful reports, dashboards, and start solving business problems with data. 🎓 Resource: Data Analyst Career Path by Microsoft 🔗 Link: https://lnkd.in/dnhm2R_m 🎯 At This Point… You’re Job-Ready! But don’t stop there. Here's how to boost your visibility: ✅ Document your journey: Post weekly progress on LinkedIn. ✅ Build a portfolio website: Showcase your dashboards, SQL queries, and Power BI reports. 💬 I’ll share how to position yourself for data jobs while still learning in tomorrow’s post. Stay tuned! And if you found this helpful, please like, comment, or share to help others who might be feeling lost on their data journey. You've got this! 💪📊