Sale!

Expert SQL Server Integration Services Class

$400.00 $250.00

Course Description

ETL (Extract, Transform and Load) is a process in data warehousing responsible for pulling data out of the source systems and placing it into a data warehouse. If we want to load data from flat file or from excel file to SQL Server, then we need some ETL tool like SSIS for this purpose.
Expert SQL Server Integration Services (SSIS) Class is a 3-day online course, aimed at providing professionals with knowledge on SQL Server Integration Services. After taking this course, user will be able to

• Design and Understand the SSIS Solutions
• Import and Export Data from and to different Sources
• Create, manage and maintain SSIS Packages
• Import and Export Data from and to different Sources using SSIS
• Use different Transformations to change the data on the fly
• Logging the progress of the SSIS package to log files or to SQL Server
• Use C# or VB.NET for some scripting purpose
• Load Data Warehouse
• Optimize SSIS Packages

Description

Course Description

ETL (Extract, Transform and Load) is a process in data warehousing responsible for pulling data out of the source systems and placing it into a data warehouse. If we want to load data from flat file or from excel file to SQL Server, then we need some ETL tool like SSIS for this purpose.
Expert SQL Server Integration Services (SSIS) Class is a 3-day online course, aimed at providing professionals with knowledge on SQL Server Integration Services. After taking this course, user will be able to

• Design and Understand the SSIS Solutions
• Import and Export Data from and to different Sources
• Create, manage and maintain SSIS Packages
• Import and Export Data from and to different Sources using SSIS
• Use different Transformations to change the data on the fly
• Logging the progress of the SSIS package to log files or to SQL Server
• Use C# or VB.NET for some scripting purpose
• Load Data Warehouse
• Optimize SSIS Packages

Duration

The course duration is 3 days.

Schedule

February 23-25, 2018

 

 

Modules

Day 1

SSIS Overview
Why to use ETL, where SSIS fits in ETL, Control Flow Architecture, Data Flow Tasks, Data Pipeline and Data Buffers

Basic ETL objects in SSIS
SSIS Data Types, Data Conversion in SSIS, SSIS Global and Local Variables, Precedence Constraints, Connection Managers, Data Flow Transformation usage

Mostly Used Components in SSIS, Loading data
Execute SQL Task, Data Flow Task, Loading data from flat file to SQL server, Exporting data from SQL server to Flat files, Exporting data from SQL server to Excel File.

Containers in SSIS
Sequence Container, For loop Container, Foreach Loop Container, Task Host Container

Day 2

Package Debugging and Data viewer
SSIS Parameters Usage and Variables, Control Flow Breakpoints – Usage, Data Flow Data Viewers and Audits, SSIS Expressions &Debugging Options, Debugging SSIS Packages & Limitations

Data Flow Transformations Part 1
Aggregate Transformation, Conditional Split Transformation, Data Conversion Transformation, Derived Column Transformation, LookUp Transformation, RowCount Transformation

Data Flow Transformations Part 2
Row Count Transformation, Sort Transformation, Merge Trasnsformation, Merge Join Transformation, Union All Transformation, Multicast Transformation, OLE DB Command Transformation, Script Component Transformation

Logging and Error Handing in SSIS
Log the package progress and log important package and user information to SQL Server and to flat files. Use different events like OnPreExecute in SSIS, Error handling in SSIS

Day 3

Executing SSIS Packages
Executing SSIS Package by SQL Server Data Tools, Executing the Package by dtexec, Executing the Package by dtexecUtil, Passing variable value to Package using through batch file

Scheduling and Running SSIS Packages using SQL Agent Job
Run the SSIS Packages using SQL Server Agent Job and schedule the package to be run based on some schedule.

Loading a Data Warehouse
Learn how to optimally load a data warehouse from a transactional database.

About The Instructor

Ahmad Osama is an Independent Consultant for Microsoft Data Platform Stack. He has provided consulting, training, content development & SQL support services to more than 120+ SQL Server customers globally.An expert in SQL Server & related technologies, he frequently speaks at user group events and conferences. Over the last 9 years, he has worked on countless SQL Server projects, consulted, trained & mentored more than 1000 IT professionals on SQL Server, delivered more than 50 workshops. Ahmad is also a Microsoft Most Valuable Professional (MVP) awardee on SQL Server for 2014-2016.

Reviews

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.