SQL Commands: DDL, DML, DQL, DCL & TCL Explained

🚀 SQL Commands Every Data Professional Should Know Structured Query Language (SQL) is the backbone of data management. Whether you're a beginner or advancing your data career, mastering SQL commands is essential. Here are some key SQL commands you should know: 🔹 DDL (Data Definition Language) CREATE, ALTER, DROP – Define and manage database structures 🔹 DML (Data Manipulation Language) INSERT, UPDATE, DELETE – Work with data inside tables 🔹 DQL (Data Query Language) SELECT – Retrieve data efficiently 🔹 DCL (Data Control Language) GRANT, REVOKE – Control access and permissions 🔹 TCL (Transaction Control Language) COMMIT, ROLLBACK, SAVEPOINT – Manage transactions securely 💡 SQL is not just a skill, it's a superpower in the data-driven world. Keep learning. Keep building. Keep querying. 💻✨ Follow Gowducheruvu Jaswanth Reddy for more content #SQL #DataAnalytics #DataScience #Learning #CareerGrowth #TechSkills #Database

Most data analysts have never written a recursive CTE. Then they're asked one in an interview and freeze. Recursive CTEs solve 3 specific problems that nothing else solves cleanly: 1. HIERARCHIES — "Find all employees under manager X, at any depth" WITH RECURSIVE tree AS ( SELECT id, manager_id, name, 1 AS depth FROM employees WHERE id = 5 UNION ALL SELECT e.id, e.manager_id, e.name, t.depth + 1 FROM employees e JOIN tree t ON e.manager_id = t.id ) SELECT * FROM tree; 2. DATE SPINES — "Generate a row for every day in 2026" WITH RECURSIVE dates AS ( SELECT DATE '2026-01-01' AS d UNION ALL SELECT d + INTERVAL '1 day' FROM dates WHERE d < DATE '2026-12-31' ) SELECT d FROM dates; Useful for filling missing dates in time series before joining to fact tables. 3. GRAPH TRAVERSAL — "Find all friends-of-friends within N degrees" Same UNION ALL pattern: anchor + recursive step + termination condition. When you SHOULDN'T use recursive CTEs: - Flat lookups (just JOIN) - Anything that fits in a single window function - Loops > 100 deep (databases hate this) When you SHOULD: - Org charts, category trees, comment threads - Date/number generation - Bill of materials, dependency graphs Practice 8 recursive CTE problems on real databases: https://lnkd.in/gs7Eueed Day 3 of 7 — Advanced SQL. #SQL #RecursiveCTE #AdvancedSQL #DataAnalyst #SQLInterview #DataAnalytics #InterviewPrep #FreeResources

Hello everyone! 👋 Welcome to Day 2 of #100DaysOfSQL 🚀 👉 Topic: Types of SQL Commands SQL commands are mainly divided into different categories based on their functionality. 👉 1. DDL (Data Definition Language) Used to define and modify database structure. Examples: - CREATE - ALTER - DROP - TRUNCATE 👉 2. DML (Data Manipulation Language) Used to manage data inside tables. Examples: - INSERT - UPDATE - DELETE 👉 3. DQL (Data Query Language) Used to retrieve data from the database. Example: - SELECT 👉 4. DCL (Data Control Language) Used to control access to data. Examples: - GRANT - REVOKE 👉 5. TCL (Transaction Control Language) Used to manage transactions. Examples: - COMMIT - ROLLBACK - SAVEPOINT 👉 Examples: CREATE TABLE students (id INT, name VARCHAR(50)); INSERT INTO students VALUES (1, 'John'); SELECT * FROM students; 👉 Key Takeaway: Understanding SQL command types helps you organize and write efficient queries. #SQL #LearningJourney #DataAnalytics #100DaysOfSQL

📓 𝗗𝗮𝘆 𝟭 — 𝗦𝗤𝗟 𝗕𝗮𝘀𝗶𝗰𝘀 Starting my Data Analytics journey with SQL 💻📊 Today I learned: 🔹 What is SQL (Structured Query Language) 🔹 What is a Database 🔹 Tables (Rows & Columns) 🔹 Types of SQL Commands (DDL, DML, TCL, DCL) 🔹 SELECT statement to fetch data 💡 Key Learning: SQL helps us communicate with data and extract meaningful insights. Consistency is the key 🚀 #SQL #DataAnalytics #LearningJourney #CareerSwitch #100DaysOfCode #Consistency

I used to memorize SQL JOINs… and still get them wrong. Until I realized something important: SQL joins are not syntax problems, they are relationship problems. INNER JOIN, LEFT JOIN, RIGHT JOIN all describe how two tables interact: INNER JOIN (JOIN)→ only what overlaps LEFT JOIN → everything on the left + matches RIGHT JOIN → everything on the right + matches Once I mapped it using Customers vs Orders and a simple Venn diagram, it finally clicked. Now SQL feels less like code… and more like logic. And in real-world data systems, that mindset matters more than memorization. #SQL #SQLJoins #DataAnalytics #DataEngineering #Database #LearningSQL #DataScience #BusinessIntelligence #Analytics #TechEducation #Programming #BackendDevelopment #RelationalDatabase #DataSkills #TechCareer

