Automating ETL - Complete Code Challenges and ETL Projects

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 and beyond until the industry improves.

Existing students in Automating ETL: Starting 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 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. Additionally, I may continue adding some curriculum or sending one Announcement relevant to data that you'll want to read at a minimum of one per year.

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.