Ripotek Technologies Inc.
Design. Engineer. Deliver.
Calgary, Alberta
www.ripotek.com
training@ripotek.com
Azure Data Factory Masterclass
Professional Training Program Syllabus
Program Overview
12 Weeks (2 sessions per week)
24 total sessions, 72 instructional hours
CAD $1,000
Flexible payment plans available
Tuesday/Thursday
6:00 PM - 9:00 PM Mountain Time
Intermediate
Azure and SQL knowledge required
Program Description
Deep dive into Azure Data Factory for building enterprise-grade data integration pipelines. This intensive masterclass covers advanced ADF patterns, complex orchestration, error handling, performance optimization, and DevOps practices.
Master metadata-driven frameworks, incremental loading, monitoring, and production deployment strategies. Build real-world pipelines that handle millions of records efficiently and reliably.
Prerequisites
Required:
- Azure fundamentals knowledge
- SQL proficiency
- Understanding of ETL/ELT concepts
- Basic ADF experience
Recommended:
- Data warehouse experience
- JSON and ARM templates
- Git basics
- Azure DevOps familiarity
Learning Outcomes
Upon completion, you will be able to:
12-Week Curriculum
Week 1: ADF Architecture Deep Dive
- Components review
- Integration runtimes
- Linked services patterns
- Security best practices
Week 2: Advanced Copy Activities
- Complex mappings
- Data type conversions
- Performance tuning
- Parallel processing
Week 3: Orchestration Patterns
- Control flow mastery
- Dynamic pipelines
- Conditional logic
- Loop patterns
Week 4: Metadata-Driven Frameworks
- Configuration tables
- Dynamic source/sink
- Parameter injection
- Template pipelines
Week 5: Data Flows Advanced
- Complex transformations
- Performance optimization
- Debug strategies
- Data flow expressions
Week 6: Error Handling
- Try-catch patterns
- Retry logic
- Logging frameworks
- Alert configuration
Week 7: Incremental Loading
- Watermark patterns
- CDC implementation
- Delta loads
- Full vs incremental
Week 8: Integration Scenarios
- REST APIs
- SFTP and file systems
- SaaS connectors
- Custom activities
Week 9: Performance Optimization
- Pipeline tuning
- Partition strategies
- DIU optimization
- Cost management
Week 10: CI/CD and DevOps
- ARM templates
- Azure DevOps pipelines
- Environment promotion
- Release management
Week 11: Monitoring and Troubleshooting
- Azure Monitor integration
- Log Analytics
- Alerting strategies
- Debugging techniques
Week 12: Capstone Project
- Enterprise pipeline solution
- Documentation
- Best practices review
- Certification prep
Career Services
Typical Roles:
- Azure Data Engineer
- ETL Developer
- Data Integration Specialist
- Cloud Data Architect
Strong foundation for DP-203 certification