🚀 Day 19/50 – LeetCode SQL Challenge (Queries Quality & Percentage) Today’s problem focused on analyzing query performance by calculating quality and identifying poor queries using SQL. 📊 Key Concepts Used: • Aggregation (AVG, COUNT) • CASE WHEN (conditional logic) • Ratio calculation (rating / position) • ROUND() function 💡 Approach: Calculated query quality using AVG(rating / position) Used CASE WHEN to identify poor queries (rating < 3) Computed poor query percentage using average of conditional values Rounded both metrics to 2 decimal places for better readability 👉 Learned how to convert conditions into numerical values (0/1) and use AVG to directly calculate percentages. 🧠 Key Learning: AVG of 0/1 can be used to calculate percentage efficiently Combining aggregation with conditional logic simplifies complex problems Clean formatting (ROUND) makes results more professional 📈 Consistency in practice is building stronger SQL fundamentals every day #SQL #DataAnalytics #DataAnalyst #LearningInPublic #30DaysChallenge #SQLPractice #Analytics #CareerGrowth #Consistency #DataScience

🚀 SQL Journey – Day 32: Recursive CTE (Hierarchical Queries) Today I explored Recursive CTEs in SQL, a powerful concept used to work with hierarchical and parent-child data structures. A Recursive CTE (Common Table Expression) is a CTE that references itself repeatedly until a condition is met. 🔹 Basic Structure: - Anchor Query → starting point / base data - UNION ALL → combines results - Recursive Query → keeps fetching next level data - Stops when no more rows are returned 💡 Where it is used? ✔ Employee Hierarchy ✔ Organization Charts ✔ Category & Subcategory Trees ✔ Parent-Child Relationships ✔ Tree Structured Data 📌 Key Learnings: - Always use UNION ALL - Start with a strong base query - Prevent infinite loops - Limit recursion depth when needed Example use case: finding all employees under a manager in an organizational hierarchy. Learning Recursive CTEs helped me understand how SQL can efficiently handle multi-level relationships and tree structures. #SQL #SQLJourney #Day32 #RecursiveCTE #CTE #HierarchicalQueries #DataAnalytics #DataAnalyst #LearningInPublic #LinkedInLearning

🧠 SQL Command Types — The Foundation Every Data Professional Must Know If you're learning SQL, understanding command types is not optional — it’s essential. SQL is more than just writing queries. It’s about knowing what to use, when to use, and why to use it. Here’s a quick breakdown: 📌 DDL (Data Definition Language) Create, Alter, Drop, Truncate — Structure your database 📌 DML (Data Manipulation Language) Insert, Update, Delete, Merge — Work with your data 📌 DCL (Data Control Language) Grant, Revoke — Manage permissions 📌 TCL (Transaction Control Language) Commit, Rollback, Savepoint — Control transactions 📌 DQL (Data Query Language) Select — Retrieve and analyze data 💡 Mastering these basics builds a strong SQL foundation. And a strong foundation leads to better queries, better analysis, and better decisions. 🎯 Don’t just memorize commands — understand their purpose. Because in data… Clarity beats complexity. #SQL #DataAnalytics #DataScience #Database #Learning #TechSkills #BusinessIntelligence #CareerGrowth

📊 Exploring the Power of SQL I’ve been sharpening my SQL skills lately, and here are some key takeaways from my learning journey 👇 🔹 DDL, DML, DQL, TCL, DCL – Understanding the complete SQL ecosystem 🔹 Joins – Connecting data across multiple tables efficiently 🔹 Aggregate Functions – Turning raw data into meaningful insights 🔹 GROUP BY & HAVING – Analyzing and filtering grouped data 🔹 Subqueries – Writing smarter and more dynamic queries 🔹 Transactions – Ensuring data integrity with COMMIT & ROLLBACK 💡 Key Insight: SQL is not just about querying data—it’s about understanding data relationships and making informed decisions. 📌 Clean queries = Better performance + Better readability #SQL #DataAnalytics #Database #Learning #TechSkills #DataScience #CodingJourney

Till now, we’ve understood how data is stored in tables. But here’s the next question 👇 👉 What can we actually do with this data? In SQL, operations are divided into different categories: 🔹 DDL (Data Definition Language) Used to define and manage the structure of the database Examples: CREATE, ALTER, DROP 🔹 DML (Data Manipulation Language) Used to work with the data inside tables Examples: INSERT, UPDATE, DELETE 🔹 DQL (Data Query Language) Used to retrieve data Example: SELECT 🔹 TCL (Transaction Control Language) Used to manage transactions Examples: COMMIT, ROLLBACK 🔹 DCL (Data Control Language) Used for permissions and access control Examples: GRANT, REVOKE 👉 In simple terms: DDL → Structure DML → Data DQL → Query TCL → Control changes DCL → Permissions #SQL #DataAnalytics #LearnSQL #DataScience #TechEducation