Skip to content

SQL practice projects built on the Sakila sample database, focusing on real-world querying, data analysis, and database concepts like joins, grouping, subqueries, and filtering

Notifications You must be signed in to change notification settings

datascientistshorya/sakila

Repository files navigation

📊 SQL Practice with Sakila Database 📌 Overview

This repository documents my SQL practice using the Sakila sample database, a popular MySQL database designed to simulate a DVD rental store.

The goal of this project is to strengthen core SQL skills through hands-on querying and real-world data analysis scenarios.

🎯 Objectives

Build strong SQL fundamentals

Practice real-world data querying

Improve analytical thinking using databases

Prepare for data analyst and data science roles

🧠 Topics Covered

This repository includes queries and exercises on:

SELECT statements

Filtering (WHERE, BETWEEN, LIKE, IN)

Sorting (ORDER BY)

Aggregations (COUNT, SUM, AVG, GROUP BY, HAVING)

Joins (INNER JOIN, LEFT JOIN, RIGHT JOIN)

Subqueries

Data exploration and analysis

Basic database insights from relational data

🛠 Tools Used

MySQL

Sakila Sample Database

SQL (Structured Query Language)

📂 Repository Structure

SQL query files organized by topic

Practice exercises and solutions

Analytical queries for insights

🚀 Learning Approach

This is a learning-focused repository where I practice SQL concepts by solving queries on a structured relational database.

I believe in learning by doing and consistently improving through practice.

📈 Future Improvements

Advanced SQL queries

Window functions

Stored procedures

Performance optimization queries

🤝 Connect

If you’re also learning SQL or data analytics, feel free to connect or share feedback! in/shorya-bisht-a20144349

About

SQL practice projects built on the Sakila sample database, focusing on real-world querying, data analysis, and database concepts like joins, grouping, subqueries, and filtering

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published