MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Advanced Integration Services - Part 2

Course Summary

This course teaches you how to develop, deploy, and secure Integration Services packages that manage specific types of data warehouse extract, transform, and load operations.

  • +

    Course Syllabus

    Managing Incremental Loads
    - 51m 30s

    —Introduction 2m 8s
    —T-SQL MERGE Statement: Type 1 SCD 4m 32s
    —T-SQL MERGE Statement: Type 2 SCD 3m 34s
    —Dimension Load Pattern with MERGE 1m 53s
    —Demo: Slowly Changing Dimension Handling with MERGE 10m 34s
    —Change Data Capture (CDC) 3m 56s
    —CDC in Integration Services 8m 25s
    —Demo: Slowly Changing Dimension Handling with CDC 14m 10s
    —Custom Component 0m 56s
    —Summary 1m 18s
    Azure and Integration Services
    - 1h 18m

    —Introduction 1m 0s
    —Architecture Options 0m 43s
    —Virtual Machines and SQL Databases 3m 35s
    —Demo: Creating an Azure Virtual Machine 3m 7s
    —Demo: Creating a SQL Database 3m 14s
    —Hybrid: On-premises and Azure 0m 46s
    —Demo: Creating a Virtual Network 7m 58s
    —Demo: Joining an Azure Virtual Machine to an On-Premises Network 2m 11s
    —ETL Strategies 1m 0s
    —Data Connections 0m 28s
    —Demo: Working with Data Connections in the Cloud 5m 25s
    —ETL Design Patterns for the Cloud 2m 13s
    —Demo: Modifying the ETL Design Pattern for the Cloud 11m 26s
    —Data Subsets 1m 6s
    —Demo: Extracting a Subset of Data 4m 59s
    —File Compression 1m 20s
    —Demo: Compressing Files for ETL 6m 30s
    —Additional Considerations for Cloud Integration 0m 34s
    —Planning for Failure 1m 30s
    —Demo: Implementing Retry Logic 12m 2s
    —Sharding 1m 19s
    —Scaling Processes 2m 36s
    —Summary 3m 10s
    Deployment - Part 1
    - 38m 30s
    Deployment - Part 2
    - 45m 5s
    - 37m 2s
    Special Design Scenarios
    - 33m 47s

Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url