ETL in Python

Course Cover

5

(3)

compare button icon

Course Features

icon

Duration

4 hours

icon

Delivery Method

Online

icon

Available on

Limited Access

icon

Accessibility

Desktop, Laptop

icon

Language

English

icon

Subtitles

English

icon

Level

Intermediate

icon

Teaching Type

Self Paced

icon

Video Content

4 hours

Course Description

You want to improve your data engineering skills and process big data more efficiently? It's time for you to improve your ETL skills. This course will teach you how to create pipelines that efficiently extract, transform, load, and load data into your company's systems. This course will give you hands-on experience as you help a fictional private equity company process the sales data it needs to make informed business decisions regarding real estate purchases. Learn how to build ETL pipelines and gain one of the most sought-after engineering skills in the market.

Course Overview

projects-img

Virtual Labs

projects-img

International Faculty

projects-img

Post Course Interactions

projects-img

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

Prerequisites/Requirements

Data Engineering for Everyone

Introduction to Data Engineering

Python Data Science Toolbox (Part 2)

What You Will Learn

You’ll be introduced to your role as a data engineer in a private equity fund

You'll be exposed to the whole etl pipeline before deep-diving into its first phase: the extraction process

You'll start setting up the components needed to communicate with the databaseyou'll explore how to create a unique key to perform insert and delete statements on sqlalchemy

At the end of this chapter you'll complete the load process, the last step of the etl pipeline

You'll explore key sql components to build more complex queries and create these insights

You'll also explore libraries that will translate raw sql queries into more readable excel files

Course Instructors

Author Image

Stefano Francavilla

Stefano is the CEO and co-founder of Geowox.

Stefano is the CEO and co-founder of Geowox, a company using AI and big data to value residential properties. In a previous life, he studied Computer Science at the polytechnic university of Milan wh...

Course Reviews

Average Rating Based on 3 reviews

5.0

100%

Course Cover