Introduction to SQL Server Integration Services (SSIS) LiveLessons (Video Training): Getting started with Extract, Transform, and Load (ETL) using SSIS

Course Cover
compare button icon

Course Features

icon

Duration

7.3 hours

icon

Delivery Method

Online

icon

Available on

Limited Access

icon

Accessibility

Desktop, Laptop

icon

Language

English

icon

Subtitles

English

icon

Level

Beginner

icon

Teaching Type

Self Paced

icon

Video Content

7.3 hours

Course Description

Today, extract, transform, and load (ETL) are essential IT processes. The ability to move data from one location to another has become a core competency in almost every company. SQL Server provides Integration Services (SSIS) thatallow database administrators (DBAs) and Developers alike to createand deploy advanced ETL packages to leverage the data within theirorganizations.Whether a company has one-time data copy or large ETL processto design, they want to be able to complete their work as easily aspossible. SSIS is now available with SQL Serverplatform. It is one of the most cost-effective and easy ways to get SQL Server running.
IT shops may have hundreds of software developers who all run and develop applications for SQL Server. Additionally, hundreds of third-party applications use SQL Server to store data. Companies will need to be able to consolidate and analyze all of this data. Familiarity with an ETL tool willbecome an absolute necessity when data needs to be moved forconsolidation, reporting, and data mining.Introduction to SQL Server Integration Services(SSIS)LiveLessons covers the basic building blocks of SSIS.Topics will include basic design, understand control flows, usingdata flows, and deployment and scheduling of packages.
SSIS is a complex tool that has many moving parts. IT professionals will appreciate having a concise resource to help them.

Course Overview

projects-img

International Faculty

projects-img

Post Course Interactions

projects-img

Hands-On Training,Instructor-Moderated Discussions

Skills You Will Gain

What You Will Learn

Achieve an understanding of all the programmability objects in SSIS and the use of each

Acquire the basics needed in order to maintain existing SSIS packages

Attain an understanding of ETL process and how to best go about accessing and manipulating data

Gain an understanding of crucial topics like data flows, control flows, package deployment, and configuration management

Learn about SSIS and be able to produce better packages for data manipulation

Target Students

An understanding of basic data storage terminology is alsohelpful

Course Requirements:Basic knowledge of SQL Server or another database managementsystem

Course Cover