Course Description
Ascendient Learning's 5-day Developing and Administering SQL Server Integration Services (SSIS) class teaches attendees how to use SSIS to build, deploy, maintain, and secure Integration Services projects and packages. SSIS is used to extract, transform, and load data to and from SQL Server.
We also offer a 4-day class to cover package development and the basics of deploying packages if your group does not wish to include administrative topics.
Note: This class is appropriate for SQL Server 2012 through 2019.
Skills Gained
All attendees will:
- Create sophisticated SSIS packages for extracting, transforming, and loading data
- Use containers to efficiently control repetitive tasks and transactions
- Configure packages to dynamically adapt to environment changes
- Use Data Quality Services to cleanse data
- Successfully troubleshoot packages
- Create and Manage the SSIS Catalog
- Deploy, configure, and schedule packages
- Secure the SSIS Catalog
Prerequisites
Students should be comfortable with SQL Server Management Studio and writing basic queries.
Training Materials
All SSIS students receive comprehensive courseware.
Software Requirements
Attendees will not need to install any software on their computers for this class. The class will be conducted in a remote environment that Ascendient Learning will provide; students will only need a local computer with a web browser and a stable Internet connection. Any recent version of Microsoft Edge, Mozilla Firefox, or Google Chrome will work well.