4.34 out of 5
4.34
689 reviews on Udemy

Microsoft SQL Server Integration Services (SSIS) Training

Learn how to deal with loading of different kinds of data into SQL Server
Instructor:
Intelligence Guru
3,721 students enrolled
English [Auto-generated]
Helps to obtain a job as ETL developer
You can able to perform basic ETL(Extract Transform Load) tasks at your work
Gateway to obtain Microsoft Business Intelligence Certifications
You can analyze data and do marketing more effectively for a particular application
Build reports for any category of data

Now is your chance to learn Microsoft SQL Server Integration Services (SSIS) with this extensive course that will give you the confidence and skills to use this Business Intelligence tool. It will be the golden ticket to your success in this industry. You will learn the basics about the development tools and what they are capable of, clear instruction on how to handle various issues that you might face when designing your packages and how to overcome them. By the end of this course you will understand many basic concepts and how to perform data integration and transformation. This course also includes the process of cleansing data and how to get the end result after applying different transformations. It also gives some real world scenarios that you might face and what salary to expect from working as an SSIS/ETL developer.

By taking this course you will learn about:

  • Creating an Integration Services Project
  • Basic SQL Server Data Tools features
  • Creating Integration Services Tasks
  • Creating connections to and from an Integration Services Package
  • Writing data to a SQL Server database
  • Executing a package from SQL Server Data Tools
  • Creating a Foreach Loop and map Variables
  • Controlling Data Flow for multiple Flat Files
  • Changing a Flat File Connection using Expressions
  • Changing command-line application arguments using Expressions
  • Change Data Capture(CDC) database objects
  • Preparing data for CDC and performing Incremental loading
  • Most Familiar Data Transformations concepts

Introduction to SSIS

1
Introduction

Please find an attachment at resources section which can help you in understanding Introduction of SSIS

Creating a Package and Processing of Flat Files

1
Importing a Flat File into a SQL Server Database

Please find an attachment at resources section which can help you in understanding steps of creating this package

2
Importing Multiple Flat Files into a SQL Server Database

Please find an attachment at resources section which can help you in understanding steps of creating this package

3
Exporting Results into a Flat File

Please find an attachment at resources section which can help you in understanding steps of creating this package

Incremental Loading

1
Configuring Change Data Capture (CDC)

Configuring the Change Data Capture and see the details of configuration in attached document

2
Incremental Loading using Change Data Capture (CDC)

This video covers on how to use pre-configured CDC to perform Incremental Loading

Excel Handling

1
Dealing of Excel Connection Manager Driver Issues

Part-I deals on how to handle Excel Connection manager driver settings which is a necessary step in loading of excel files. Go through the attached resource document

2
Loading of Excel Files and Examining the Results

Part-II deals about loading of excel files after fixing Excel Connection Manager driver issues and displaying results after successful execution

Data Transformations

1
Union ALL
2
LookUp
3
Sorting
4
Re-directing Unmatched rows
5
Data Conversion

Please download the attachment from resource section. It defines each step of creation

6
Derived Column
7
Conditional Split

Error Handling

1
Configuring DFT Error Output and Redirecting bad data
2
Loading error records into a table with specific error description(Script Task)
3
Error Handling by using Event Handlers

Package Deployment

1
Deploying a package using SSDT and executing it on SQL Server
2
Deploying a package using command-line and executing it on File System

Conclusion

1
Resume Tips
You can view and review the lecture materials indefinitely, like an on-demand channel.
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!
4.3
4.3 out of 5
689 Ratings

Detailed Rating

Stars 5
288
Stars 4
257
Stars 3
111
Stars 2
19
Stars 1
14
2420aed982b312d3ca2de0eef021b3d5
30-Day Money-Back Guarantee

Includes

2 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion