Essential SQL Cheat Sheet for Full Stack Devs

I've put together this comprehensive SQL cheat sheet that covers everything from basic queries to advanced data manipulation. What's Included: Common SQL Commands: - SELECT/FROM/WHERE fundamentals - JOIN operations with visual guides - GROUP BY and ORDER BY clauses - Data Manipulation (INSERT, UPDATE, DELETE) - Table creation and modification Quick Reference for: - Command order of execution - Different types of JOINs with visual representations - Data Definition Language (DDL) commands - Data Manipulation Language (DML) syntax - Practical examples of common queries Pro Tips: - Master the ORDER of execution (FROM → WHERE → GROUP BY → HAVING → SELECT → ORDER BY → LIMIT) - Understand different JOIN types with visual diagrams - Learn key aggregation functions (COUNT, SUM, AVG, MIN, MAX) - Get familiar with CASE statements for conditional logic

𝗦𝗤𝗟 𝗖𝗵𝗲𝗮𝘁𝘀𝗵𝗲𝗲𝘁: 𝗧𝗵𝗲 𝗧𝗼𝗼𝗹 𝗧𝗵𝗮𝘁 𝗦𝗮𝘃𝗲𝗱 𝗠𝗲 𝗛𝗼𝘂𝗿𝘀 I was once stuck debugging a report that took hours to run. The reason? Bad SQL queries. After refining my SQL skills, I could optimize the same report to run in minutes. 𝗕𝗔𝗦𝗜𝗖 𝗖𝗢𝗠𝗠𝗔𝗡𝗗𝗦 → 𝗧𝗵𝗲 𝗙𝗼𝘂𝗻𝗱𝗮𝘁𝗶𝗼𝗻 ↬ Retrieve Data with SELECT: When I first started, I struggled to extract relevant rows from tables. With this, I could finally get what I needed: SELECT column_name FROM table_name; Example: Get all names of employees: SELECT name FROM employees; ↬ Filter Results with WHERE: Imagine needing only employees in “Sales”. Instead of scrolling through rows: SELECT * FROM employees WHERE department = 'Sales'; ↬ Insert Records with INSERT: Updating databases felt daunting until this trick: INSERT INTO employees (name, age) VALUES ('John', 30); ↬ Modify Data with UPDATE: One typo in a record, and you think, “Redo the whole thing?” Nope: UPDATE employees SET age = 31 WHERE name = 'John'; ↬ Remove Records with DELETE: Accidentally added dummy data? This fixed it in seconds: DELETE FROM employees WHERE name = 'John'; 𝗔𝗗𝗩𝗔𝗡𝗖𝗘𝗗 𝗧𝗥𝗜𝗖𝗞𝗦 → 𝗠𝗮𝘀𝘁𝗲𝗿 𝗬𝗼𝘂𝗿 𝗤𝘂𝗲𝗿𝗶𝗲𝘀 ↬ Combine Data with JOIN: Once, I needed to link customer orders with their details. This saved me hours: SELECT orders.id, customers.name FROM orders INNER JOIN customers ON orders.customer_id = customers.id; ↬ Group Data with GROUP BY: Want to count employees by department? Stop counting manually: SELECT department, COUNT(*) FROM employees GROUP BY department; ↬ Sort with ORDER BY: Sorting by salary was the key to finding top performers: SELECT name, salary FROM employees ORDER BY salary DESC; ↬ Filter Groups with HAVING: Finding departments with more than 5 people? Easy: SELECT department, COUNT(*) FROM employees GROUP BY department HAVING COUNT(*) > 5; 𝗧𝗛𝗘 𝗥𝗘𝗔𝗟 𝗜𝗠𝗣𝗔𝗖𝗧 → 𝗟𝗘𝗔𝗥𝗡𝗜𝗡𝗚 𝗙𝗥𝗢𝗠 𝗘𝗥𝗥𝗢𝗥𝗦 I spent months running slow queries, only to realize that knowing joins, indexing, and optimization could cut my time by 50%. Now it’s your turn → Start with these commands, master the basics, and tackle real-world challenges like a pro. 𝗣𝗿𝗮𝗰𝘁𝗶𝗰𝗲 𝗠𝗮𝘁𝗲𝗿𝗶𝗮𝗹: SQLZOO | Mode SQL Tutorial --- 📕 400+ 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀: https://lnkd.in/gv9yvfdd 📘 𝗣𝗿𝗲𝗺𝗶𝘂𝗺 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 𝗜𝗻𝘁𝗲𝗿𝘃𝗶𝗲𝘄 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 : https://lnkd.in/gPrWQ8is 📙 𝗣𝘆𝘁𝗵𝗼𝗻 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝗰𝗲 𝗟𝗶𝗯𝗿𝗮𝗿𝘆: https://lnkd.in/gHSDtsmA 📗 45+ 𝗠𝗮𝘁𝗵𝗲𝗺𝗮𝘁𝗶𝗰𝘀 𝗕𝗼𝗼𝗸𝘀 𝗘𝘃𝗲𝗿𝘆 𝗗𝗮𝘁𝗮 𝗦𝗰𝗶𝗲𝗻𝘁𝗶𝘀𝘁 𝗡𝗲𝗲𝗱𝘀: https://lnkd.in/ghBXQfPc --- Join What's app channel for jobs updates: https://lnkd.in/gu8_ERtK 📸/ @Swapna X

