0101 - Course Introduction and Prerequisites

ETL and ELT Basics

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.

0102 - ETL or ELT It’s All When You Transform

ETL and ELT Basics

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.

0201 - Data Formats and Sources

ETL and ELT Basics

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.

0202 - Storage Requirements

ETL and ELT Basics

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.

0203 - Data Validation

ETL and ELT Basics

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.

0301 - Data Cleansing

ETL and ELT Basics

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.

0302 - Batch Data Transformation

ETL and ELT Basics

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.

0303 - Interactive Data Transformation

ETL and ELT Basics

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.

0304 - Transformational Languages

ETL and ELT Basics

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.

0401 - Loading Data into the End Target

ETL and ELT Basics

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.

0402 - Audit Trails

ETL and ELT Basics

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.

0501 - Bulk Loading

ETL and ELT Basics

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.

0502 - Parallel Processing

ETL and ELT Basics

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.

0601 - Dealing with Keys

ETL and ELT Basics

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.

0602 - Process Recoverability

ETL and ELT Basics

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.

0701 - Course Summary

ETL and ELT Basics

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.

0801. Exercise Files.zip

ETL and ELT Basics

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.