sql server

The ‘Mastering SQL Server 2016 Integration Services (SSIS)-Part 1’ course provides developers with a thorough knowledge in developing SSIS Packages with SQL Server 2016. This course is broken down into 21 modules with each module providing source code so that you can follow along with the Instructor.

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. The course is usually available for INR 2,799 on Udemy but you can click on the link and get the ‘Mastering SQL Server 2016 Integration Services (SSIS)-Part 1’ for INR 499.

Who all can opt for this course?

  • Those who want to learn SSIS from scratch or who are currently active in producing packages using prior versions of DTS/SSIS can both benefit from this course.

Course Highlights

Key HighlightsDetails
Registration LinkApply Now!
PriceINR 499 (INR 2,79980% off
Duration10.5 Hours
Student Enrollment25,472 students
InstructorKameswara Sarma Uppuluri
Topics CoveredSSIS, Data Flow, Control Flow, WMI Tasks
Course LevelBeginner
Total Student Reviews6,468

Learning Outcomes

  • Study data migration methods.
  • Discover how to use different Data Flow transformations.
  • Discover how to use different Control Flow activities.
  • Study Configuration File use.
  • Discover the creation of dynamic SSIS packages.
  • Learn how to handle events.
  • Find out how to use WMI tasks.
  • Discover how to transmit messages across packages using MSMQ.
  • Discover how to use maintenance plan tasks to increase the database’s performance.
  • Discover how to use CheckPoints.
  • Understand how to work with different data destinations and sources.

Course Content

S.No.Module (Duration)Topics
1.SSIS – The Big Picture (36 minutes)Course Introduction
Installing SQL Server 2016
Installing SSDT
Setting Up Sample Database
Overview of SQL Server Integration Services (SSIS)
2.Data Migration Techniques (19 minutes)Working with Import Export Wizard
Invoking Wizard From SSMS
Invoking Wizard From SSDT
3.Working with Data Flow Tasks – 1 (39 minutes)Exporting Data From SQL Server To CSV File
Working with CharacterMap Transformation
Working with CopyColumn Transformation
Working with DerivedColumn Transformation
Working with PercentageSampling Transformation
Working with RowSampling Transformation
4.Working with Data Flow Tasks – 2 (32 minutes)Working with Sort Transformation
Working with UnionAll Transformation
Working with Multicast Transformation
Working with ConditionalSplit Transformation
Working with Aggregate Transformation
5.Working with Data Flow Tasks – 3 (38 minutes)Working with Audit Transformation
Working with ExportColumn Transformation
Working with ImportColumn Transformation
Working with Merge Transformation
Working with MergeJoin Transformation
6.Working with Data Flow Tasks – 4 (49 minutes)Working with LookUp Transformation
Working with CacheTransform
Working with FuzzyLookUp Transformation
Working with FuzzyGrouping Transformation
7.Working with Data Flow Tasks – 5 (26 minutes)Working with RowCount Transformation
Working with OLEDBCommand Transformation
Working with Pivot Transformation
Working with Unpivot Transformation
8.Working with Data Flow Tasks – 6 (15 minutes)Working with TermExtract Transformation
Working with TermLookUp Transformation
9.Working with Control Flow – 1 (33 minutes)Working with BulkInsert Task
Working with SequenceContainer Task
Working with ExecuteProcess Task
Working with ExecutePackage Task
Passing Parameters between Packages
10.Working with Control Flow – 2 (39 minutes)Working with FileSystem Task
Working with WebService Task
Working with XML Task
Working with DataProfilingTask
11.Working with ControlFlow – 3 (22 minutes)Working with TransferDatabase Task
Working with TransferSQLServerObjects Task
Working with TransferMasterStoredProcedures Task
Working with TransferJobs Task
Working with TransferLogins Task
Working with TransferErrorMessages Task
12.Working with Control Flow – 4 (45 minutes)Working with For Loop Container in a Fixed Manner
Working with For Loop Container in a Variant Manner
Working with For Each File Enumerator
Working with For Each Item Enumerator
Working with For Each From Variable Enumerator
Working with For Each Node List Enumerator
Working with For Each SMO Enumerator
Working with For Each ADO Enumerator
13.Working with Configuration Types (19 minutes)Using Configuration Files
Using Configuration Tables
14.Creating Dynamic Packages (13 minutes)Creating Dynamic Connection Managers
Creating Dynamic Tasks
15.Event Handling Techniques (14 minutes)Using Precedence Constraints
Handling Events
16.Working with Log Providers (09 minutes)Working with Log Provider for Text Files
Working with Log Provider for XML Files
Working with Log Provider for Windows Event Log
17.Working with WMI Tasks (22 minutes)Working with WMIDataReader Task – 1
Working with WMIDataReader Task – 2
Working with WMIEventWatcher Task
18.Using Message Queuing Techniques (10 minutes)Sending and Receiving Messages with Message Queuing Task
19.Working with Maintenance Planning Tasks (41 minutes)Working with BackUpDatabase Task
Working with SQLServer Agent Job Task
Working with Execute T-SQL Task
Working with Update Statistics Task
Working with HistoryCleanUp Task
Working with ShrinkDatabase Task
Working with RebuildIndexes Task
Working with ReorganizeIndex Task
Working with CheckDatabaseIntegrity Task
20.Implementing CheckPoints (06 minutes)Working with CheckPoints
21.Working with Various Sources And Destinations of SSIS (31 minutes)Working with XML Source and RAWFileDestination
Working with RAWFileSource and SQLServer Destination
Working with ADO.NET Source and ADO.NET Destination
Working with RecordSet Destination
Working with DataReader Destination
22.Incremental Data Loading Techniques (24 minutes)Implementing Incremental Inserts
Updating Modified Records
Deleting Records
23.Working with CDC Components (26 minutes)Configuring CDC
Implementing Initial Load
Implementing Incremental Inserts
Updating Modified Records
Deleting Records
24.Deployment (17 minutes)Deploying SSIS Packages
Executing Packages Manually
Executing Packages through a Scheduler
Executing Packages through T-SQL

Resources Required

  • 2016 version of SQL Server, SQL Server Data Tools (SSDT)

Featured Review

KBala (5/5) : excellent covering up what each component (control flow and data flow)


  • Cherian john (5/5) : In-fact I’ve started using in my office and have impressed my team by automating some of the routine report.
  • Amit Kumar (5/5) : Yes it is absolutely perfect for the beginners and intermediate level skills in SSIS
  • Wade Delbert Anthony (5/5) : BONUS! BONUS! BONUS This has to be the best SSIS tutorial.
  • Naved Sheikh (5/5) : Great Content !!! ….In Detail explanation for every Task for both control and Data Flow sections


  • Katie Efird (1/5) : This course was really of no help at all and frustrating.
  • Paromita Sen (2/5) : It is hard to understand teacher’s English accent 90% of the time.
  • Sandra Richener Scott (1/5) : I am half way through the course and I just started another one with the same subject.

About the Author

The instructor of this course is Kameswara Sarma Uppuluri who is a Microsoft Certified Trainer. With 4.5 Instructor Rating and 13,220 Reviews on Udemy, Instructor offers 13 Courses and has taught 50,287 Students so far.

  • ITAcademy was founded by Kameswara Sarma Uppuluri and offers consultation, LIVE online training, and in-person training services for Web technologies like SharePoint 2013, SharePoint 2010, ASP, NETMVC, SSIS, SSRS, SSAS, DotNet, and SQLServer.
  • Since 2004 he has been a Microsoft Certified Trainer, and since 1998 he has been a Microsoft Certified Professional.
  • He does corporate trainings for top MNCs in India and also provides LIVE online trainings to people all over the world.
  • He has more than 16 years of expertise in the training and development industry.
  • His current Microsoft certifications are Microsoft Certified Trainer (MCT), Microsoft Certified Technical Specialist (MCTS), Microsoft Certified Solution Developer (MCSD), and Microsoft Certified Database Administrator are among the certifications (MCDBA).

Comparison Table

ParametersMastering SQL Server 2016 Integration Services (SSIS)-Part 1SQL Server Analysis Services – SSAS, Data Mining & AnalyticsMastering SQL Server 2016 Integration Services (SSIS)-Part 2
OffersINR 499 (INR 2,799) 80% offINR 455 (INR 3,499) 87% offINR 455 (INR 3,499) 87% off
Duration10.5 hours8 hours13 hours
Student Enrollments25,4728,1595,371
InstructorsKameswara Sarma UppuluriSiddharth MehtaKameswara Sarma Uppuluri
Register HereApply Now!Apply Now!Apply Now!

Leave feedback about this

  • Rating