SQL Learning Repository

📂 Structure

• Each file contains specific topics or concepts in SQL.
• Inline comments are included to explain key logic and takeaways.

📋 Topics

📦 SQL
│-- 001-WALKTHROUGH.sql        # A quick overview of SQL concepts
│-- 002-DB_CREATION.sql        # Create database and basic setup
│-- 003-DRL.sql                # Data Retrieval Language (SELECT queries)
│-- 004-DDL.sql                # Data Definition Language (CREATE, ALTER, DROP)
│-- 005-DML.sql                # Data Manipulation Language (INSERT, UPDATE, DELETE)
│-- 006-E-COMMERCE_DB.sql      # Complete E-commerce DB design
│-- 007-INNER_JOIN.sql         # INNER JOIN concepts and queries
│-- 008-LEFT_JOIN.sql          # LEFT JOIN and NULL behavior
│-- 009-RIGHT_JOIN.sql         # RIGHT JOIN and comparison with INNER JOIN
│-- 010-FULL_JOIN.sql          # FULL JOIN (using UNION)
│-- 011-CROSS_JOIN.sql         # Cartesian product (CROSS JOIN)
│-- 012-SELF_JOIN.sql          # SELF JOIN (same table relationships)
│-- 013-SET_OPERATIONS.sql     # UNION, UNION ALL, INTERSECTION, MINUS
│-- 014-SUBQUERIES.sql         # Subqueries (scalar, correlated, etc.)
│-- 015-VIEWS.sql              # Views (virtual tables)

📚 Resources

Here are some of the best resources I studied from:

1. Complete SQL in 1 VIDEO
2. SQL Tutorials

🔗 Other useful resources

• Chai SQLab

📬 Connect with Me

🤝 Contributing

Contributions are welcome!

• Found an error? Let me know (even spelling mistakes count! 📝).
• Have useful learning notes? Feel free to fork & enhance this repository!