Note that the Udemy version for Automating ETL 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, the course Introduction To Data includes the latest in ETL/ELT. The Udemy course pricing has been adjusted to dissuade new students from enrolling. Existing students in the Udemy version will continue to get announcements from the instructor as long as Udemy continues to allow announcements.
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.
Udemy version (no new curriculum updates): Old Automating ETL Course
Gumroad version: Introduction To Data (not available until later). This course includes:
The top 5 data principles
Automating ETL/ELT
Introduction to research
Research post AI
A required data project presentation to the instructor with a feedback session
Individual feedback session
The expected release of the Introduction To Data is February 2028. I will note here if this timeframe changes.
All written content is copyright, all rights reserved. None of the content may be shared with any artificial intelligence application. Note that the full context of the above article may not be clear to readers, nor may it apply to the reader's situation.
Automating ETL
Because some educational platforms change rules after the fact and prevent instructors from sending updates to students, I will note announcements here if one (or more) of these platforms does this in the future.
2026. For students in the Udemy version of Automating ETL: in February 2026, if you had completed at least 1% of the course and were still subscribed to course updates, you should have started to see announcements through (anticipated) November 2026. Unfortunately, under Announcements, these emails were not ordered from when they were sent, but when they were updated. However, this teaches some principles using different technologies than the original version of the course.
2027. 1 annual educational message planned before December 31st.
2028. 3 annual educational messages planned before December 31st.
Note that on the SqlinSix All Snips page, I sometimes note when I've added updates to the latest version of the course
All written content is copyright, all rights reserved. None of the content may be shared with any artificial intelligence application. Note that the full context of the above article may not be clear to readers, nor may it apply to the reader's situation.
Announcements
Some helpful public resources for students.
Automating ETL public troubleshooting playlist. I created this playlist from various issues that students (or people) would sometimes face when using some of the tools and approaches taught. I created this hear to avoid too much content in the course so that students could focus on learning and if they faced issues, use this playlist as a guide.
SQL Basics playlist. Helpful playlist for students wanting to become familiar with some of the basics in SQL. Shortcut page for the most common join types solved in SQL, Pandas and Python.
The Security Page. I maintain a page with some information and links related to security. In any technical solution, you should consider security. This page is updated annually.
Convenient grouping in databricks https://x.com/sqlinsix/status/1769689183147200609).
Object meta information - 2 options: https://x.com/sqlinsix/status/1774756248736391425.
Cloning objects: https://x.com/sqlinsix/status/1780906573478449180.
Vacuum testing before actually vacuuming: https://x.com/sqlinsix/status/1795386061990035531.
Architectural considerations with data warehouse logic: https://x.com/sqlinsix/status/1820415360593547678.
Broadcast over shuffle: https://x.com/sqlinsix/status/1825479846039785833.
Shuffle over broadcast: https://x.com/sqlinsix/status/1855961754401952157.
All written content is copyright, all rights reserved. None of the content may be shared with any artificial intelligence application. Note that the full context of the above article may not be clear to readers, nor may it apply to the reader's situation.
Resources
© 2004 - 2027 SqlinSix. All Rights Reserved. None of the written content may be shared with any artificial intelligence application.