SQL Server Integration Services (SSIS) Training for Business Intelligence
Course 1344 DAY COURSE
Course Outline
In this SQL server integration services course, you gain the skills to improve business intelligence capabilities by automating complex migration tasks and auditing the success or failure of migration processes. In addition, you will learn to transform data among heterogeneous data sources — such as text files, Oracle, Access, XML (Extensible Markup Language), ODBC (Open Database Connectivity), and OLE DB (Object Linking and Embedding Database) — and effectively and securely manage data migration across various platforms.
In this SSIS training course, you’ll gain the skills to migrate and transform data with SSIS. You learn to solve data management problems by creating dynamic packages for migrating, processing, and reporting on data for business intelligence. Specifically, you learn to deploy packages to an SSIS server, assemble tasks to perform complex data migrations, and enhance package functionality with scripting.
SQL Server Integration Services (SSIS) Training for Business Intelligence Benefits
-
In this SSIS Training for Business Intelligence course, you will learn how to:
- Solve data management problems by migrating and processing data.
- Perform nonstandard imports and exports using the Script component.
- Assemble tasks to perform complex data migrations.
- ETL (Extract, Transform and Load) data.
- Incrementally migrate data from SQL (Structured Query Language) Server data sources using CDC (Change Data Capture).
- Deploy packages to an SSIS catalog.
-
SQL Server Integration Services Prerequisites
You should have familiarity with relational database management systems, programming concepts, and SQL language.
- choosing a selection results in a full page refresh