In this project we will focus on Extract, Transform and Load (ETL) process by using Python on Visual Studio Code. Using Python over VS code as the main tool to build your very own ETL process from courses and ratings dataset over SQLite3 and copy the data into created database, extract specific records, transform them and finally load them onto a new database.
-
Design and build a database
-
Apply the ETL process to the database using SQLite3 over Python
-
Visualize and query the database for specific records