Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
16 Hour(s) 56 Minute(s)
Language
English
Taught by
Tim Smith
Rating
1 views
Course Overview
A few code challenges and projects for learning ETL
Note that this course is no longer actively updated as of 2024 as far as the specific curriculum content. If you are looking for the latest in ETL/ELT development, you can reach out directly. In addition, as of late 2025 the data industry (including ETL) is facing a significant reduction in demand. This course pricing has been adjusted to dissuade new students for late 2025 until the industry improves.
Existing students in Automating ETL: In February 2026, I sent emailed announcements to existing students who had completed at least 1% of the course with a written version of Automating ETL featuring development with Python and Sqlite3. You can find this these announcements under the "Announcement" tab when you enter the course (the "Announcements" tab is between "Notes" and "Reviews"). This written update includes 2 projects and I expect the full email update to be completed by the end of 2026, so these emails will be sent out through 2026.
This course covers a beginner's guide to automating ETL by breaking down each step and reviewing how this can be achieved. I've designed this course for anyone who's starting in extract, transform and load (ETL). You will learn by creating ETL projects. In addition, if you are learning ETL because you are managing a team or creating a business around data, this course helps you understand what may be required and how you will find talent.
This course covers:
Defining and understanding the extract process and constructing architecture to automate it.
Defining and understanding the load process, when change is necessary with loading, and how to automate it.
Defining and understanding different issues we may face in transform, how to minimize re-facing them with re-usable solutions.
Defining and understanding advanced techniques in ETL, the theory behind these, and applications with them.
Completing code challenges in each of the ETL steps to help you learn as you do.
Some examples in practice of where ETL was used in a business problem and how the business problem was solved with ETL supporting the decisions.
Note that this course uses tools such as PowerShell and SQL Server while making mention of other tools such as MongoDB and Spark.
Course Content
- 11 section(s)
- 78 lecture(s)
- Section 1 Introduction
- Section 2 Automating ETL Processes - Extract
- Section 3 Automating ETL Processes - Load
- Section 4 Automating ETL Processes - Transform
- Section 5 ETL With Other Platforms
- Section 6 ETL and Performance
- Section 7 ETL In the Cloud
- Section 8 ETL and Cybersecurity
- Section 9 Live Practice and Examples
- Section 10 Congratulations
- Section 11 Archived Section - From 2013 to 2017 (Some Exercises May Be Helpful Still)
What You’ll Learn
- Introduce ETL effectively, Learn and understand extract, Learn and understand transform, Learn and understand load, Learn the theory behind automation, Learn how to automate the ETL process, Learn advanced techniques in extract, transform and load, See case studies with applied ETL uses for freelancers or business owners
Skills covered in this course
Reviews
-
ssayed Hoque
Combination of SSIS and powershell scripting with out any project Didn't quite understand where I was heading to!!
-
SSamuel Mochu
The material Tim is covering is what I need RIGHT NOW to get familiar with ETL
-
EErnesto Pantoja
Besides the fact that the instructor is an expert in the field. This Course for me it is inspirational. Now more than ever I want to develop the skills as an ETL developer.
-
JJosé Elshuis
For me, the focus of the course was too much on Powershell scripting around more or less the same challenge. I would have liked a broader view on ETL and it's purposes.
