🔗 Understanding Joins in MySQL (INNER, LEFT, RIGHT & FULL OUTER JOIN)all types of JOINS in MySQL 📅 Date: 7th October 2025In this post, we’ll explore all types of JOINS in MySQL — how they work, when to use each, and common mistakes to avoid. 🧩 What is a JOIN? A JOIN in SQL is used to combine data from two or more r...Oct 7, 2025·5 min read
🚀 SQL SELECT, Logical Operators, Sorting, LIMIT & OFFSET — With Examples & Common MistakesSep 29, 2025·4 min read
📌 SQL SELECT & Operators – My Practice Notes (With Mistakes I Made)1. What is SELECT? The SELECT statement is part of DQL (Data Query Language).It is used to query and display data from tables. 👉 Think of it like a “search engine” for your database.It doesn’t change data, it only retrieves it. Basic syntax: SELECT ...Sep 26, 2025·9 min read
MySQL DML Basics (INSERT, UPDATE, DELETE) – Common Mistakes I Made & How You Can Avoid Them1. What is DML? DML stands for Data Manipulation Language.It is used to manipulate table data, not the structure.Commands: INSERT → Add data into a table UPDATE → Modify existing data DELETE → Remove data from a table 2. Database & Table Setup ...Sep 25, 2025·2 min read
MySQL DDL Commands Explained (With Examples)When learning SQL, **DDL (Data Definition Language)** is the first step. DDL is used to **define, alter, and remove** database structures like databases and tables. ## 📌 1. CREATE (Database + Table) ```sql CREATE DATABASE ash; USE ash; CREATE TAB...Sep 24, 2025·2 min read