To demonstrate SQL proficiency by querying, and analyzing relational databases using real-world business scenarios and the Sakila sample database.
This project contains a comprehensive set of SQL queries and explanations covering constraints, joins, window functions, and advanced data analysis. Also includes a wide range of queries for data retrieval, aggregation, and reporting. The queries are written for Postgresql and MySQL are well-commented for learning and reference.
Please refer this sample DB: https://downloads.mysql.com/docs/sakila-db.zip
- Writing complex SELECT queries
- Joins (INNER, LEFT, advanced joins)
- Aggregation and grouping
- Window functions and CTEs (Common Table Expressions)
- Case conditions
- Data analysis and reporting
- SQL (Postgresql, Mysql)
- Sakila sample database
- Relational database concepts
- Extracted actionable business insights through complex joins, aggregations, and window functions.
- Implemented CTEs for modular and optimized analysis.
- Strengthened expertise in SQL analytics applicable to real-world database and reporting scenarios.