Introduction to SQL Server 2016 Integration Services (SSIS) – Basic Tutorial for SQL Server 2016 Integration Services
Extract, Transform, and Load (ETL) processes have become a necessity in IT today. Being able to move data from one place to another has become a cornerstone in just about every company around the world. SQL Server 2016 provides Integration Services (SSIS) that allow database administrators (DBAs) and developers to create and deploy advanced ETL packages to leverage their organizations’ data.
Whether a company has a one-time data copy or a large ETL process to design, they want to be able to complete their work as easily as possible. With SSIS now being included with the SQL Server platform, it is one of the easiest and most cost-effective methods available to a store running SQL Server.
IT shops can have hundreds of software developers, all running and developing applications for SQL Server. In addition, hundreds of third-party applications use SQL Server for storage. All this data, sooner or later, will require that companies be able to consolidate and analyze it. Familiarity with an ETL tool will become an absolute necessity when data needs to be moved for consolidation, reporting, and data mining.
Table of Contents:
– Lesson 1: SSIS Overview
– Lesson 2: Control Flow Basics
– Lesson 3: Data Flow-Sources and Destinations
– Lesson 4: Data Flow-Transformations
Teacher: Eric Johnson
Level of training: Preliminary
time of training: 5 hours + 39 minutes
File size: 3630 MB