Overview
This one-day hands-on, instructor led course guides you through the numerous features of SQL Server Integration Services (SSIS) using real-world exercises structured around the components provided by the SQL Server Data Tools development environment. You will learn a practical approach to solving real-world problems using SSIS, which will provide you the ability to collect enterprise data from various sources such as SQL Server OLTP databases, Access databases, Excel worksheets and more, and transform the data for OLAP analysis, mining, and reporting.
Download Course Outline View Schedule/Book OnlineWho Should Attend
This course is designed for anyone who wants to use SQL Server Integration Services (SSIS) to develop extract, transform and load (ETL) solutions. This includes developers and database administrators, business analysts and anyone that designs and builds ETL solutions
Course Objectives
After completing this course, participants will be able to:
- Describe key features of SSIS
- Explore source data for an ETL solution
- Implement a data flow by using SSIS
- Implement control flow with tasks and precedence constraints
- Create dynamic packages that include variables and parameters
- Use containers in a package control flow
- Enforce consistencey with transactions and checkpoints
- Describe considerations for SSIS deployment
- Deploy SSIS projects
- Plan SSIS package execution
Course Prerequisites
Before attending this course, participants should have:
- An understanding of SQL Server 2012
- Experience in creating, retrieving, updating and deleting queries using T-SQL
- Ideally know how to connect to an instance of SQL Server using the various connection dialog boxes in Management Studio and development tools
Reviews
There are no reviews yet.