What Will I Learn?
- 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
Course Curriculum
1. SSIS - The Big Picture | |||
1.1 Course Introduction | 00:00:00 | ||
1.2. Installing SQL Serever 2016 | 00:00:00 | ||
1.3. Installing SSDT | 00:00:00 | ||
1.4. Setting Up Sample Database | 00:00:00 | ||
1.5. Overview of SQL Server Integration Services (SSIS) | 00:00:00 | ||
1.6. COMPLETE COURSE EXERCISE FILES | 00:00:00 | ||
2. Data Migration Techniques | |||
2.1. Working with Import Export Wizard | 00:00:00 | ||
2.2. Invoking Wizard From SSMS | 00:00:00 | ||
2.3. Invoking Wizard From SSDT | 00:00:00 | ||
3. Working with Data Flow Tasks - 1 | |||
3.1. Exporting Data From SQL Server To CSV File | 00:00:00 | ||
3.2. Working with CharacterMap Transformation | 00:00:00 | ||
3.3. Working with CopyColumn Transformation | 00:00:00 | ||
3.4. Working with DerivedColumn Transformation | 00:00:00 | ||
3.5. Working with PercentageSampling Transformation | 00:00:00 | ||
3.6. Working with RowSampling Transformation | 00:00:00 | ||
4. Working with Data Flow Tasks - 2 | |||
4.1. Working with Sort Transformation | 00:00:00 | ||
4.2. Working with UnionAll Transformation | 00:00:00 | ||
4.3. Working with Multicast Transformation | 00:00:00 | ||
4.4. Working with ConditionalSplit Transformation | 00:00:00 | ||
4.5. Working with Aggregate Transformation | 00:00:00 | ||
5. Working with Data Flow Tasks - 3 | |||
5.1. Working with Audit Transformation | 00:00:00 | ||
5.2. Working with ExportColumn Transformation | 00:00:00 | ||
5.3. Working with ImportColumn Transformation | 00:00:00 | ||
5.4. Working with Merge Transformation | 00:00:00 | ||
5.5. Working with MergeJoin Transformation | 00:00:00 | ||
6. Working with Data Flow Tasks - 4 | |||
6.1. Working with LookUp Transformation | 00:00:00 | ||
6.2. Working with CacheTransform | 00:00:00 | ||
6.3. Working with FuzzyLookUp Transformation | 00:00:00 | ||
6.4. Working with FuzzyGrouping Transformation | 00:00:00 | ||
7. Working with Data Flow Tasks - 5 | |||
7.1. Working with RowCount Transformation | 00:00:00 | ||
7.2. Working with OLEDBCommand Transformation | 00:00:00 | ||
7.3. Working with Pivot Transformation | 00:00:00 | ||
7.4. Working with Unpivot Transformation | 00:00:00 | ||
8. Working with Data Flow Tasks - 6 | |||
8.1. Working with TermExtract Transformation | 00:00:00 | ||
8.2. Working with TermLookUp Transformation | 00:00:00 | ||
9. Working with Control Flow - 1 | |||
9.1. Working with BulkInsert Task | 00:00:00 | ||
9.2. Working with SequenceContainer Task | 00:00:00 | ||
9.3. Working with ExecuteProcess Task | 00:00:00 | ||
9.4. Working with ExecutePackage Task | 00:00:00 | ||
9.5. Passing Parameters between Packages | 00:00:00 | ||
10. Working with Control Flow - 2 | |||
10.1. Working with FileSystem Task | 00:00:00 | ||
10.2. Working with WebService Task | 00:00:00 | ||
10.3. Working with XML Task | 00:00:00 | ||
10.4. Working with DataProfilingTask | 00:00:00 | ||
11. Working with ControlFlow - 3 | |||
11.1. Working with TransferDatabase Task | 00:00:00 | ||
11.2 Working with TransferSQLServerObjects Task | 00:00:00 | ||
11.3. Working with TransferMasterStoredProcedures Task | 00:00:00 | ||
11.4. Working with TransferJobs Task | 00:00:00 | ||
11.5. Working with TransferLogins Task | 00:00:00 | ||
11.6. Working with TransferErrorMessages Task | 00:00:00 | ||
12. Working with Control Flow - 4 | |||
12.1. Working with For Loop Container in a Fixed Manner | 00:00:00 | ||
12.2. Working with For Loop Container in a Variant Manner | 00:00:00 | ||
12.3. Working with For Each File Enumerator | 00:00:00 | ||
12.4. Working with For Each Item Enumerator | 00:00:00 | ||
12.5. Working with For Each From Variable Enumerator | 00:00:00 | ||
12.6. Working with For Each Node List Enumerator | 00:00:00 | ||
12.7. Working with For Each SMO Enumerator | 00:00:00 | ||
12.8. Working with For Each ADO Enumerato | 00:00:00 | ||
13. Working with Configuration Types | |||
13.1. Using Configuration Files | 00:00:00 | ||
13.2. Using Configuration Tables | 00:00:00 | ||
14. Creating Dynamic Packages | |||
14.1. Creating Dynamic Connection Managers | 00:00:00 | ||
14.2. Creating Dynamic Tasks | 00:00:00 | ||
15. Event Handling Techniques | |||
15.1. Using Precedence Constraints | 00:00:00 | ||
15.2. Handling Events | 00:00:00 | ||
16. Working with Log Providers | |||
16.1. Working with Log Provider for Text Files | 00:00:00 | ||
16.2. Working with Log Provider for XML Files | 00:00:00 | ||
16.3. Working with Log Provider for Windows Event Log | 00:00:00 | ||
17. Working with WMI Tasks | |||
17.1. Working with WMIDataReader Task – 1 | 00:00:00 | ||
17.2. Working with WMIDataReader Task – 12 | 00:00:00 | ||
17.3. Working with WMIEventWatcher Task | 00:00:00 | ||
18. Using Message Queuing Techniques | |||
18.1. Sending and Receiving Messages with Message Queuing Task | 00:00:00 | ||
19. Working with Maintenance Planning Tasks | |||
19.1. Working with BackUpDatabase Task | 00:00:00 | ||
19.2. Working with SQLServer Agent Job Task | 00:00:00 | ||
19.3. Working with Execute T-SQL Task | 00:00:00 | ||
19.4. Working with Update Statistics Task | 00:00:00 | ||
19.5. Working with HistoryCleanUp Task | 00:00:00 | ||
19.6. Working with ShrinkDatabase Task | 00:00:00 | ||
19.7. Working with RebuildIndexes Task | 00:00:00 | ||
19.8. Working with ReorganizeIndex Task | 00:00:00 | ||
19.9. Working with CheckDatabaseIntegrity Task | 00:00:00 | ||
20. Implementing CheckPoints | |||
20.1. Working with CheckPoints | 00:00:00 | ||
21. Working with Various Sources And Destinations of SSIS | |||
21.1. Working with XML Source and RAWFileDestination | 00:00:00 | ||
21.2. Working with RAWFileSource and SQLServer Destination | 00:00:00 | ||
21.3. Working with ADO.NET Source and ADO.NET Destination | 00:00:00 | ||
21.4. Working with RecordSet Destination | 00:00:00 | ||
21.5. Working with DataReader Destination | 00:00:00 | ||
22. Incremental Data Loading Techniques | |||
22.1. Implementing Incremental Inserts | 00:00:00 | ||
22.2. Updating Modified Records | 00:00:00 | ||
22.3. Deleting Records | 00:00:00 | ||
23. Working with CDC Components | |||
23.1. Configuring CDC | 00:00:00 | ||
23.2. Implementing Initial Load | 00:00:00 | ||
23.3. Implementing Incremental Inserts | 00:00:00 | ||
23.4. Updating Modified Records | 00:00:00 | ||
23.5. Deleting Records | 00:00:00 | ||
24. Deployment | |||
24.1. Deploying SSIS Packages | 00:00:00 | ||
24.2. Executing Packages Manually | 00:00:00 | ||
24.3. Executing Packages through a Scheduler | 00:00:00 | ||
24.4. Executing Packages through T-SQL | 00:00:00 |
3 STUDENTS ENROLLED