In this SSIS training 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, ODBC, and OLE DB — and effectively and securely manage data migration across various platforms.
Additionally, in this SSIS training course, you’ll gain the skills to migrate and transform data with SQL Server Integration Services. 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 Delivery Methods
In-Person
Online
SQL Server Integration Services (SSIS) Training for Business Intelligence Course 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.
Extract, Transform, and Load (ETL) data.
Incrementally migrate data from SQL Server data sources using Change Data Capture (CDC).
Deploy packages to an SSIS catalog.
SSIS Training for Business Intelligence Prerequisites
Familiarity with relational database management systems, programming concepts, and SQL language.
SSIS Training Course Outline
Defining SQL Server Integration Services (SSIS)
Exploring the need for migrating diverse data
The role of Business Intelligence (BI)
Managing heterogeneous data
Leveraging the Extract, Transform and Load (ETL) capabilities of SSIS
Running wisards for basic migrations
Creating packages for complex tasks
Explore other supported data sources, such as Hadoop and NoSQL
Illustrating SSIS architecture
Distinguishing between data flow pipeline and package runtime
Executing packages on the client side or hosted in the SSIS service
Bulletproofing a package with package environments
Package restartability with checkpoint files
Simplifying deployments
Distinguishing between project and package deployment modes
Deploying packages to the SSISDB
Running packages from SQL Server
Leveraging package parameters
Utilising basic SSIS objects
Configuring connection managers
Adding data flow tasks to packages
Reviewing progress with data viewers
Assembling tasks to perform complex data migrations
Migrating multiple files with FOREACH container
Operating system-level tasks
Copying, moving, and deleting files
Transferring files with the FTP task
Communicating with external sources
Sending messages through mail
Processing XML
Iterating XML nodes
Writing XML files from databases
Writing expressions
Making properties dynamic with variables
Utilising expressions in loop iterations
Script Task
Extending functionality with the Script Task
Debugging, breakpoints, and watches
Performing transforms on columns
Converting and calculating columns
Transforming with Character Map
Profiling, combining, and splitting data
Merge, Union, and Conditional Split
Multicasting and converting data
Manipulating row sets and BLOB data
Aggregate, sort, audit, and look up data
Importing and exporting BLOB data
Redirecting error rows
Performing database operations
Executing a SQL task
Bulk inserting data from text files
Organising package workflow
Defining success, failure, completion, and expression precedence constraints
SSIS Training for Business Intelligence Course FAQs
This is an intermediate-level SQL training course. We recommend some knowledge of relational databases management systems, programming concepts, and SQL language prior to taking this course.
Microsoft Integration Services is a platform for building enterprise-level data integration and data-transformation solutions. You use Integration Services to solve complex business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data. The packages can work alone or in concert with other packages to address complex business needs. Integration Services can extract and transform data from various sources, such as XML data files, flat files, and relational data sources, and then load the data into one or more destinations.
SQL Server developers, administrators, and analysts who need to migrate and transform data among diverse platforms.
It is essential for organisations to securely manage data migration among a myriad of platforms to enhance their business intelligence capabilities. In this course, attendees learn to leverage SQL Server Integration Services to extract, transform, load, and integrate data from various sources. Typical participants include database developers and analysts who need to migrate data among diverse platforms. In addition, database administrators who need to manage Integration Services packages stored on SQL Server and database professionals working in mixed DBMS environments such as Oracle, Access, and SQL Server will benefit from this course.
Most tasks in this course can be accomplished with no programming. However, you will learn to use programming to extend the capabilities of SSIS even if you have never programmed before. The course will give all the necessary information to complete the exercises.
SSIS is one of the components of Microsoft's Business Intelligence platform. The other two consist of Reporting Services and Analysis Services. SSIS allows you to migrate data for decision support purposes. Once migrated, you can analyse data with Analysis Services, and reports can be built using Reporting Services.
You'll be given remote access to a preconfigured virtual machine for you to redo your hands-on exercises, develop/test new code, and experiment with the same software used in your course.
This course uses Microsoft SQL Server 2016, running on Windows Server 2016
This course applies to those using earlier versions of SQL Server
