SSIS
This is 2 days(16 hours) training and you will learn data warehouse design principles, working with SSIS components and tasks, design patterns for filling data warehouse from flat files or relational databases and administration of SSIS packages.
SSIS Course Units
Data warehouse principles and dimensional modeling
- What is ETL?
- Data warehouse design (Star – Snowflake models)
- Different type of fact and dimension tables
- Date dimension
- Slowly Change Dimension types
- Staging data
- SQL Server Import/Export tool
Developing SSIS package
- Control Flow
- Sequence Container
- For Loop Container
- Foreach Loop Container
- Execute SQL Task
- File Systems Task
- FTP Task
- Data Flow Task
- Source Assistant
- Destination Assistant
- Derived Column
- Aggregate
- Lookup
- Slowly Changing Dimension
- Conditional Split`
- Merge, Merge Join, Union All
- Multicast
- Scripting
- Script Task
- Script Component
- Best practice of developing package for loading text files
- Best practice of developing package for filling data warehouse
SSIS Catalog
- Deploying SSIS project
- Define environments
- Monitoring and troubleshooting
- Schedule packages in SQL Server Agent