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

Learn How to Create SSIS Packages From Scratch Step By Step for SQL Server 2016/2019/2022

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

What Will I 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

Requirements

• SQL Server 2016/2017, SQL Server Data Tools (SSDT),SQL Server Management Studio,Microsoft Azure Free Trial Account

Target audience

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