This repository contains SQL queries, practice problems, and case studies organized by difficulty level — designed to strengthen database concepts and prepare for interviews.
Beginner-level SQL topics to build a strong foundation.
- SELECT, INSERT, UPDATE, DELETE
- Filtering with WHERE and ORDER BY
- GROUP BY and HAVING
- Aggregate Functions (COUNT, SUM, AVG, etc.)
Intermediate-level practice focusing on combining multiple tables.
- INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN
- SELF JOIN and CROSS JOIN
- Practice questions for relational data handling
Common SQL interview questions collected from real company assessments.
- Query-based problem-solving
- Real-world scenarios using subqueries and CTEs
- Optimization and performance-based questions
Challenging SQL concepts and problems for advanced learners.
- Window Functions
- CTEs (Common Table Expressions)
- Triggers, Views, and Stored Procedures
- Complex nested subqueries
Practical, real-world database problems.
- Company/Employee Database Design
- Sales & Customer Analytics
- End-to-end case studies combining multiple SQL concepts
To provide a step-by-step SQL learning journey, from basic syntax to real-world analytical queries.
- Database: Oracle / MySQL
- Language: SQL
👩💻 Vidya Trimbake
📍 Mumbai, India
📧 vidyatrimbake3@gmail.com
💼 LinkedIn | 🐙 GitHub
⭐ If you find this helpful, consider giving it a star!