Skip to content
UdemySQLPaid courseIntermediate levelCertificate

SSIS Real World Scenarios & Projects : Tricks of the Trade (Udemy.com)

Learn Microsoft Business Intelligence SQL SSIS Tools & Package with ETL in Data Warehouse Step by Step via SSDT in MSBI

Created by: Vikas Munjal

Last updated December 2024

icon
What you will learn

  • Three Real World Scenario Based Projects
  • Expressions
  • Parameters
  • Debugging and Troubleshooting
  • Project Deployment

How it compares

Against the other 388 rated Udemy courses in SQL on CourseDuck:

  • Rating4.6 out of 5higher than 69% of them
  • Reviews382#233 of 389 by number of reviews
  • Length6.2 hoursshorter than 50% of them
  • Last updatedDecember 2024more recently than 63% of them

icon
Course Description

This Microsoft SQL Server SSIS is an intermediate level training course and it is the part of MSBI. You have to have the knowledge of basic tools and package creation. This SQL Server Integration Services course using SSDT contains three projects along with other tricks based on real world scenarios. All the projects are developed step by step. In one project you can learn how to perform ETL operation for the data warehouse using SSIS as well . The contents of this  online SSIS business intelligence video tutorial on Udemy as follows.

How to use Temporary Table in SSIS Package

Transferring Data from OLTP to Staging Table

Transferring data from Staging to Datawarehouse

Testing Metadata of the files and Loading the data

How to execute Foreach Loop Fixed Number of Times

SSIS Expression to get the File Name from the complete File Path

SSIS Expression to separate Name and Date Component of a file

YYYYMMDD date format using SSIS expression

Compress and Uncompress Folder using Winrar in SSIS

Parameter Settings of the Project

Testing the existence of Compressed File

Extracting ZIp File From Shared Folder to Local Processed Folder

Testing Date Component of each file with the Current Date

Dynamically Deciding which file to load in which table

ETL Operations

ETL with Lookup Option

Shared Folder Transfer and Naming Conventions

Debugging and Troubleshooting SSIS Packages

Breakpoints , Watch Windows and Data Viewer

Troubleshooting Problematic Records Using Data Flow Paths

Troubleshooting with Precedence Constraints

Deploying the Packages to Integration Services Catalog

Setting up Test and Production Environment

Automating the Package Execution and Checking the Reports of Execution


icon
Udemy Discount

The discount is applied through our link. Open the course from here and Udemy's current promotional price is applied at checkout on most courses, no code to type.

Some courses are excluded from Udemy's promotions. If the price does not drop, clear your browser cookies and use the button again.

icon
Instructor Details

Vikas Munjal

With over 18 years of rich experience in the realm of data management and analytics, Vikas Munjal has established himself as a trusted consultant and educator for businesses of all sizes. Residing in the vibrant city of Delhi, India, he has carved a niche for himself as a self-employed professional dedicated to imparting invaluable knowledge in the field of SQL Server, Microsoft Business Intelligence, Python and the cutting-edge domain of Generative AI Engineering (LangChain & RAG).

Throughout his career journey, Vikas Munjal has donned various roles, each contributing to his extensive expertise in the domain. Leveraging his deep foundation in data structures and analytics, Vikas has naturally expanded his focus to the future of data applications, becoming a specialist in Generative AI, utilizing frameworks like LangChain to build sophisticated, data-aware Retrieval-Augmented Generation (RAG) systems. His passion for teaching and sharing knowledge led him to transition into the role of a Corporate Trainer and Consultant, where he has excelled in imparting his wealth of experience to eager learners.


icon
More courses by Vikas Munjal

$19.99

$12.99

$69.99

icon
More SQL courses

$94.99

$16.99

$12.99

$13.99

$10.99

$34.99

icon
Reviews

4.6

382 ratings on Udemy

Select a bar to show only those reviews.Select the bar again to show every rating.

By Jennifer Hill on 4/30/2026

