This project contains SQL queries used to explore and analyze a Netflix dataset. It is aimed at improving SQL skills and understanding data trends in Netflix's content library.
netflix_sql_project.sql: A set of SQL queries written to analyze the Netflix dataset. These queries help in answering questions like:- Total number of movies and TV shows
- Most common genres
- Countries with the most content
- Content trends over the years
- Content rating distribution
- SQL (PostgreSQL)
- pgAdmin 4
The main goal of this project is to practice data analysis using SQL by working on a real-world dataset.
- What is the total number of movies and TV shows on Netflix?
- Which country has produced the most content?
- What kind of content has Netflix added over time?
- Which genres are most common?
- How is content distributed across different ratings?
- Open pgAdmin 4 and connect to your PostgreSQL server.
- Import or create a table using the Netflix dataset.
- Open the
netflix_sql_project.sqlfile in pgAdmin's query tool. - Run the queries step-by-step to explore and analyze the dataset.
You can download the dataset from Kaggle - Netflix Movies and TV Shows