🗄️ SQL Practice
A collection of SQL programs, queries, and database exercises created while learning SQL and Database Management Systems (DBMS).
This repository documents my progress from basic SQL queries to more advanced database concepts and problem-solving.
📚 Topics Covered
- ✅ SQL Basics
- ✅ Database & Table Creation
- ✅ Data Types
- ✅ INSERT, UPDATE & DELETE
- ✅ SELECT & Filtering
- ✅ Operators
- ✅ Sorting & Limiting
- ✅ Aggregate Functions
- ✅ GROUP BY & HAVING
- ✅ Joins
- ✅ Subqueries
- ✅ Constraints
- ✅ Keys
- ⏳ Views
- ⏳ Indexes
- ⏳ Functions & Procedures
- ⏳ Triggers
- ⏳ Transactions
- ⏳ Normalization
- ⏳ Advanced SQL
- ⏳ DBMS Problem Solving
📂 Repository Structure
sql-practice/
│
├── Basics/
├── Database/
├── Tables/
├── Queries/
├── Constraints/
├── AggregateFunctions/
├── Joins/
├── Subqueries/
├── Views/
├── Indexes/
├── Functions/
├── Procedures/
├── Triggers/
├── Transactions/
├── MiniProjects/
├── PracticeProblems/
│
├── .gitignore
└── README.md
The structure will grow as I learn more SQL and DBMS concepts.
🎯 Goals
- Build strong SQL fundamentals
- Improve database problem-solving skills
- Practice writing efficient queries
- Understand relational databases and DBMS concepts
- Prepare for academic examinations and GATE CSE
- Build a strong foundation for backend development
🛠️ Technologies
- SQL
- Relational Databases
- DBMS
📈 Progress
This repository is continuously updated as I learn and practice new SQL concepts.
«Learning SQL one query at a time.»
👨💻 Author
Adarsh Rai
BE Computer Science Engineering Student Learning C, Java, SQL & Data Structures and Algorithms
GitHub: "@adarshcsea" (https://github.com/adarshcsea)