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

Mastering SQL Server 2016 Integration Services (SSIS)-Part 2, available at $69.99, has an average rating of 4.66, with 89 lectures, based on 1251 reviews, and has 7135 subscribers.

You will learn about Learn How to read data from multiple sheets of a single Excel File Source Learn How to work with Slowly Changing Dimension (SCD) to maintain Historical Data Learn How to download Hadoop and Set Up on a local system Learn How to work with Hadoop File System (HDFS) From SSIS Learn How to work with Hadoop Hive Task Learn How to work with Hadoop Pig Latin Script Task Learn How to download and Install Oracle 11g Learn How to perform ETL Operations with Oracle Database Learn How to use OLEDBSource and OLEDBDestinations Tasks to connect to Oracle Database Learn How to Create Azure Resource Groups Learn How to Create Azure Storage Accounts Learn How to upload Files to Azure Blob and Download Files from Azure Blob Containers Learn How to Create and Use Azure Data Lake Storage Learn How to Create Apps in Azure Active Directory Learn How to work with Flexible File Task Learn How to Create and Delete HDInsight Clusters on Azure Learn How to work with Azure SQLDW Task Learn How to work with Azure Data Lake Analytics Task Learn How to use PowerQuery Source Learn How to Create Tabular Model using SSAS Learn How to use Analysis Processing Task in SSIS Learn How to use Analysis Services Execute DDL Task in SSIS This course is ideal for individuals who are This course is for those people who want to Enhance their existing SSIS skills to the next level. It is particularly useful for This course is for those people who want to Enhance their existing SSIS skills to the next level.

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

Summary

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

Price: $69.99

Average Rating: 4.66

Number of Lectures: 89

Number of Published Lectures: 89

Number of Curriculum Items: 89

Number of Published Curriculum Objects: 89

Original Price: $39.99

Quality Status: approved

Status: Live

What You Will Learn

Learn How to read data from multiple sheets of a single Excel File Source

Learn How to work with Slowly Changing Dimension (SCD) to maintain Historical Data

Learn How to download Hadoop and Set Up on a local system

Learn How to work with Hadoop File System (HDFS) From SSIS

Learn How to work with Hadoop Hive Task

Learn How to work with Hadoop Pig Latin Script Task

Learn How to download and Install Oracle 11g

Learn How to perform ETL Operations with Oracle Database

Learn How to use OLEDBSource and OLEDBDestinations Tasks to connect to Oracle Database

Learn How to Create Azure Resource Groups

Learn How to Create Azure Storage Accounts

Learn How to upload Files to Azure Blob and Download Files from Azure Blob Containers

Learn How to Create and Use Azure Data Lake Storage

Learn How to Create Apps in Azure Active Directory

Learn How to work with Flexible File Task

Learn How to Create and Delete HDInsight Clusters on Azure

Learn How to work with Azure SQLDW Task

Learn How to work with Azure Data Lake Analytics Task

Learn How to use PowerQuery Source

Learn How to Create Tabular Model using SSAS

Learn How to use Analysis Processing Task in SSIS

Learn How to use Analysis Services Execute DDL Task in SSIS

Who Should Attend

This course is for those people who want to Enhance their existing SSIS skills to the next level.

Target Audiences

This course is for those people who want to Enhance their existing SSIS skills to the next level.

SSIS is an enterprise-level Extract,Transform and Load (ETL) Development   tool.

SSIS is one of the most powerful application for moving data in and out of various databases and files.

SQL Server Integration Services is a platform for building enterprise-level data integration and data transformations solutions.

Integration Services can extract and transform data from a wide variety of sources such as XML data files, flat files, and relational data sources, and then load the data into one or more destinations.

You can use the graphical Integration Services tools to create solutions without writing a single line of code. You can also program the extensive Integration Services object model to create packages programmatically and code custom tasks and other package objects.

This course provides developers with a thorough knowledge in developing SSIS Packages with SQL Server 2016/2019/2022.

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.

This course provides step-by-step walk-throughs and demos that you’re encouraged to practice along with to enhance the learning process.

This course is broken down into 16 Modules with each module providing source code so that you can follow along with Kameswara Sarma Uppuluri.

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

Instructors

Kameswara Sarma Uppuluri | 25+ Years Of Experienced Corporate Trainer
Microsoft Certified Trainer

Rating Distribution

1 stars: 6 votes

2 stars: 17 votes

3 stars: 114 votes

4 stars: 514 votes

5 stars: 600 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!