Microsoft Training - SQL Server Training

Introduction

This intense and practical course will provide delegates with the skills and knowledge to understand how to develop and manage the SSIS 2012 in the enterprise. This course covers the SSIS solutions including designing, developing, deploying and operating embracing ETL solutions.

Pre-Requisites?

• There are pre-requisites needed for this course. Please See FAQ’s

Who should attend?

• This course is suitable for database professionals that are responsible for ETL or DBA activities related to data processing, data architecture planning, or SSIS administration

What will you learn?

• Once you have completed the Accelerated SQL Server 2012 Integration Services course you will:
• Understand new SSIS projects and packages
• Understand when to use project mode versus package mode
• Understand how to relate SSIS to file and data management
• Understand ETL Concepts in SSIS
• Understand SSIS for server deployment and production execution

Course Outline

• Outline and Core Features of SSIS
• Control Flow Objects of SSIS
• Summary of Development Environment
• Workflow Management in the Control Flow
• Transformations and Adapters
• Common Operations with SSIS
• Importing Files
• Data Source Extraction and Destination Optimization
• FTP Sourced Files
• Incremental Extraction
• ODBC Foundations
• Data Quality and Cleansing
• Fuzzy Lookup
• DQS Cleansing Transformations
• Data Warehouse Solutions using SSIS in BI
• Applying SSIS with Dimension ETL
• Fact ETL with SSIS and ETL
• Using SSIS when Processing Tabular and Multidimensional SSAS Objects
• Analysis Services Processing
• Project Deployment Model
• Configuration, Deployment & Security
• SSIS Catalog Configurations and Project Deployment
• Execution and Reporting
• Executing Packages in the SSIS Catalog
• Package Deployment Model
• Configuration and Deployment
• Working with Package Configurations
• Execution, Security & Logging
• Package Logging and Execution
• Transactions and Restorability
• SSIS Solution and Performance Considerations
• SSIS Performance Issues Identification
• Solution Approach
• Team Development