A hands-on SQL learning repository documenting my journey from SQL fundamentals to advanced database concepts through practical projects and real-world query practice.
This repository contains my SQL learning journey, where I practice concepts by building mini database projects instead of simply solving isolated exercises.
The objective is to strengthen my understanding of SQL, relational databases, PostgreSQL, and database design by applying concepts in realistic scenarios.
- Learn SQL from beginner to advanced
- Master PostgreSQL
- Build real-world database projects
- Improve query writing and analytical thinking
- Practice database design and normalization
- Prepare for backend development and technical interviews
- SQL
- PostgreSQL
SQL-Learning/
│
├── Project-01-Library-Management/
├── Project-02-Employee-Analytics/
├── Project-03-Student-Management/
├── Project-04/
│
├── Resources/
│
└── README.md
Each project contains:
- Database creation
- Table design
- Sample data
- SQL queries
- Problem statements
- Learning notes (optional)
- CREATE DATABASE
- CREATE TABLE
- Data Types
- Constraints
- Primary Keys
- Foreign Keys
- INSERT
- UPDATE
- DELETE
- SELECT
- WHERE
- ORDER BY
- LIMIT
- DISTINCT
- COUNT()
- SUM()
- AVG()
- MIN()
- MAX()
- GROUP BY
- HAVING
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL JOIN
- SELF JOIN
- Subqueries
- Common Table Expressions (CTEs)
- Views
- Indexes
- Stored Procedures
- Triggers
- Transactions
- Relationships
- ER Modeling
- Normalization
- Schema Design
| Project | Description | Concepts |
|---|---|---|
| Project-01 | Library Management System | CRUD Operations, Constraints, Filtering, Sorting, Aggregate Functions |
| Project-02 | Employee Analytics | GROUP BY, Aggregate Functions, Multi-column Grouping |
| Project-03 | Coming Soon | - |
| Project-04 | Coming Soon | - |
- Database Design
- SQL Query Writing
- CRUD Operations
- Aggregate Functions
- Data Analysis
- Reporting Queries
- Relational Database Concepts
- Query Optimization (Upcoming)
- PostgreSQL Development (Upcoming)
- Joins
- Subqueries
- Views
- Indexes
- Stored Procedures
- Triggers
- Transactions
- Window Functions
- Common Table Expressions (CTEs)
- Query Optimization
- PostgreSQL Advanced Features
This repository reflects my continuous learning and practical implementation of SQL concepts through progressively challenging database projects.
Each project focuses on applying newly learned concepts to reinforce understanding and improve problem-solving skills.
If you're exploring SQL learning resources or reviewing my work, feel free to browse the projects and follow my progress.
⭐ If you find this repository useful, consider giving it a star.