Microsoft SQL Server Integration Services (SSIS) Training (Udemy.com)

Learn how to deal with loading of different kinds of data into SQL Server

( 269 Reviews )

Created by: Intelligence Guru

Produced in 2017

What you will learn

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

Quality Score

Content Quality

Video Quality

Qualified Instructor

Course Pace

Course Depth & Coverage

Overall Score : 86 / 100

Course 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 this course is for:

People who are having basic knowledge about SQL
Students who wish to enter a Business Intelligence career

Time: 2.5h

Instructor Details

Intelligence Guru

4.3 Rating
269 Reviews

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

SQL in Motion (2017)

0.0 (0 Reviews)

Provider: Manning Publications
Time: 4h

$59.99

Introduction to SQL (2015)

4.7 (6 Reviews)

Provider: SQLBolt

Free

Intro to SQL: Querying and managing data

Intro to SQL: Querying and managing data (2015)

0.0 (0 Reviews)

Provider: Khan Academy
Time: 1h

Free

More Courses

Reviews

4.3

269 total reviews

5 star 4 star 3 star 2 star 1 star

Write a Review

By Surajkukunuri on 10/19/2020

good

By Jorge Roberto Lopes Izabel on 10/17/2020

neste mdulo importing a flat file into a SQL Server eu tirei muitas dvidas que tinha respeito da ferramenta.

By Mayank Jindal on 10/10/2020

Nice Course

By VENKATACHALA NAGA SURYA GANESH MATURI PA on 10/5/2020

very easy to learn for beginners

By Minnaam Mazhar on 9/26/2020

very good course for the basic understanding of SSIS

By Amol Gopal Mohite on 9/15/2020

Training videos' are Nice but sound is very low.

By Cara Ysabel Hufano on 9/12/2020

I wished they have provided the sample data used in the examples so we can follow along.

By Rashed Bahlool on 9/5/2020

I would highly suggest adding the source files for each lecture in order to perform the same steps and verify the results. Without it, the course is more like a step-by-step manual to perform tasks rather than a "class".

By Michael on 8/13/2020