🗄️ SQL-PROGRESS

Structured SQL practice repository covering fundamentals to advanced database concepts.

This repository documents my SQL learning journey — from core queries to advanced database concepts used in real-world data and AI/ML engineering roles.

📌 About This Repository

This repo includes:

SQL fundamentals

Query optimization

Joins & subqueries

Aggregations & grouping

PL/SQL concepts

Triggers & procedures

Interview-focused SQL problems

The goal is to build strong database skills required for Data Analyst, Backend, and AI/ML Engineer roles.

🧠 Topics Covered 🔹 1. SQL Fundamentals

SELECT statements

WHERE conditions

ORDER BY

DISTINCT

LIMIT

🔹 2. Filtering & Conditions

AND / OR / NOT

BETWEEN

IN

LIKE

IS NULL

🔹 3. Aggregation Functions

COUNT()

SUM()

AVG()

MIN()

MAX()

GROUP BY

HAVING

🔹 4. Joins

INNER JOIN

LEFT JOIN

RIGHT JOIN

FULL JOIN

SELF JOIN

🔹 5. Subqueries

Nested queries

Correlated subqueries

🔹 6. Advanced SQL

Views

Indexes

Constraints

Transactions

Normalization basics

🔹 7. PL/SQL

Procedures

Functions

Triggers

Cursors

Exception Handling

🛠 Tools Used

Oracle SQL / PL-SQL

PostgreSQL

MySQL

VS Code

CC Labs (Virtual Lab Environment)

📂 Repository Structure SQL-PROGRESS/ │ ├── fundamentals/ ├── joins/ ├── aggregations/ ├── subqueries/ ├── plsql/ ├── interview_questions/ └── README.md