ETL in Python and SQL

Focused View

Jennifer Ebe

1:20:38

8 View

01 - Introduction

01 - Create an ETL in Python and SQL.mp4

00:43

02 - Tools used in this course.mp4

01:18

02 - 1. What Are ETLs

01 - What are ETLs and how do you create them.mp4

03:58

02 - ETL process overview.mp4

04:02

03 - Exploring your data with pandas (Python) and SQL.mp4

03:22

04 - Understanding your data.mp4

03:58

05 - Challenge Reading data using Python.mp4

00:35

06 - Solution Reading data using Python.mp4

03:06

03 - 2. Extracting and Transforming Data with Python

01 - Loading data from different sources.mp4

04:01

02 - Extracting your data.mp4

02:15

03 - Cleaning, preprocessing data, and data formatting.mp4

03:52

04 - Standardization, handling duplicates, and missing values.mp4

06:01

05 - Challenge Load the data using SQLAlchemy and pandas.mp4

00:34

06 - Solution Load the data using SQLAlchemy and pandas.mp4

03:47

04 - 3. Loading Data into Target Systems

01 - Introduction to data warehouses and data lakes.mp4

05:01

02 - Loading data into relational databases.mp4

08:01

03 - Data quality checks and validation with SQL.mp4

03:27

04 - Challenge Transform the data and remove duplicates and nulls.mp4

00:40

05 - Solution Transform the data and remove duplicates and nulls.mp4

02:37

05 - 4. Automating ETL Jobs Scheduling ETL Jobs with Python

01 - Querying your data with SQL.mp4

04:21

02 - Scheduling ETL jobs with Airflow Part 1.mp4

05:10

03 - Scheduling ETL jobs with Airflow Part 2.mp4

04:58

04 - Challenge Load the data into a database and automate.mp4

00:43

05 - Solution Load the data into a database and automate.mp4

02:54

06 - Conclusion

01 - Expand your knowledge of ETLs.mp4

01:14

Description

Data is increasing exponentially as the world continues to generate an immense amount. In this course, a data engineer with over 5 years of experience, Jennifer Ebe, will show you how to build systems that gather data from various sources, transform it and store data so you can derive insights from it effectively. We will go over what ETLs are and how you create them. We will learn how to use Python to extract and transform data, we will explore our data using pandas and SQL. And finally, load data into our target system. You will also get practice scheduling ETL jobs using Python. Each chapter comes with helpful, hands-on challenges to help you practice what you learn.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL Server

Microsoft SQL

Jennifer Ebe

Instructor's Courses

Linkedin Learning

View courses Linkedin Learning

LinkedIn Learning is an American online learning provider. It provides video courses taught by industry experts in software, creative, and business skills. It is a subsidiary of LinkedIn. All the courses on LinkedIn fall into four categories: Business, Creative, Technology and Certifications. It was founded in 1995 by Lynda Weinman as Lynda.com before being acquired by LinkedIn in 2015. Microsoft acquired LinkedIn in December 2016.