Extract, Transform & Load using Python
Design and build a database
Apply the ETL process to the database using SQLite3 over Python
Visualize and query the database for specific records
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
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:
By the end of Task 1,you will be able to identify and import the needed libraries.
By the end of Task 2, you will be able to create connection with the database and handle potential errors.
By the end of Task 3, you will be able to create tables and store them in the database.
By the end of Task 4, you will be able to insert data into tables previously created.
By the end of Task 5, you will be able to extract and transform data.
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
What will I get if I purchase a Guided Project?
Are Guided Projects available on desktop and mobile?
Who are the instructors for Guided Projects?
Can I download the work from my Guided Project after I complete it?
What is the refund policy?
Is financial aid available?
Can I audit a Guided Project and watch the video portion for free?
How much experience do I need to do this Guided Project?
Can I complete this Guided Project right through my web browser, instead of installing special software?
What is the learning experience like with Guided Projects?
More questions? Visit the Learner Help Center.
Coursera Footer
