Extract, Transform & Load using Python

Offered By
Coursera Project Network
In this Guided Project, you will:

Design and build a database

Apply the ETL process to the database using SQLite3 over Python

Visualize and query the database for specific records

Clock2 hours
BeginnerBeginner
CloudNo download needed
VideoSplit-screen video
Comment DotsEnglish
LaptopDesktop only

By the end of this project, you will create your own Extract, Transform and Load (ETL) process by using Python on Visual Studio Code During the course of this project, you will be using Python over VS code as the main tool to build your very own ETL process from courses and ratings dataset over SQLite3. The learner will copy the data into his own created database, extract specific records, transform them and finally load them onto a new database. ETL process is viewed as the core of any application, as any further step that requires dealing with the data stored such as: data Analytics, data processing or applying any sort of Machine Learning algorithms will inevitably point out to the start point, which is the ETL process. This guided project is for people who are aiming to start their career in the broad field of Data Engineering and the specific field of Data Management. It will also be of interest for people who are keen on enhancing their programming skills using Python. Note: This course works best for learners who are based in the North America region. We’re currently working on providing the same experience in other regions.

Skills you will develop

Extraction, Transformation And Loading (ETL)Python ProgrammingDatabase ConnectionDatabase Management Systems

Learn step-by-step

In a video that plays in a split-screen with your work area, your instructor will walk you through these steps:

  1. By the end of Task 1,you will be able to identify and import the needed libraries.

  2. By the end of Task 2, you will be able to create connection with the database and handle potential errors.

  3. By the end of Task 3, you will be able to create tables and store them in the database.

  4. By the end of Task 4, you will be able to insert data into tables previously created.

  5. By the end of Task 5, you will be able to extract and transform data.

  6. By the end of Task 6, you will be able to load, visualize data in the database and apply basic queries.

How Guided Projects work

Your workspace is a cloud desktop right in your browser, no download required

In a split-screen video, your instructor guides you step-by-step

Frequently asked questions

Frequently Asked Questions

More questions? Visit the Learner Help Center.