This 4-day instructor led training focuses on developing and managing SSIS 2012 in the enterprise. In this course, you will understand how to design, develop, deploy, and operate SSIS solutions—this involves ETL solutions (extraction, transformation, and loading) from source systems extractions, data integration, SSIS server administration and package execution.
This course is intended for database professionals that are responsible for ETL or DBA activities related to data processing, data architecture planning, or SSIS administration.
The target audience for this session is IT professionals, DBAs and developers who want to learn the details of how to use SSIS to accomplish data integration, data warehouse loading, and how to administer SSIS through the development lifecycle to production.
SECTION A: DW and SSIS Overview and SSIS Core Features
Module 01: SSIS Overview and Core Features
Module 02: Data Warehousing
Module 03: SSIS Control Flow Objects and Features
Module 04: Extracting, Transforming and Loading data using SSIS Data Flows
SECTION B: Applying SSIS to Common Operations
Module 05: Working with Files, Importing and Exporting File Data
Module 06: Optimizing Data Extraction and Data Loading
Module 07: Data Quality and Cleasing
Module 08: Advanced Enterprise Information Management
SECTION C: Applying SSIS in BI and Data Warehouse Solutions
Module 09: Dimension ETL with SSIS
Module 10: Fact ETL with SSIS
Module 11: Project Deployment Model: Execution and Reporting
Module 12: Processing SSAS Objects in SSIS
SECTION D: Deployment
Module 13: Project Deployment
Module 14: Package Deployment
SECTION F: SSIS Solution and Performance Considerations
Module 15: Transactions and Restartability
Module 16: Optimization and Scalability
Join our public courses in our Istanbul, London and Ankara facilities. Private class trainings will be organized at the location of your preference, according to your schedule.