Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Advanced Integration Services - Part 2

via Pluralsight

Overview

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.

This course explains how to apply Integration Services features to build packages that support the extract, transform, and load operations of a data warehouse. It shows strategies for managing high-volume, slowly changing dimensions and for handling text and XML files. It also explains how to adapt packages to work with Azure resources. In addition, this course reviews how to deploy packages to production and how to secure and execute deployed packages. This course was written for SQL Server 2014 Integration Services, but most principles apply to SQL Server 2005 and later.

Syllabus

  • Managing Incremental Loads 51mins
  • Azure and Integration Services 78mins
  • Deployment - Part 1 38mins
  • Deployment - Part 2 45mins
  • Security 37mins
  • Special Design Scenarios 33mins

Taught by

Stacia Misner Varga

Reviews

4.3 rating at Pluralsight based on 107 ratings

Start your review of Advanced Integration Services - Part 2

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.