- Learning Path Libraries: This path is only available in the libraries listed. To access this path, purchase a license for the corresponding library.
- Data
Data Integration with Microsoft SSIS
SQL Server Integration Services (SSIS) is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks. It features a data warehousing tool used for data extraction, transformation, and loading (ETL). The tool may also be used to automate maintenance of SQL Server databases and updates to multidimensional cube data.
Content in this path
Beginner
Experience building your first SSIS package, and learn the constructs of Integration Services, including packages, projects, and solutions.
Intermediate
Learn the most common SSIS applications: database maintenance, Extract, Transform, and Load operations, and data lifting.
Advanced
Use sophisticated configuration of packages, and deploy packages into production. Apply SSIS to common data warehousing scenarios.
- Configuring and deploying SSIS packages
- Extracting and transforming data
- Loading data
- Managing SSIS projects
- Performing database maintenance with SSIS
- Planning data integration using SSIS
- Relational database literacy
- Microsoft SQL Server
- Relational database development
- Querying data with T-SQL
- SQL Server
- SQL Server Reporting Services
- Data Warehousing