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

Apr 18, 2025 - 17:48

0 0

Mastering SQL Server 2016 Integration Services (SSIS)-Part 2, 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.

What you’ll 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

Who this course is for

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

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

Publisher : Udemy
Teacher : Kameswara Sarma Uppuluri | 25+ Years Of Experienced Corporate Trainer
Language : English
Level : All Levels
Number of Course : 89
Duration : 13 hours and 21 minutes

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

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

Requirements

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

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