Welcome to sql-notes-and-practice — a complete, beginner-to-advanced SQL learning roadmap broken down into 35 days of structured, practical, and real-world practice. Whether you're preparing for SQL interviews, upskilling for data-related roles, or just want to master SQL, this repo is your perfect daily companion. 🎯
🔥 Learn. Practice. Master. One day at a time.
- ✅ Beginner-friendly roadmap for learning SQL
- ✅ Daily structured modules with summaries, sample data & practice queries
- ✅ MySQL Workbench ready
- ✅ Real-world projects for hands-on experience
- ✅ Ideal for interview prep, practice, and revision
| Day | Topics |
|---|---|
| Day 1 | CREATE TABLE, INSERT, SELECT |
| Day 2 | WHERE, AND, OR, NOT |
| Day 3 | IN, BETWEEN, LIKE, IS NULL |
| Day 4 | ORDER BY, LIMIT, OFFSET |
| Day 5 | UPDATE, DELETE,DROP,ALTER,TRUNCATE |
| Day 6 | DISTINCT, COUNT, MIN, MAX, AVG, SUM |
| Day 7 | Review + Practice Set |
| Day | Topics |
|---|---|
| Day 8 | GROUP BY, HAVING |
| Day 9 | INNER JOIN |
| Day 10 | LEFT JOIN, RIGHT JOIN |
| Day 11 | FULL OUTER JOIN |
| Day 12 | Self Join |
| Day 13 | UNION, INTERSECT, EXCEPT |
| Day 14 | Review + Real-World Query Practice |
| Day | Topics |
|---|---|
| Day 15 | Subqueries |
| Day 16 | Correlated Subqueries |
| Day 17 | CASE, IF, COALESCE |
| Day 18 | Views |
| Day 19 | Indexes (Intro) |
| Day 20 | Stored Procedures |
| Day 21 | Transactions & ACID |
| Day 22 | Review + Practice Set |
| Day | Projects |
|---|---|
| Day 23 | Student Database |
| Day 24 | Library Management |
| Day 25 | E-Commerce Database |
| Day 26 | HR & Payroll System |
| Day 27 | Hotel Booking System |
| Day | Topics |
|---|---|
| Day 28 | Final Capstone Project |
| Day 29 | Query Optimization + Indexing |
| Day 30 | Polish & Upload Repo |
| Day | Topics |
|---|---|
| Day 31 | PostgreSQL-specific Features |
| Day 32 | MySQL-specific Features |
| Day 33 | Window Functions |
| Day 34 | SQL Interview Questions |
| Day 35 | SQL for Data Analytics |
sql-notes-and-practice/
├── day1/
│ ├── README.md # Concepts summary
│ ├── data.sql # Table schema + practice questions
│ └── queries.sql # Solutions with comments
├── day2/
│ └── ...
├── CONTRIBUTING.md
└── LICENSE
Each day includes:
- 📖
README.md: Summary of concepts - 🧱
data.sql: Table definitions + sample data - 🧠
queries.sql: Practice SQL queries with inline comments
- Database: MySQL
- Environment: MySQL Workbench
- Language: SQL
- Platform: GitHub
- 📚 30-Day Learning Roadmap (From Basics to Advanced)
- 🧪 Real-life Practice Projects (HR, E-commerce, Library, etc.)
- 📈 Ideal for Interviews and SQL Skill-Building
- 🎓 Learn-by-doing approach with examples and explanations
- 💡 Bonus Modules & Daily Practice
- Clone the repo
git clone https://github.com/Thogaruchesti-hemanth/sql-notes-and-practice.git- Open MySQL Workbench
- Choose a folder (e.g.,
day5) and rundata.sqlfollowed byqueries.sql - Read the
README.mdfor each day's explanation and concepts - Modify, experiment, and take notes!
Contributions are welcome! Please read the CONTRIBUTING.md file for guidelines before submitting a PR.
If this project helped you:
- ⭐ Star the repo
- 🍴 Fork and customize it
- 🔗 Share with friends and communities
- 🧵 Mention on social platforms using
#30DaysOfSQL
Let’s grow and learn together! 🙌
Hi, I’m Sai Hemanth Thogaruchesti, a passionate Android & Flutter developer, tech enthusiast, and open-source contributor from 🇮🇳 India.
- 💼 LinkedIn: thogaruchesti-hemanth
Let’s connect, collaborate, and build together! 🚀
This project is licensed under the MIT License.
📈 Learn SQL. Build Projects. Grow Your Profile. 🏆 Helping Developers & Data Enthusiasts Shine on GitHub.