SQL Joins Simplified: A Beginner's Guide

“Here is some basic SQL notes… saved for future me (and anyone else who needs it).” Because let’s be honest — we all learn SQL… and then forget the syntax the moment we actually need it 😅 So instead of pretending I’ll remember everything, I decided to document the basics: - Core queries - Filtering - Aggregations - Joins & more Nothing fancy. Just the stuff that actually gets used. Sometimes the smartest thing in tech isn’t knowing everything… it’s knowing where you saved it 😉 #SQL #DataAnalytics #DataScience #LearningInPublic #TechNotes

🚀 Day 2 of My SQL Learning Journey Today I learned about the WHERE clause in SQL. 👉 WHERE is used to filter data based on specific conditions. Basic syntax: SELECT column_name FROM table_name WHERE condition; ✔ Helps in retrieving only the required data ✔ Can be used with operators like =, >, <, AND, OR 💡 Learning WHERE made me realize how powerful SQL is when working with large datasets. Excited to keep improving! 🔥 Next: INSERT statement 👀 #SQL #LearningJourney #Beginner #DataAnalytics #Day2 #LearnInPublic

No matter how long you’ve worked with SQL, you always end up revisiting the basics. Joins, CTEs, window functions, optimization — fundamentals never stop being useful. Sometimes the best learning is simply going back to the core. 🚀 What’s one SQL concept you use all the time? #SQL #DataAnalytics #ContinuousLearning #LearningJourney #TechCommunity

SQL looked simple to me at first, just a few commands like SELECT, WHERE, and JOIN. However I realised how deep it actually is. The more I explore, the more ways I see to structure and retrieve data depending on the problem. It’s the kind of skill that never really loses its value with practice. It feels like something that never really gets old, no matter how much you practice. #SQL #DataSkills

💡 Day 4 of My SQL Learning Journey – JOINS 🔥 Today I learned one of the most powerful SQL concepts — JOINS 👉 JOINS help combine data from multiple tables. 📊 Example: SELECT students.name, marks.marks FROM students INNER JOIN marks ON students.id = marks.student_id; ✨ This returns only matching records from both tables. 💡 Types of JOINS: ✔ INNER JOIN – common data ✔ LEFT JOIN – all left + matching right ✔ RIGHT JOIN – all right + matching left ✔ FULL JOIN – complete data 🚀 This is where SQL becomes powerful! 👉 Question: Which JOIN do you find most confusing? #SQL #DataAnalytics #Joins #LearningJourney #Day4 #SQLBasics

SQL Cheat Sheet👇 SQL isn’t just about writing queries it’s about understanding how they execute. Every query follows a flow: FROM → WHERE → GROUP BY → HAVING → SELECT → ORDER BY → LIMIT This means data is first picked, then filtered, grouped, and only at the end selected and sorted. Once you understand this sequence along with basics like JOINs and aggregations, your queries become more accurate and efficient. #SQL #DataAnalytics #DataEngineering #Learning #TechSkills

🚀 Day 44 of My SQL Learning Journey Today I solved a SQL problem involving aggregation and distinct counting 🔥 🔹 Problem: Find number of unique leads and partners per day 🔗 Problem Link: https://lnkd.in/gXnubrbd 🔹 Solution: SELECT date_id, make_name, COUNT(DISTINCT lead_id) AS unique_leads, COUNT(DISTINCT partner_id) AS unique_partners FROM DailySales GROUP BY date_id, make_name; 🔹 Key Learning: Using multiple COUNT(DISTINCT) Grouping by multiple columns Real-world reporting queries 💡 SQL helps transform raw data into meaningful insights! Consistency continues 🚀 #SQL #LeetCode #90DaysOfCode #CodingJourney #DataAnalytics

Day 27 of my SQL Night Learning Journey 🌙 Today, I learned about the SELECT INTO statement, and it made things feel a lot more practical. In simple terms, SELECT INTO helps you create a new table from an existing one while copying the data into it at the same time. Think of it like: “Take this table, duplicate it, and save it as a new one.” This is especially useful when: You want to create a backup of your data You need a temporary table to run the analysis without touching the original data One important thing I learned: The new table copies the columns and data types, but it does NOT automatically include things like: Primary keys Indexes NOT NULL constraints So it’s not a perfect clone, but it gets the job done for most use cases. A simple example that stood out to me: Creating a backup of a table by copying everything into a new one. Little by little, SQL is starting to feel less intimidating and more like a tool I can actually use 🛠️ #SQL #LearningInPublic #DataAnalytics #BeginnerFriendly #TechJourney #Consistency #WomenInTech

Window Functions in SQL always felt confusing to me — especially OVER(), PARTITION BY and ORDER BY. So I tried breaking it down in the simplest way possible. A detailed explanation on all window functions will be in the next post. Till then, happy learning 🚀 #SQL #DataEngineering #WindowFunctions #openfornewopportunity #datalearning

This one’s for every data engineer who’s ever stared at a screen at 2 AM, wondering if it’s LEFT JOIN or just JOIN… Behind every clean dashboard, fast pipeline, and reliable report is someone who once wrestled with NULL handling, stared down a 10-table join, and quietly celebrated the first time a window function clicked. I still keep this SQL cheat sheet within arm's reach. Not because I don’t know the syntax — but because it reminds me that mastery isn’t about memorization. It’s about knowing where to look, how to think, and never letting go of curiosity. #DataEngineering #SQL #TechWithHeart #AlwaysLearning