🎬 Netflix SQL Analysis

A portfolio project that explores the Netflix Movies and TV Shows dataset using PostgreSQL to answer real-world business questions.

---

📌 Project Overview

This project analyzes the Netflix dataset using SQL to extract meaningful business insights. It covers data exploration, filtering, aggregation, string manipulation, window functions, regular expressions, and common business-oriented queries.

The project was developed using PostgreSQL and DataGrip.

---

🛠️ Technologies Used

• PostgreSQL
• SQL
• DataGrip
• Git
• GitHub

---

📂 Project Structure

Netflix-SQL-Analysis/
│
├── dataset/
│   └── netflix_titles.csv
│
├── sql/
│   └── netflix_analysis.sql
│
├── images/
│   ├── longest-movie.png
│   ├── actors-in-movies.png
│   ├── content-added.png
│   └── ...
│
└── README.md

---

📊 SQL Skills Demonstrated

• Data Exploration
• Data Filtering
• Aggregate Functions
• GROUP BY &
• CASE Statements
• Common Table Expressions (CTEs) & Subqueries
• Window Functions
• String Functions
• Date Functions
• Regular Expressions
• Business Data Analysis

---

📈 Business Questions Solved

• Count the number of Movies and TV Shows.
• Find the most common rating for Movies and TV Shows.
• List all Movies released in 2008.
• Find the top 5 countries with the most content.
• Identify the longest movie.
• Find content added in the last 5 years.
• Find Movies directed by specific directors.
• Find TV Shows with more than 5 seasons.
• Count the number of content items in each genre.
• Find the top 10 actors appearing in Movies.
• Identify content without a director.
• Categorize content based on keywords in the description.

---

📷 Query Results

Sample outputs of the SQL queries are available in the images/ folder.

---

▶️ How to Run

1. Clone this repository.
2. Create a PostgreSQL database.
3. Import the netflix_titles.csv dataset into PostgreSQL using DataGrip.
4. Execute the queries in sql/netflix_analysis.sql.
5. Review the query results.

---

🎯 Learning Outcomes

Through this project, I practiced:

• Writing efficient SQL queries.
• Solving business-oriented analytical problems.
• Using PostgreSQL advanced SQL features.
• Organizing a SQL portfolio project with GitHub.

---

📄 Dataset

Netflix Movies and TV Shows Dataset from Kaggle.

---

👤 Author

Ayman ECH-TAIBABI

GitHub: https://github.com/ech-ayman