Mastering SQL Server 2016 Integration Services (SSIS)-Part 2

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Introduction

Lecture 2: Installing SQL Server 2022, SSMS

Lecture 3: Installing Visual Studio 2022 Community Edition, Project Templates

Lecture 4: Installation of SQL Server 2017

Lecture 5: Installation of SQL Server Management Studio

Lecture 6: Installation of SQL Server Data Tools

Lecture 7: Setting Up Azure Feature Pack

Lecture 8: Complete Course Exercise Files

Chapter 2: Loading Non-Relational Data From Multiple Excel Files Into Multiple Tables

Lecture 1: Setting Up AdventureWorks 2017 Database

Lecture 2: Overview of Sample Data

Lecture 3: Inserting Combined Data Into Relational Tables and Raw File Destination – Part 1

Lecture 4: Inserting Combined Data Into Relational Tables and Raw File Destination – Part 2

Lecture 5: Inserting Data Into Tables using Raw File Source

Lecture 6: Testing the Final Version of our SSIS Package

Chapter 3: Implementing Transaction Support Into SSIS Packages

Lecture 1: Executing SSIS Package without Transaction Support

Lecture 2: Executing SSIS Package With Transaction Support

Chapter 4: CheckPoints vs Transactions With Cache Transform

Lecture 1: Implementing CheckPoints in a package that uses Cache

Chapter 5: Configuring Package Parameters Externally

Lecture 1: Creating Package Parameters

Lecture 2: Deploying SSIS Project From SSDT To Integration Services Catalog

Lecture 3: Deploying SSIS Project using Integration Services Package Deployment Utility

Lecture 4: Deploying SSIS Project From One Server To Another Server

Lecture 5: Project Deployment Mode Vs Package Deployment Mode

Lecture 6: Executing Deployed Package Individually

Lecture 7: Execute Deployed Package through a Job

Lecture 8: Creating Environments & Referencing Environment Variables

Chapter 6: Publishing Data Feeds from SSIS Using DataStreamDestination

Lecture 1: Overview of Data Feed Publishing Components

Lecture 2: Publishing Data Feed by using Data Feed Publishing Wizard

Lecture 3: Publishing Data Feed Manually

Chapter 7: Consuming Data Feed using OData

Lecture 1: Working with OData Source Component To Consume SharePoint Online Data

Chapter 8: Reading Multiple Excel Sheets Data From SSIS Package

Lecture 1: Overview of Sample Data

Lecture 2: Getting Ready with Access Redistributable

Lecture 3: Developing a SSIS Package to read data of multiple sheets of a Single Excel File

Lecture 4: Reading Data of multiple Sheets in much a Better Way

Chapter 9: Working with Slowly Changing Dimension

Lecture 1: Using Slowly Changing Dimension Part – 1

Lecture 2: Using Slowly Changing Dimension Part – 2

Chapter 10: Setting Up Hadoop Environment To Work From SSIS

Lecture 1: Installing VMWare Workstation Player

Lecture 2: Downloading and Importing Hadoop VM

Lecture 3: Starting Up Hadoop VM

Lecture 4: Copy File To HDFS

Lecture 5: Copy File From HDFS

Lecture 6: Copy Files With In HDFS

Lecture 7: Working With Hadoop File Source And FIle Destination Tasks

Lecture 8: Upload Files To Hadoop

Lecture 9: Download Files From Hadoop

Lecture 10: Working with Hadoop Hive Task

Lecture 11: Working with Hadoop Pig Task

Chapter 11: Setting Up Oracle Environment

Lecture 1: Installing JRE

Lecture 2: Installing Oracle 11g

Lecture 3: Installing SQLDeveloper

Lecture 4: Installing Oracle 11g Client

Chapter 12: Working with Oracle from SSIS

Lecture 1: Import Data From Oracle

Lecture 2: Export Data To Oracle

Lecture 3: Working With Oracle Source And Oracle Destination Tasks

Lecture 4: Working with OLEDBSource Task

Lecture 5: Working with OLEDBDestination Task

Lecture 6: Working with OLEDBSource And OLEDBDestination Together

Chapter 13: Working with Azure from SSIS

Lecture 1: Working with Azure Resource Groups

Lecture 2: Working with Azure Storage Accounts

Lecture 3: Working with Azure Upload Task

Lecture 4: Working with Azure Download Task

Lecture 5: Working with Azure Blob Source Task

Lecture 6: Working with Azure Blob Destination Task

Lecture 7: Working with Azure Data Lake Storage

Lecture 8: Working with Azure Active Directory

Lecture 9: Copy Data To Azure Data Lake Storage

Lecture 10: Copy Data From Azure Data Lake Storage

Lecture 11: Working with Azure Data Lake Source Task

Lecture 12: Working with Azure Data Lake Destination Task

Lecture 13: Uploading Files with Flexible File Task

Lecture 14: Downloading Files with Flexible File Task

Lecture 15: Working with Flexible File Source Task

Lecture 16: Working with Flexible File Destination Task

Chapter 14: Working with HDInsight From SSIS

Lecture 1: Setting Up Hadoop Cluster On Cloud

Lecture 2: Uploading a File To HDInsight Storage

Lecture 3: Working with HDInsight Hive Task

Lecture 4: Working with HDInsight Pig Task

Lecture 5: Removing HDInsight Cluster From Microsoft Azure

Lecture 6: Create HDInsight Cluster From SSIS

Lecture 7: Delete HDInsight Cluster From SSIS

Lecture 8: Working with SQL Server On Azure

Lecture 9: Working with SQL DataWareHouse On Azure

Lecture 10: Working with SQLDW Upload Task

Lecture 11: Working with Azure Data Lake Analytics On Azure Portal

Lecture 12: Working with Azure Data Lake Analytics From SSIS

Lecture 13: Working with PowerQuery Source Task

Chapter 15: Working with SSAS Tabular Model