Save for later

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

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.

This course provides developers with a thorough knowledge in developing SSIS Packages with SQL Server 2016.

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.

This course provides step-by-step walk-throughs and demos that you're encouraged to practice along with to enhance the learning process.

This course is broken down into 21 Modules with each module providing source code so that you can follow along with Kameswara Sarma Uppuluri.

Get Details and Enroll Now

OpenCourser is an affiliate partner of Udemy and may earn a commission when you buy through our links.

Get a Reminder

Send to:
Rating 4.2 based on 438 ratings
Length 10.5 total hours
Starts On Demand (Start anytime)
Cost $15
From Udemy
Instructors Kameswara Uppuluri, Kameswara Sarma Uppuluri
Download Videos Only via the Udemy mobile app
Language English
Subjects Data Science Programming
Tags Databases Development Database Design & Development

Get a Reminder

Send to:

Similar Courses

What people are saying

easy to follow

are not always present So far ,so good .The intro has been on point, detailed and very easy to follow.Truly excited to get on this journey Overall I felt the course gave a good high level overview of SSIS.

Easy to follow and understandable.

The videos are easy to follow and I enjoyed the learning experience.

I think that this is a complete course on SSIS that is easy to follow and presents all what an SSIS developer need to learn.

I really liked the easy to follow examples.

Very easy to follow.

Easy to follow.

Very Informative and easy to follow.

Very good pace and easy to follow.

Read more

step by step

The videos were sequenced in a nice way that helped me a lot to understand each and every topic step by step.Rich in content and it covered almost every topic from SSIS.I will highly recommend this course who are looking for a one stop material for SSIS.

Great pace, great delivery to the point, and excellent step by step in clear digestible parts.

the installetion sucks is not clear, it assumes we know everthing, should go step by step the course was extent but only the minimum requirements for each example.

Clearly demonstrated with step by step instructions Can have better examples.Simple and Nice.

There's enough exercises, step by step guidance makes it very good for even newbies.

Fantastic course very comprehensive with step by step and real world demonstrations.

He is very easy to understand and showed very easy step by step instructions making the lesson learning a breeze.

Very very nice step by step course, well explained, and easy to understand.

This course is very informative and detailed Step by step learning process clearly explained.

Totally up to date and detailed walk through on how to get everything setup Simple and easy to understand Good step by step explaination Good explanation, with good speed Good course Very good so far.. A very informative course I did not realize I would have to upgrade my laptop just to get sql server 2016 to run.

very thorough explanation Easy to follow Very thorough step by step good The basics are very well explained As of now,it is very good.

Read more

recommend this course

I recommend this course.

I would recommend this course!

I strongly recommend this course whoever wants to dive into SSIS I liked that the course format was broken down into concept driven bite-size chunks, which made it easy to work through the lessons while balancing work and other obligations.

I highly recommend this course as either a top-up, an introduction or a refresher.

Will recommend this course to everyone who wants to transition into SSIS and those who are learning SSIS afresh alike!

Highly recommend this course if you want to be a expert in SSIS.

Read more

sql server

It is a good match, I do wish they walked you through SQL server 2019, but good information.

I work with SSIS everyday, and this course was able to show me several things I never knew I could do regarding Development in in Visual Studio and Deployments in SQL Server Catalog.

exccente course, will take some others ITS OK I am working as Data Engineer and mostly in SQL server relational database.

Mastering SQL Server 2016 Integration Services (SSIS) class was a good investment for me.

Kameswara is a very knowledgeable trainer who has broken down the use of SQL Server Integration Services to its smallest and simplest components.

I have taken a lot of online courses on SSIS and Data warehouse implementation in SQL Server in general but to be honest nothing comes close to this in terms of coverage and depth.

Very Precise and excellent demonstration so far I am able to practice with the flow and pace he is teaching and I am still at basics so at this moment,this is very helpful It would be great if you can provide link of downloading SQL server 2016 and Adventure DB, as currently I am facing issue because of that Great course.

