Accelerated SQL Server 2012 Integration Services

PT9543
Training Summary
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.
Prerequisites
Before attending this course, it is recommended that students have the following skills:This course is targeted at database professionals and developers with some experience in business intelligence solutions and SQL Server. This workshop requires no prior experience with SQL Server SSIS.
Duration
4 Days/Lecture & Lab
Audience
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.
Course Topics
  • SSIS Overview and Core Features
  • SSIS Control Flow Objects and Features
  • Applying Data Flow Transformations and Adapters
  • Working With and Importing Files
  • Data Source Extraction and Destination Optimization
  • Data Quality and Cleansing
  • Dimension ETL with SSIS
  • Fact ETL with SSIS
  • Processing Tabular and Multidimensional SSAS Objects in SSIS
  • Project Deployment Model: Configuration, Deployment & Security
  • Project Deployment Model: Execution and Reporting
  • Package Deployment Model: Configuration and Deployment
  • Package Deployment Model: Execution, Security & Logging
  • Transactions and Restartability
  • Optimization and Scalability

Related Scheduled Courses