ETL & ELT

About this course

Design data movement and transformation workflows with incremental loading, change capture, deduplication and testing.

This practitioner course is part of the Data Engineering & Platforms school. Work through the curriculum below in a self-paced / instructor-led format, with an estimated study time of 16 h.

Course curriculum

• Module 1 — Extraction Patterns
• Module 2 — Staging
• Module 3 — Transformations in SQL and Python
• Module 4 — Incremental Loads and Watermarks
• Module 5 — Change Data Capture
• Module 6 — Idempotency and Deduplication
• Module 7 — Schema Evolution
• Module 8 — Testing Transformations

Applied learning

• Case Study — The Pipeline That Never Failed
• Lab 1 — A first pipeline, from API and database to a sales mart
• Lab 2 — Incremental orders and a customer history
• Lab 3 — A tested, rerunnable delivery pipeline for October
• Capstone — A Production-Ready Load

Who this course is for

Data Professional; Engineer / Architect

Prerequisites

NE-DE-102

Course details

• Course code: NE-DE-201
• Level: Practitioner
• Estimated duration: 16 h
• Delivery: Self-Paced / Instructor-Led