Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ Microsoft AZ-900
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Figure Drawing Canva
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Development Database Design & Development ETL

Automating ETL - Complete Code Challenges and ETL Projects

From beginner to advanced after challenges and projects. Free seminar access for lifetime students.
Rating: 3.5 out of 53.5 (49 ratings)
275 students
Created by Tim Smith
Last updated 2/2021
English
English [Auto]
30-Day Money-Back Guarantee

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

Course content

13 sections • 78 lectures • 16h 17m total length

  • Preview11:24
  • Preview02:47
  • The "Why" of ETL
    16:31
  • Terminology
    06:39

  • Extract Introduction
    04:19
  • Extract (Part One)
    18:05
  • Extract (Part Two)
    37:27
  • Extract (Part Three)
    13:34
  • Extract (Part Four)
    08:08
  • Extract (Part Five)
    02:57
  • Extract (Part Six)
    15:14
  • ETL Best Practices With APIs
    14:48
  • Extract (Closing Thoughts)
    03:21
  • SSIS & SQL Server Data Tools Overview
    13:57
  • SSIS Project: Aggregate Regional Weather Data
    07:37
  • Extract Code Challenge 1
    02:23
  • Extract Code Challenge 2
    02:05
  • Our Course Project (Extract Homework)
    09:36
  • 3 Additional Course Projects
    02:02

  • Load (Part One)
    20:34
  • Load (Part Two)
    14:31
  • Load (Part Three)
    26:54
  • Load Code Challenge 1
    02:12
  • Load Code Challenge 2
    02:09
  • Our Course Project (Load Homework)
    28:05

  • Transform (Part One)
    21:53
  • Transform (Part Two)
    16:40
  • Transform (Part Three)
    30:38
  • Transform: (Part Four)
    10:05
  • Transform (Part Five)
    20:03
  • Transform (Part Six)
    08:52
  • Our Course Project (Transform Homework)
    16:58
  • Transform Code Challenge 1
    01:49
  • Transform Code Challenge 2
    02:17
  • Our Course Project (Transform Homework Part II)
    11:58
  • Transform Coding Live Practice (Optional)
    21:57

  • ETL With Other Platforms Overview
    14:33
  • ETL With Other Platforms Part 1
    19:45
  • ETL With Other Platforms Part 2
    11:22
  • ETL With Other Platforms Part 3
    08:17
  • ETL With Other Platforms Part 4
    21:00
  • ETL With Other Platforms Part 5
    05:44
  • ETL With Other Platforms Part 6
    10:14
  • ETL With Other Platforms Part 7
    16:21

  • Performance Overview
    19:03
  • Performance Part 1
    15:40
  • Performance Part 2
    07:57

  • ETL In the Cloud Part 1
    16:01
  • ETL In the Cloud Part 2
    17:09
  • ETL In the Cloud Part 3
    14:47

  • ETL and Security Overview
    21:16
  • ETL and Security Part 1
    09:49

  • Good Deal Or Not? Practice
    27:30
  • Is This As Good As The Real Thing?
    09:29
  • Be Extremely Careful - Data Example
    09:36
  • What Do the Data Indicate About This Company?
    08:07
  • Transforming Data Example - Live Coding
    33:55

  • Preparing For the 30 Minute Practice Interview
    05:32

Requirements

  • Mandatory: Computer with Microsoft SQL Server Express (or above) 2008R2 (or above)
  • Mandatory: PowerShell ISE 3.0 (or above)
  • Optional: Visual Studio 2010 (or above)
  • Optional: MongoDB
  • Optional: SQL Server Data Tools (SSIS)

Description

This course covers a guide to automating ETL by reviewing each step and how this can be achieved.  This course is designed for anyone who works in the data field - from employees to C-suite executives. With the demand for ETL developers increasing (per the Bureau of Labor Statistics and the opportunity to become a data provider (for business owners), 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. 

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.

  • Completing code challenges in each of the ETL steps to help you learn as you do.

  • Reviewing case studies of applied ETL techniques, especially useful for freelancers adding credibility to their business.

  • Optional course tools of your choice: SQL Server, SSIS, PowerShell, MongoDB, Apache Spark.

To provide maximum learning for students wanting to master ETL skills, whether for business opportunity or employment, the course provides the following material: 

  • New content posted every year since this course began which offer students a look into the new challenges faced by ETL developers.

  • Q&A responses within 48 hours for students who need assistance along with ongoing discussions that students may find helpful.

  • Tri-annual bonus material for long-term and successful students in this course based on several metrics provided by Udemy.  Technology always changes which is why this course continues to be updated and built with rewards for long time students.

  • 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.

  • 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.

  • Course projects that you complete as well as your own project to develop.

  • Feedback session for students who meet the requirements where you practice answering questions and presenting your own project.

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. 

Who this course is for:

  • Businesses requiring ETL developers
  • Students interested in ETL positions
  • Employees working in ETL positions
  • Employees interested in ETL positions
  • Individual business owners who want to perform ETL on their own
  • Employers needing ETL developers
  • Recruiters wanting to understand ETL positions

Instructor

Tim Smith
Data Architect
Tim Smith
  • 3.5 Instructor Rating
  • 49 Reviews
  • 275 Students
  • 1 Course

I work as a data architect and engineer for FinTek Development.  In addition, I have been published in tech magazines hundreds of times and produce technical video how-to content, one of which is my YouTube channel SQL In Six Minutes.

In the decade I've worked in tech, the largest opportunities I've seen involve how firms work with and use their data.  From hospitals to businesses to colleges, few organizations understand and use their data effectively.  In the same manner, each year brings new challenges which is why my courses are constantly updated with fresh material to benefit long term students.

I am a proponent of the learn-by-doing methodology.  Throughout my courses, students are encouraged to complete code challenges to practice what they're learning. I've interviewed many people who could explain theory, but could not complete basic assignments.  This type of teaching helps students master learning through application.  In addition, my course offers an optional interview to help students get feedback on how to present themselves and their skills to others.

Finally, I've been working with technology since high school where I won awards for development and was the top student in technology, science, mathematics and Spanish.  In college, I graduated in the top 1% of my class in information technology.  Since I've been working with technology, I have been quick to adopt new platforms and teach them from MongoDB to blockchain to other newer platforms.

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.