The course description is spot-on. You should have a solid grasp of the fundamentals of connection managers, data flow with source/destination configuration, variables, etc. The projects in this course are interesting and the concepts are explained very well. The presenter encounters a few errors that he troubleshoots off-video, then presents the fix in a subsequent video. This is great real-world experience. I'm very glad I bought this course and will run through the projects multiple times.

By J.Zhang on 6/27/2024

Very good course. I have no previous knowledge in SSIS and can follow it easily. Very practical and detailed information about all the steps. You can also learn a little bit C# in this course. It is not that hard. This teacher did an excellent job. It is absolutely a great investement for my brain to join this course!

By Dhruba Khanal on 1/20/2024

I completed my SSIS course with Vikas Munjal through Udemy platform and I was very impressed with the quality of the course. The instructor was knowledgeable and engaging, and the course content was well-organized and easy to follow. I learned a lot about ETL advance data tools, and I feel much more confident in my ability to extract data from sources. I would highly recommend this course to anyone who is interested in SSIS. The only suggestion I have for improvement is to add more quizzes throughout the course to help reinforce the material. Additionally, I would suggest breaking down the project into smaller packages to make it easier to understand which variable belongs where. Thank you for providing such a great learning experience!

By Man Tsui on 10/20/2023

Very detail, this is exactly what I'm looking for. This course is perfect for students who are familiar with sql querying and wants to learn more about the ETL process, table maintenance and etc. My background: I'm a financial analyst with 10 years of sql querying experience and 5 years of Tableau experience.

By John Ott on 3/4/2023

More of an intermediate course, and learning a ton. No always easy. Vikas is one of the best instructors on Udemy. He takes the time to explain the concepts and then provides really good examples for you to work through. Work through the examples with Vikas and you will learn a lot.

By Bucur Emil Constantin on 11/26/2022

Great Info and I appreciate the guy for putting the effort to summarize it. It was what I need, although I don't think this is an intermediate level, is more like an upper beginner. Also at the first, I struggle a little bit to understand what he was saying but is ok. So overall I give 4 out of 5 stars.

By Darshan Joshi on 9/10/2022

There aren't many SSIS Courses around but this is definitely one of the best on Udemy, way better than the Phillip burton SSIS Intro course. I'm glad that the instructor takes us through some real world use cases and shows us so much. I do wish that he went over things like Checkpoints, all of the Tasks in control flow and data flow but I understand that there's a lot you can do in SSIS and maybe they didn't have the time to make a course that is longer. Also some of the resources he gives for the course could be better organized because some of the code to create a table in SQL Server was missing and some of the code for a C# script task was missing. Overall this is probably the best SSIS Course you'll find on Udemy so I highly recommend it if you need to learn SSIS for your role. I hope this instructor makes some more advanced SSIS courses because I would definitely buy them.

By Rebecca Starr on 1/3/2021

I have been a SQL Developer for over 16yrs, but have dabbled very little in SSIS. Many courses cover what the various functions (data flows and control flows) do, which is very useful. However, the real learning is applying your knowledge to real world scenarios, and identifying what approaches are more applicable than others. This course does just that. The instructor is clear, concise and easy to follow. The content is very relevant, and the instructor takes you through it step by step, making constant reference as to why he uses that approach. Very very useful.

By Gavin Gunawardena on 6/16/2020

As a professional who does some ETL work and is wanting to incorporate more SSIS into my repertoire, I'm liking this class so far. I'm only halfway through but so far he's shown real world scenarios, best practices on how to tackle these, how to get past common issues, and general best practices for making packages flexible and useful.

By Ruben Madamba on 5/24/2020

I really liked the way he explained the errors encountered during execution of the package. He pointed out how to fix the errors that may be caused within the data flow, control flow, or the package itself.

Showing all 10 reviews on CourseDuck

Read all 382 reviews on Udemy

icon
Quality Score

No CourseDuck member has rated this course yet. Taken it? Give each part a thumbs up or down.

Content Quality
/
Video Quality
/
Qualified Instructor
/
Course Pace
/
Course Depth & Coverage
/

Overall Score : 92 / 100