Mastering SQL Server 2016 Integration Services (SSIS)-Part 1
What you will learn
Learn Data Migration Techniques
Learn How to work with various DataFlow Transformations
Learn How to work with various ControlFlow Activities
Learn How to use Configuration Files
Learn How to make Dynamic SSIS Packages
Learn How to do Event Handling
Learn How to work with WMI Tasks
Learn How to use MSMQ to pass messages between Packages
Learn How to improve the DB Performance by using Maintenance Plan Tasks
Learn How to Implement CheckPoints
Learn How to work with various Data Sources and Data Destinations
Charts
Comidoc Review
Our Verdict
Mastering SQL Server 2016 Integration Services (SSIS)-Part 1 is tailored to SSIS beginners seeking a solid foundation while providing relevant lessons for experienced ETL developers as well. The course's detailed explanations, exhaustive coverage of various scenarios and techniques, and real-world applications enable learners to gain the requisite proficiency for SQL Server versions 2016/2019/2022. However, be prepared for occasional repetition or minimal disorganization in some sections along with an increased focus on improving audio quality and providing complete resources throughout the course.\n\nWith a minor need for refinement, this course is well-suited to accommodate all skill levels looking to expand their knowledge of SQL Server Integration Services.
What We Liked
- Designed for both beginners and experienced ETL developers, providing a solid foundation in SSIS with real-world applications.
- Detailed explanations of DataFlow transformations, ControlFlow activities, Configuration Files, Event Handling, and more.
- Instructor's knowledge and expertise in SSIS are evident through clear explanations and well-structured examples covering various scenarios.
- Covers the latest SQL Server versions (2016/2019/2022) with over 11 hours of content, ensuring up-to-date learning experience.
Potential Drawbacks
- Occasionally repetitive or lacking sufficient organization in package design, causing minor confusion for learners.
- Some essential prep work and resources are not always provided, requiring manual setup efforts from learners.
- Limited instructor interaction on Q&A forums could hinder learners' personalized questions.
- Improvements needed in audio quality for some lessons and more explicit explanations of transitions between programs.