Skip to content

sagar-shende/MySQL-Sakila-Dataset-Practice

Repository files navigation

🗄️ MySQL Sakila Dataset Practice

MySQL Status License

📌 Project Overview

Practice SQL queries on the Sakila sample database using MySQL.
Covers fundamental to advanced SQL concepts.


📚 Topics Covered

  • ✅ SELECT Statement
  • ✅ WHERE Clause
  • ✅ ORDER BY Clause
  • ✅ GROUP BY Clause
  • ✅ HAVING Clause
  • ✅ LIMIT Clause
  • ✅ JOINs (INNER, LEFT, RIGHT)
  • ✅ Subqueries & Correlated Subqueries
  • ✅ CTEs (Common Table Expressions)

🛠️ Tools Used

  • Database: MySQL 8.0
  • IDE: MySQL Workbench
  • Dataset: Sakila Sample Database (Built-in MySQL)

👤 Author

Sagar Shende
GitHub

About

MySQL Sakila Dataset Practice | SELECT, WHERE, ORDER BY, GROUP BY, HAVING, LIMIT, JOINs, Subqueries & CTEs | MySQL Workbench

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors