4.33 out of 5
4.33
1737 reviews on Udemy

Mastering SQL Server 2016 Integration Services (SSIS)

Learn How to Create SSIS Packages From Scratch Step By Step
Instructor:
Kameswara Uppuluri
7,684 students enrolled
English [Auto-generated] More
Learn Data Migration Techniques
Learn How to work with various DataFlow Transformations
Learn How to work with various ControlFlow Activities
Learn How to use Configuration Files
Learn How to make Dynamic SSIS Packages
Learn How to do Event Handling
Learn How to work with WMI Tasks
Learn How to use MSMQ to pass messages between Packages
Learn How to improve the DB Performance by using Maintenance Plan Tasks
Learn How to Implement CheckPoints
Learn How to work with various Data Sources and Data Destinations

SSIS is an enterprise-level Extract,Transform and Load (ETL) Development tool.

SSIS is one of the most powerful application for moving data in and out of various databases and files.


This course provides developers with a thorough knowledge in developing SSIS Packages with SQL Server 2016.

In this course by development expert Kameswara Sarma Uppuluri, you’ll learn essential concepts that you need to know to buildĀ SSIS Packages from scratch.

This course provides step-by-step walk-throughs and demos that you’re encouraged to practice along with to enhance the learning process.

This course is broken down into 21 Modules with each module providing source code so that you can follow along with Kameswara Sarma Uppuluri.


SSIS - The Big Picture

1
Course Introduction
2
Installing SQL Serever 2016
3
Installing SSDT
4
Setting Up Sample Database
5
Overview of SQL Server Integration Services (SSIS)
6
COMPLETE COURSE EXERCISE FILES

Data Migration Techniques

1
Working with Import Export Wizard
2
Invoking Wizard From SSMS
3
Invoking Wizard From SSDT

Working with Data Flow Tasks - 1

1
Exporting Data From SQL Server To CSV File
2
Working with CharacterMap Transformation
3
Working with CopyColumn Transformation
4
Working with DerivedColumn Transformation
5
Working with PercentageSampling Transformation
6
Working with RowSampling Transformation

Working with Data Flow Tasks - 2

1
Working with Sort Transformation
2
Working with UnionAll Transformation
3
Working with Multicast Transformation
4
Working with ConditionalSplit Transformation
5
Working with Aggregate Transformation

Working with Data Flow Tasks - 3

1
Working with Audit Transformation
2
Working with ExportColumn Transformation
3
Working with ImportColumn Transformation
4
Working with Merge Transformation
5
Working with MergeJoin Transformation

Working with Data Flow Tasks - 4

1
Working with LookUp Transformation
2
Working with CacheTransform
3
Working with FuzzyLookUp Transformation
4
Working with FuzzyGrouping Transformation

Working with Data Flow Tasks - 5

1
Working with RowCount Transformation
2
Working with OLEDBCommand Transformation
3
Working with Pivot Transformation
4
Working with Unpivot Transformation

Working with Data Flow Tasks - 6

1
Working with TermExtract Transformation
2
Working with TermLookUp Transformation

Working with Control Flow - 1

1
Working with BulkInsert Task
2
Working with SequenceContainer Task
3
Working with ExecuteProcess Task
4
Working with ExecutePackage Task
5
Passing Parameters between Packages

Working with Control Flow - 2

1
Working with FileSystem Task
2
Working with WebService Task
3
Working with XML Task
4
Working with DataProfilingTask

Working with ControlFlow - 3

1
Working with TransferDatabase Task
2
Working with TransferSQLServerObjects Task
3
Working with TransferMasterStoredProcedures Task
4
Working with TransferJobs Task
5
Working with TransferLogins Task
6
Working with TransferErrorMessages Task

Working with Control Flow - 4

1
Working with For Loop Container in a Fixed Manner
2
Working with For Loop Container in a Variant Manner
3
Working with For Each File Enumerator
4
Working with For Each Item Enumerator
5
Working with For Each From Variable Enumerator
6
Working with For Each Node List Enumerator
7
Working with For Each SMO Enumerator
8
Working with For Each ADO Enumerator

Working with Configuration Types

1
Using Configuration Files
2
Using Configuration Tables

Creating Dynamic Packages

1
Creating Dynamic Connection Managers
2
Creating Dynamic Tasks

Event Handling Techniques

1
Using Precedence Constraints
2
Handling Events

Working with Log Providers

1
Working with Log Provider for Text Files
2
Working with Log Provider for XML Files
3
Working with Log Provider for Windows Event Log

Working with WMI Tasks

1
Working with WMIDataReader Task - 1
2
Working with WMIDataReader Task - 2
3
Working with WMIEventWatcher Task

Using Message Queuing Techniques

1
Sending and Receiving Messages with Message Queuing Task

Working with Maintenance Planning Tasks

1
Working with BackUpDatabase Task
2
Working with SQLServer Agent Job Task
3
Working with Execute T-SQL Task
4
Working with Update Statistics Task
5
Working with HistoryCleanUp Task
6
Working with ShrinkDatabase Task
7
Working with RebuildIndexes Task
8
Working with ReorganizeIndex Task
9
Working with CheckDatabaseIntegrity Task

Implementing CheckPoints

You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
4.3
4.3 out of 5
1737 Ratings

Detailed Rating

Stars 5
747
Stars 4
677
Stars 3
242
Stars 2
50
Stars 1
21
801da1a6497e076bb9492d6e05ce7776
30-Day Money-Back Guarantee

Includes

11 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion