Learn ETL using SSIS
What you will learn
At the end of this course, students will be able to deploy and automate process to extract data from various sources, transform them so that the data can be queried, and finally load them into a warehouse using SQL Server Integration services.
They would be able to apply these concepts in their day to day projects, where there might be a need to move data across systems and store it in a friendly query-able format for reporting and analysis
Charts
Comidoc Review
Our Verdict
This 4.54-rated Udemy course with nearly 69k subscribers offers a comprehensive, clear, and concise introduction to SQL Server Integration Services (SSIS). While some portions may appear slightly outdated—primarily in relation to Visual Studio versions—the strong foundational knowledge and solid understanding of the tool more than compensate. However, be aware that certain aspects could challenge those without pre-existing familiarity with similar development environments, as there are instances when assumed foundation skills might leave beginners seeking additional clarification. Although hands-on exercises could further enhance engagement, the course's strengths outweigh any minor shortcomings, ultimately providing valuable insight into utilizing ETL processes and SSIS for your data management needs.
What We Liked
- Covers the fundamentals of SSIS clearly and effectively, serving as a solid foundation for those new to the tool
- Instructor explains concepts with clarity and structure, allowing for easy comprehension and follow-along throughout the course
- Displays in-depth knowledge regarding SQL, making it an insightful learning experience even for experienced developers seeking a refresher
- Well-organized and eloquently delivered, enabling learners to grasp complex ideas and projects by the end of the course
Potential Drawbacks
- Some sections might be slightly outdated in terms of software versions, which could cause minor confusion for beginners
- Assumes foundational knowledge without explicitly mentioning prerequisites, potentially causing some difficulty (especially regarding Visual Studio and SQL Server Management Studio)
- The course moves at a rapid clip, expecting learners to adapt quickly; there may be times when further elaboration on specific steps would be helpful
- Lacks production environment integration guidance; additional information on running packages outside the VS environment would be beneficial