SQL_LEARNING

KO | EN

gitlite — search

#javascript #hacktoberfest #ai #llm #golang #machine-learning #deep-learning #linux #macos #java #kubernetes #awesome-list #vue #ios

(★ 17)

📚 My SQL learning journey — practicing from basics to advanced queries, joins, subqueries, views & more.

SQL_LEARNING 최신버젼 다운로드

최종 버전 다운로드 (.zip)

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

# 📚 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

- [x] Basic DDL & DML — CREATE, INSERT, DROP
- [x] SELECT queries & filtering
- [x] UPDATE & DELETE operations
- [x] Foreign keys & CASCADE behavior
- [x] ALTER TABLE operations
- [x] All types of JOINs
- [x] Subqueries & Views
- [x] 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:

```bash
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](https://img.shields.io/badge/GitHub-Swarajbabu-181717?style=flat&logo=github)](https://github.com/Swarajbabu)

---

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

SQL_LEARNING

SQL_LEARNING 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

SQL_LEARNING

SQL_LEARNING 최신버젼 다운로드

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

Download README