This course covers a guide to automating ETL through automation techniques, intended for business owners, freelancers or employees seeking to jump ahead of the competition and seeking to minimize data disasters. With the demand for ETL developers increasing (per the Bureau of Labor Statistics and the opportunity to become a data provider (for business owners or freelancers), I highlight methods and architecture to minimize the work that must be done for ETL, so that you can spend more time working on enhancing skills.
I offer a ton of free content on my YouTube channel, and suggest students to become familiar with the basics of SQL Server and MongoDB, covered at the below, free playlists:
- SQL In Six Minutes (YouTube)
- The MongoDB 103 (YouTube)
This course covers:
- Understanding the extract process and constructing architecture to automate it.
- Understanding the load process, when change is necessary with loading, and how to automate it.
- Understanding different issues we may face in transform, how to minimize re-facing them with re-usable solutions.
- Understanding advanced techniques in ETL, the theory behind these, and applications with them.
- Understanding the basic logic, functions, operators and advanced use of PowerShell so beginners and mid-level developers can advance quickly with it.
- Completing a large assignment that will have you import over 200K of records.
- Reviewing case studies of applied ETL techniques, especially useful for freelancers adding credibility to their business.
To provide maximum learning for students wanting to master ETL skills, whether for business opportunity or employment, the course provides the following types of material:
- Focused video lectures with demonstrations of ETL processes in action, the code/script used to make the process occur, and no distracting facial or background movements.
- Mp3s recorded independently from the video covering similar and also new content because students are unable to "see what's happening" - additional learning material.
- Dynamic syllabus with extra content, such as links to articles and videos to enhance and increase your learning, as well as links to specific recruiters in desperate need for ETL developers (students wanting to become employees) and ways to uncover possible data providing opportunities for business owners.
- Scripts/code that are used in the video lectures, as well as additional tools that students can learn as they construct their own ETL architecture.
- Course material that we use in the course, such as files we import during the series.
Understanding, manipulating and transforming data will only become more important in the future. Those who can master this through automation will have an advantage over all their competition because when we see the results of our measurement, only then can we make the appropriate changes; this course shows you how to automate those steps.