𝗦𝗤𝗟 𝗠𝗶𝗻𝗱𝗺𝗮𝗽 𝟮𝟬𝟮𝟱 – Your Go-To SQL Roadmap If you’re serious about data, you can’t afford to guess SQL. This mindmap? It’s everything you need, from basic SELECT to advanced analytics. What you’ll find (and what actually matters): 1. SQL Basics: SELECT, WHERE, GROUP BY, ORDER BY. (Master these — 90% of interviews start here.) 2. Filtering, Sorting, Aggregations: Use WHERE, BETWEEN, LIKE, IN, AND/OR. Get your sums and averages with COUNT, SUM, AVG, MIN, MAX, GROUP BY. 3. Joins (the real deal): INNER, LEFT, RIGHT, FULL OUTER — learn when to use each. Most analyst rounds test joins, not fancy theory. 4. Window Functions: RANK(), ROW_NUMBER(), LAG(), LEAD(). (Separates the real analysts from the copy-paste crowd.) 5. Date Functions: Work with dates: NOW(), DATE_TRUNC(), EXTRACT() — saves you in reporting tasks. 6. CTEs, Temp Tables, Subqueries: Write cleaner, reusable queries. (Huge for complex dashboards or business logic.) 7. Performance & Optimization: Use indexes, skip SELECT *, limit joins. EXPLAIN your queries. Make them run faster, not just “work.” How to actually learn: Practice writing basic SELECT + WHERE + JOIN queries Use free public datasets (Kaggle, Google BigQuery, etc.) Challenge yourself with window functions & date logic Build a sample dashboard (PowerBI/Tableau) using real SQL Keep this mindmap open whenever you get stuck This is the shortcut I wish I had when I started. → Save this, use it, share it with someone prepping for data roles. Link in comment for more hands-on SQL guides & resume tips.

If I were learning SQL from scratch today, I'd want this one page and nothing else for the first month. Most SQL resources either drown you in syntax or stay so basic you can't do anything real. This sheet is the rare middle: a clear path from "what is a database" all the way to query optimization, plus the concepts, commands, and practice resources in one place. Here's the arc it walks 👇 → Foundations - databases, tables, keys, and the core SELECT/FROM/WHERE. → Analysis - filtering, sorting, grouping, and aggregation to answer real questions. → Relationships - every JOIN type and subqueries to pull data from multiple tables. → Advanced querying - window functions and CTEs, the stuff interviews love. → Engineering - indexes, normalization, transactions, views, and performance tuning. And because knowing isn't doing, it points to practice projects (customer queries, churn analysis, query optimization case studies) so you can actually build the muscle. Save it, pick your level, and start. What would you build first to practice? ♻️ I share cloud , data analysis/data engineering tips, real world project breakdowns, and interview insights through my free newsletter. 🤝 Subscribe for free here → https://lnkd.in/ebGPbru9 Follow Abhisek Sahu for more such insights!!

