📊 Day 16 - Data Download

Netflix Movies Analytics Platform

Download all 5 tables with complete messy data

Window Functions RANK & PARTITION BY Complex JOINs CTEs Percentiles

Table 1: movies (50 rows)

Click download button to get CSV file with all 50 movies

Table 2: genres (100 rows)

Click download button to get CSV file with all 100 genre assignments

Table 3: actors (50 rows)

Click download button to get CSV file with all 50 actors

Table 4: movie_cast (80 rows)

Click download button to get CSV file with all 80 casting records

Table 5: user_ratings (100 rows)

Click download button to get CSV file with all 100 user ratings

📌 How to Import into MySQL/PostgreSQL

MySQL:

1. Create database: CREATE DATABASE netflix_analytics;

2. Import CSV: LOAD DATA INFILE 'path/movies.csv' INTO TABLE movies FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ROWS;

PostgreSQL:

1. Create database: CREATE DATABASE netflix_analytics;

2. Import CSV: \COPY movies FROM 'path/movies.csv' WITH (FORMAT csv, HEADER true);

Note: Create tables first with appropriate column types before importing!

← Back to Challenge