Duration
28 hours (usually 4 days including breaks)
Requirements
Prior experience with SQL Server 2012
Course Outline
- ETL and SSIS
- Packages
- Control Flow
- Workflow
- Constraints
- Data Flows
- Variables
- Containers
- Transactions
- Errors and Debugging
- Logging
- Slowly Changing Dimensions
- Deploying a Package
- Security
- Scripting
- Best Practices