But I do recommend some experience with SQL server for this course otherwise you can't fully understand it.

You could seemingly get the same level of value out of simply downloading SQL Server developer edition (which is free BTW) and fiddle around with it yourself.

Very clear and concise Informative Good this class still use sql server 2016.

Read more

so far so good

Till now good, but looking for some practical scenarios So far so good.

I just started but so far so good.

So far so good, I'm really learning somethings I didn't know.

Till now i am having a great experience Inrmation So far so good!

So far so good Thinks are clear.

Read more

like to see

I would like to see more in the future Amazing work by the author.

I'd also like to see some examples and practice using Environment variables as they are a MUST KNOW for real world applications, so you don't waste changing connection strings every time you wanna switch between production and development environments (plus the risk of forgetting one and running something in prod you shouldn't!)

would like to see how one can extract data from XML or JSON into a table as of now we are looking at simple scenarios..let me go through the complete course so that I can comment The beginning of each lecture is the same and very very redundant Mau som do curso Tópicos bem explicado.

just enough to understand, good pace, points out important stuff its nice but we would like to see more versatile data sources instead of the same source everytime.

Would like to see the course extended with a section on Slow Changing Dimensions and more strategies on how to deal with large amount of data processing.

Read more

real world examples

More real world examples for each step can be a added value.

Only lacks real world examples and end to end scenarios , otherwise great course!

Instructor could have made it more useful by citing real world examples and could have explained it through a project instead of explaining all objects one by one which makes this course bit dry.

I would like to have real world examples as well.

Read more

very knowledgeable

The presenter is clearly very knowledgeable in this subject.

Demonstrated all the components with simple examples The instructor is very knowledgeable and covers a lot of information.

Instructor is very knowledgeable and straight to the point.

Instructor is very knowledgeable and easy to understand.

Instructor very knowledgeable.

Read more

real life

My only concern is that it would have been better if there is a project towards the end that brings all the bits and pieces together to demonstrate how it is done in real life.

Would have been good to have some real life examples, e.g.

Sometimes examples too basic/not real life.

The features of SSIS are well explained, but they're all just short demonstrations that aren't really tied to each other with good, real life examples, which gives a lot of repetition (e.g.

I would've liked to see a scenario of an imaginative company who needed to have their data warehouse set up with specific rules so you would have real life situations reconstructed.

Read more

more advanced

Now i need a more advanced course about the properties of the components :-) Expected more as the deployment can be done through project model using ispac Great course!

I can't wait to delve into the more advanced topics.

In terms of the more advanced sections of the course, it would be helpful if the lecturer spends a bit more time explaining the different options and why one would, or would not selection the options Cours bien détaillé .

Could put more advanced details on the transformation.

Read more

well explained

Very well explained ... Nice Explaination stone left unturn....

very good Explanation well explained Nice job of preparing the lessons Not supportive The instructor is easy to understand and talks at a good pace.


An overview of related careers and their average salaries in the US. Bars indicate income percentile.

SSIS/SSAS Developer $66k

SQL Developer (SSIS, SSRS, Database) $67k


SSIS EDI Engineer $73k

Oracle Developer with SSIS $73k

SSRS/SSIS Developer $73k

SQL Developer - SSIS $75k

MS SQL/SSAS/SSIS Developer $75k

SQL / SSIS Developer $77k

SSIS/ETL Developer Lead $91k

SSIS Integration Engineer $92k

Product Manager - Data Packages Lead $111k

Write a review

Your opinion matters. Tell us what you think.

Rating 4.2 based on 438 ratings
Length 10.5 total hours
Starts On Demand (Start anytime)
Cost $15
From Udemy
Instructors Kameswara Uppuluri, Kameswara Sarma Uppuluri
Download Videos Only via the Udemy mobile app
Language English
Subjects Data Science Programming
Tags Databases Development Database Design & Development

Similar Courses

Sorted by relevance

Like this course?

Here's what to do next:

  • Save this course for later
  • Get more details from the course provider
  • Enroll in this course
Enroll Now