Here's my Ultimate SQL Quick Reference Guide: (Save this post now for your interview prep) Most candidates learn SQL by watching tutorials and copying queries. But interviews don't test copy-paste skills. They test fundamentals. This cheat sheet visually breaks down everything you need: • What SELECT, WHERE, ORDER BY, DISTINCT actually do and when to use each • The real difference between WHERE and HAVING and why mixing them up fails your interview • How every JOIN works - Inner, Left, Right, Full, Self, Cross -  with what gets included and excluded • When to use a Subquery vs a CTE and why CTEs win in interviews every time • Window Functions explained simply -  the concept that separates junior analysts from senior ones • Indexes and performance optimization -  because writing a query and writing a fast query are two different skills • Every constraint you need to know -  PRIMARY KEY, FOREIGN KEY, NOT NULL, UNIQUE, CHECK, AUTO_INCREMENT • DELETE vs TRUNCATE vs DROP -  getting this wrong in production is a very bad day • Date and Time functions — DATEDIFF, DATE_ADD, DATE_SUB, TIMESTAMP -  every business question involves time • OLTP vs OLAP, ACID properties, Normalization vs Denormalization -  what senior roles actually test Remember: Daily practice is key to acing SQL interviews. Top Platforms to Practice SQL: -- DataLemur 🐵 (Ace the SQL & Data Interview) - https://datalemur.com/ -- StrataScratch - www.stratascratch.com/ -- LeetCode - https://leetcode.com/ -- HackerRank - https://lnkd.in/gDBqdrNP -- Mode - https://mode.com/ Top YouTubers to Learn SQL: 1. Alex Freberg 2. Ankit Bansal 3. Luke Barousse 4. Ken Jee 5. Shashank Mishra 🇮🇳 From basic queries to advanced data modeling - this guide gives you the full picture. If you found this useful, then please: ♻️ Repost to help others in your network 💭 Tag someone you know or Comment "CFBR" below P.S: Join 2,200+ subscribers as I share FREE SQL tips, job search resources, and career guides in my newsletter. Subscribe now: https://lnkd.in/gjUqmQ5H

SQL is still one of the most essential skills in data, engineering, and analytics and having a quick cheatsheet makes learning (or revising) 10× faster. Here’s a guide that breaks down the core SQL commands you’ll use in interviews, real-world projects, and daily database work. Here’s a simple overview of what it covers: 🔹 Create, Drop, Truncate Commands to create tables, delete databases, or clear data without removing the table. 🔹 Alter Modify table structure - add, drop, or change columns and types. 🔹 Insert, Update, Delete Core DML operations every SQL user must know by heart. 🔹 Select & Filtering Retrieve data using WHERE clauses, IN, NULL checks, and set comparisons. 🔹 Joins Inner, Left, Right, and Full Outer joins for combining related tables. 🔹 Ordering & Aggregations ORDER BY, COUNT, SUM, MAX, AVG - essential for analytical queries. 🔹 String & Arithmetic Operators Useful for formatting, calculations, and data transformations. 🔹 Triggers & Assertions Advanced SQL concepts used to enforce rules and automate actions. 🔹 Referential Actions How databases handle updates/deletes when foreign keys are affected. 🔹 Data Types Numeric, string, binary, date/time, and timestamp types used in SQL. 🔹 Cross Product & Set Operations UNION, INTERSECT, EXCEPT, and Cartesian products for complex queries. 🔹 Handling Duplicates Use DISTINCT or ALL to manage unique vs. repeated data. Whether you’re preparing for a SQL interview, building data pipelines, or learning database fundamentals - this cheatsheet gives you a quick, structured way to remember the essentials.

I almost crashed a production database early in my career with one bad query. SQL looks easy until an interviewer asks what is happening behind the scenes. If you are prepping for tech rounds, here are the 20 questions you will get asked the most: 1. CORE LOGIC • WHERE vs. HAVING • DELETE vs. TRUNCATE vs. DROP • Handling NULLs in aggregations • UNION vs. UNION ALL • Primary vs. Unique Key 2. JOINS & SUBQUERIES • Inner, Left, Right, and Full Joins • Self Joins • Cross Joins (Cartesian products) • CTEs vs. Subqueries • Correlated Subqueries 3. WINDOW FUNCTIONS • ROW_NUMBER() vs. RANK() vs. DENSE_RANK() • Nth highest salary • LEAD() and LAG() • Running totals • Deleting duplicate rows 4. PERFORMANCE • Clustered vs. Non-Clustered Indexes • Using EXPLAIN execution plans • Regular vs. Materialized Views • Normalization (1NF–3NF) • ACID properties Don't just write the query. Explain your index strategy and edge cases like NULLs before they ask. Save this for your next round 📌

