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 Highlights | Details |
|---|---|
| Registration Link | Apply Now! |
| Price | INR 499 ( |
| Duration | 10.5 Hours |
| Rating | 4.5/5 |
| Student Enrollment | 25,472 students |
| Instructor | Kameswara Sarma Uppuluri |
| Topics Covered | SSIS, Data Flow, Control Flow, WMI Tasks |
| Course Level | Beginner |
| Total Student Reviews | 6,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) | ||
| COMPLETE COURSE EXERCISE FILES | ||
| 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)
Pros
- 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
Cons
- 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
| Parameters | Mastering SQL Server 2016 Integration Services (SSIS)-Part 1 | SQL Server Analysis Services – SSAS, Data Mining & Analytics | Mastering SQL Server 2016 Integration Services (SSIS)-Part 2 |
|---|---|---|---|
| Offers | INR 499 ( | INR 455 ( | INR 455 ( |
| Duration | 10.5 hours | 8 hours | 13 hours |
| Rating | 4.5/5 | 4.1/5 | 4.7/5 |
| Student Enrollments | 25,472 | 8,159 | 5,371 |
| Instructors | Kameswara Sarma Uppuluri | Siddharth Mehta | Kameswara Sarma Uppuluri |
| Register Here | Apply Now! | Apply Now! | Apply Now! |
Leave feedback about this