ETL and ELT Basics

By David Thomas

This course will discuss the steps required for each step in the ETL process and look at different solutions for some real-world scenarios.

1 hour
  • 25 Lessons
  • 9 Hands-On Labs

About the course

ETL or Extract Transform Load, is the process of gathering data to a central data warehouse for analytics. This course will discuss the steps required for each step in the ETL process and look at different solutions for some real-world scenarios. We will explore extracting data from multiple sources and formats, performing transformations on the data, and finally loading the data into the final location.
This course does assume some experience with relational databases, as well as standard Unix command line tools such as sed, grep and awk.

  • Chapter 1 2 Lessons Introduction 3:32

    Course Introduction and Prerequisites

    1:38

    ETL or ELT? It’s All When You Transform

    1:54
  • Chapter 2 6 Lessons Extracting Data 7:59

    Data Formats and Sources

    3:06

    Storage Requirements

    2:27

    Data Validation

    2:26

    Convert this dataset.

    0:00 Hands-On Lab

    Validate this dataset.

    0:00 Hands-On Lab

    Extract this data.

    0:00 Hands-On Lab
  • Chapter 3 7 Lessons Transforming Data 10:23

    Data Cleansing

    4:59

    Batch Data Transformation

    1:25

    Interactive Data Transformation

    1:11

    Transformational Languages

    2:48

    Cleanse this data.

    0:00 Hands-On Lab

    Transform this data.

    0:00 Hands-On Lab

    Query This XML File on Linux

    0:00 Hands-On Lab
  • Chapter 4 4 Lessons Loading Data 7:37

    Loading Data into the End Target

    1:32

    Audit Trails

    6:05

    Loading Data into a Redshift Cluster

    0:00 Hands-On Lab

    Enable Audit logging on this PostgreSQL instance.

    0:00 Hands-On Lab
  • Chapter 5 3 Lessons Process Performance 5:16

    Bulk Loading

    3:25

    Parallel Processing

    1:51

    Bulk loading of data into PostgreSQL using the COPY command

    0:00 Hands-On Lab
  • Chapter 6 2 Lessons Process Challenges 4:58

    Dealing with Keys

    2:52

    Process Recoverability

    2:06
  • Chapter 7 1 Lesson Conclusion 1:23

    Course Summary

    1:23

What are Hands-on Labs

What's the difference between theoretical knowledge and real skills? Practical real-world experience. That's where Hands-on Labs come in! Hands-on Labs are guided, interactive experiences that help you learn and practice real-world scenarios in real cloud environments. Hands-on Labs are seamlessly integrated in courses, so you can learn by doing.

Practice alongside courses in Cloud Playground

What is Cloud Playground? Cloud Playground lets you build skills in real-world AWS, Google Cloud, and Azure environments. Spin up risk-free Sandboxes, Servers and Terminals and follow along with courses, test a new idea or prepare for exams.

Get Started
Who’s going to be learning?

How many seats do you need?

  • $499 USD per seat per year
  • Billed Annually
  • Renews in 12 months

Ready to accelerate learning?

For over 25 licenses, a member of our sales team will walk you through a custom tailored solution for your business.


$2,495.00

Checkout
Sign In
Welcome Back!

Psst…this one if you’ve been moved to ACG!