Skip to content

Gana797/netflix_sql_proj

Folders and files

NameName
Last commit message
Last commit date

Latest commit

Β 

History

6 Commits
Β 
Β 
Β 
Β 
Β 
Β 

Repository files navigation

🎬 Netflix SQL Data Analysis Project

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.

πŸ“ What's in the File?

  • 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

πŸ›  Tools Used

  • SQL (PostgreSQL)
  • pgAdmin 4

πŸ“Œ Purpose

The main goal of this project is to practice data analysis using SQL by working on a real-world dataset.

πŸ“Š Sample Questions Answered

  • 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?

βœ… How to Use

  1. Open pgAdmin 4 and connect to your PostgreSQL server.
  2. Import or create a table using the Netflix dataset.
  3. Open the netflix_sql_project.sql file in pgAdmin's query tool.
  4. Run the queries step-by-step to explore and analyze the dataset.

πŸ“š Dataset Source

You can download the dataset from Kaggle - Netflix Movies and TV Shows

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

 
 
 

Contributors