YouTube Data ETL Project

Project Description

This project aims to extract data from the YouTube API using Python, load it into a PostgreSQL database.

Technologies Used

• Python
• PostgreSQL

Project Objectives

1. Extract data from the YouTube API using Python.
2. Load the extracted data into a PostgreSQL database for further analysis.
3. Create SQL views to analyze relevant channels and videos.
4. Perform SQL queries to answer specific questions using the stored data.

Project Structure

The project will be structured as follows:

• Python Code: This will contain the scripts used to extract data from the YouTube API and load it into the PostgreSQL database.
• SQL Scripts: This will include the scripts used to create views and perform queries for data analysis.