Skip to content

README.md

Latest commit

 

History

History
86 lines (58 loc) · 2.9 KB

README.md

File metadata and controls

86 lines (58 loc) · 2.9 KB
Raw

📚 SQL Learning Journey

A personal repository to document and practice SQL concepts from scratch — one topic at a time.

🧠 About

This repo is my hands-on SQL practice space. As I learn new concepts — from basic queries to advanced joins and subqueries — I commit my practice files here to track my progress and build a reference I can revisit.

Learning approach: Topic-by-topic, with dedicated .sql files for each concept and real practice queries.

📂 Repository Structure

File Topics Covered
1. BASIC SQL.sql CREATE, DROP, INSERT, PRIMARY KEY, data types
2. SELECT SQL.sql SELECT, WHERE, ORDER BY, LIMIT, DISTINCT, aggregate functions
3. Update and Delete.sql UPDATE, DELETE, WHERE conditions, safe delete patterns
4. FOREIGN_KEY AND CASCADE.sql Foreign key constraints, ON DELETE CASCADE, referential integrity
5. Alter.sql ALTER TABLE — adding/dropping/modifying columns, renaming tables
6. JOINS.SQL INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN, SELF JOIN
7. SUB QUERIES AND VIEWS.SQL Subqueries, nested SELECT, CREATE VIEW, using views
8. ADVANCED SQL.SQL Indexes, Window Functions, CTEs, Stored Procedures, Transactions

🗺️ Learning Roadmap

  • Basic DDL & DML — CREATE, INSERT, DROP
  • SELECT queries & filtering
  • UPDATE & DELETE operations
  • Foreign keys & CASCADE behavior
  • ALTER TABLE operations
  • All types of JOINs
  • Subqueries & Views
  • Advanced SQL (added)
  • 🔄 Indexes & Query Optimization (in progress)
  • 🔄 Stored Procedures & Functions (in progress)
  • 🔄 Transactions & ACID properties (in progress)
  • 🔄 Window Functions (ROW_NUMBER, RANK, PARTITION BY) (in progress)
  • 🔄 CTEs (Common Table Expressions) (in progress)

🛠️ Tools & Setup

  • Database: MySQL / PostgreSQL (compatible with both)
  • Client: MySQL Workbench / cqlsh / DBeaver
  • Editor: VS Code with SQL extensions

💡 How to Use This Repo

If you're also learning SQL, feel free to clone and run these files locally:

git clone https://github.com/Swarajbabu/SQL_LEARNING.git

Open any .sql file in your preferred client (MySQL Workbench, DBeaver, or the terminal) and execute the queries to see them in action.

📌 Notes

  • Files are numbered in the order they should be studied.
  • Each file is self-contained with comments explaining what each query does.
  • This repo is actively updated as I progress through new topics.

👨‍💻 Author

Swaraj Babu B.Tech CSE | Lovely Professional University (2023–2027) Focused on: ML · Data Engineering · MLOps · GenAI

GitHub

⭐ If this helps you learn SQL too, drop a star!