The Only SQL MindMap You Need! No matter the data role—be it Data Analyst, Data Scientist, or Engineer—SQL is an absolute must-have skill! When I started learning SQL, I often found myself juggling between syntax, commands, and concepts. I know how overwhelming it can feel at the start. So, I thought—why not create a one-stop MindMap to simplify it all? Most of your daily SQL tasks revolve around mastering a few simple concepts that make everything else easier: ↳ Querying data efficiently ↳ Managing row-level operations ↳ Sorting data to make sense of trends ↳ Joining tables to combine information ↳ Grouping data to summarize key insights 𝐇𝐞𝐫𝐞’𝐬 𝐰𝐡𝐚𝐭 𝐲𝐨𝐮 𝐫𝐞𝐚𝐥𝐥𝐲 𝐧𝐞𝐞𝐝 𝐭𝐨 𝐟𝐨𝐜𝐮𝐬 𝐨𝐧: 1. 𝐃𝐚𝐭𝐚 𝐒𝐞𝐥𝐞𝐜𝐭𝐢𝐨𝐧 𝐌𝐚𝐬𝐭𝐞𝐫𝐲 ↳ SELECT is your primary tool for pulling data from tables. ↳ Leverage date functions to handle time-based data in reports. 2. 𝐉𝐨𝐢𝐧𝐬 ↳ LEFT JOIN is crucial when you need to keep all records from one table and match them with another. ↳ INNER JOIN helps you combine data from two tables, keeping only the matching rows. 3. 𝐅𝐢𝐥𝐭𝐞𝐫𝐢𝐧𝐠 𝐃𝐚𝐭𝐚 ↳ Master basic conditions with AND, OR. ↳ Use IN, NOT IN, and handle NULL values to refine your queries. 4. 𝐆𝐫𝐨𝐮𝐩𝐢𝐧𝐠 𝐃𝐚𝐭𝐚 ↳ GROUP BY helps organize data into meaningful categories. ↳ Use HAVING to filter your results after grouping. 5. 𝐑𝐨𝐰-𝐋𝐞𝐯𝐞𝐥 𝐎𝐩𝐞𝐫𝐚𝐭𝐢𝐨𝐧𝐬 & 𝐀𝐠𝐠𝐫𝐞𝐠𝐚𝐭𝐢𝐨𝐧𝐬 ↳ Use Window Functions like ROW_NUMBER(), RANK(), and DENSE_RANK() for advanced row-level analysis. ↳ Aggregations like SUM(), COUNT(), and AVG() are essential for summarizing data, and these also often go hand in hand with row-level operations. These functions help with operations such as ranking or calculating moving averages. Mastering these five categories will make your SQL tasks more efficient and effective. Focus on getting the basics right, and the rest will follow! Here’s a SQL mind map that you can use to visualize these core concepts and reinforce your learning. 𝐖𝐡𝐞𝐫𝐞 𝐭𝐨 𝐩𝐫𝐚𝐜𝐭𝐢𝐜𝐞? 1. Dataford - https://lnkd.in/enbEEgYd 2. Interview Query - https://lnkd.in/dzJET9aC 3. Analyst Builder - https://lnkd.in/dgVStuq8 4. LeetCode - https://leetcode.com/ 𝐏𝐫𝐨 𝐓𝐢𝐩: Practice consistently, tackle real-world problems, and challenge yourself! And remember: "𝐃𝐨𝐧’𝐭 𝐢𝐠𝐧𝐨𝐫𝐞 𝐒𝐐𝐋, 𝐨𝐫 𝐲𝐨𝐮 𝐦𝐢𝐠𝐡𝐭 𝐠𝐞𝐭 𝐢𝐠𝐧𝐨𝐫𝐞𝐝." 😉 ♻️ Save it for later or share it with someone who might find it helpful!