A collection of MySQL practice questions and SQL query solutions covering core SQL concepts, database design, and advanced MySQL features using the ClassicModels database and custom-created tables.
- SELECT statements
- WHERE, AND conditions
- DISTINCT
- LIKE wildcard operations
- CASE statements
- Customer segmentation queries
- GROUP BY
- HAVING clause
- SUM(), COUNT()
- Sorting and limiting results
- YEAR()
- MONTHNAME()
- Monthly analysis queries
- PRIMARY KEY
- FOREIGN KEY
- UNIQUE
- CHECK
- NOT NULL
- AUTO_INCREMENT
- INNER JOIN
- SELF JOIN
- CREATE TABLE
- ALTER TABLE
- MODIFY COLUMN
- Views
- Stored Procedures
- Window Functions
- Subqueries
- Triggers
- Exception Handling
- ClassicModels Sample Database
- Custom databases and tables created for assignments
- Employees working as Sales Representatives
- Product line filtering using LIKE
- Customer segmentation by region
- Top ordered products
- Monthly payment frequency analysis
- Customer and Orders table creation with constraints
- Top countries by order count
- Employee-manager relationship mapping
- Table creation and alteration
- Product category sales analytics
- Country-wise payment analysis
- Customer order ranking
- Year-over-Year order analysis
- Product line price comparison analysis
- Exception handling using stored procedures
- BEFORE INSERT trigger validation
- Relational Database Design
- SQL Query Optimization
- Analytical Query Writing
- Data Aggregation
- MySQL Programming
- Database Constraints & Integrity
- Advanced SQL Features