Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Microsoft SQL Server Integration Services (SSIS) Training to your Wishlist.

Add to Wishlist

Microsoft SQL Server Integration Services (SSIS) Training

Learn how to deal with loading of different kinds of data into SQL Server and earn a Job $90,000/Yr
Bestselling
4.3 (238 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,850 students enrolled
Last updated 5/2015
English
$10 $35 71% off
3 days left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2.5 hours on-demand video
  • 2 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
Helps to obtain a job as ETL developer for $90,000/Yr
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
View Curriculum
Requirements
  • Need to have good PC
  • If possible have SQL Server 2008/2012 on your machine but not mandatory
Description

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

Who is the target audience?
  • People who are having basic knowledge about SQL
  • Students who wish to enter a Business Intelligence career
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 21 Lectures Collapse All 21 Lectures 02:23:00
+
Introduction to SSIS
1 Lecture 04:31

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

Preview 04:31
+
Creating a Package and Processing of Flat Files
3 Lectures 31:31

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

Preview 11:43

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

Importing Multiple Flat Files into a SQL Server Database
09:25

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

Exporting Results into a Flat File
10:23
+
Incremental Loading
2 Lectures 20:00

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

Configuring Change Data Capture (CDC)
07:44

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

Incremental Loading using Change Data Capture (CDC)
12:16
+
Excel Handling
2 Lectures 12:33

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

Preview 05:35

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

Loading of Excel Files and Examining the Results
06:58
+
Data Transformations
7 Lectures 28:33
Union ALL
03:18

LookUp
04:52

Sorting
03:20

Re-directing Unmatched rows
03:22

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

Data Conversion
03:42

Derived Column
04:09

Conditional Split
05:50
+
Error Handling
3 Lectures 25:44
Configuring DFT Error Output and Redirecting bad data
08:25

Loading error records into a table with specific error description(Script Task)
05:56

Error Handling by using Event Handlers
11:23
+
Package Deployment
2 Lectures 12:36
Deploying a package using SSDT and executing it on SQL Server
05:49

Deploying a package using command-line and executing it on File System
06:47
+
Conclusion
1 Lecture 07:32
Resume Tips
07:32
About the Instructor
4.3 Average rating
237 Reviews
1,850 Students
1 Course

Business Intelligence Guru is a cooperative company and a top rated business skills instructor. It offers relevant and timely content delivered by proficient instructors. Thousands of students spread all across the globe have benefitted from BI Guru’s convenient delivery methods and formats. . We mainly focus on delivering courses like Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), Analysis Services (SSAS) and T-SQL Programming. The courses are formatted in high quality videos, taught using practical examples. Our Instructors are subject matter experts in the IT industry having around 10 years of Business Intelligence experience in public and private sectors. They specialize in Database Programming, Integration Services and Reporting Services development. Now we are hosting SQL BI Guru’s videos too.

Report Abuse