Online or onsite, instructor-led live SSIS (SQL Server Integration Services) training courses demonstrate through interactive hands-on practice the fundamentals and advanced concepts of SSIS.
SSIS training is available as "online live training" or "onsite live training". Online live training (aka "remote live training") is carried out by way of an interactive, remote desktop. Saskatchewan onsite live SSIS trainings can be carried out locally on customer premises or in NobleProg corporate training centers.
NobleProg -- Your Local Training Provider
Regina - Royal Bank Building
2002 11th Ave, Regina, Canada, S4P 0J3
Grow your business in one of Regina’s most prominent finance hubs. Build your base in the prestigious Royal Bank Building, home to several leading financial and professional services companies.
Impress your clients and colleagues with the building’s commanding city views before getting to work in stylish surroundings with plenty of natural light. You can also travel easily for work or pleasure, with the nearby Regina International Airport offering regular flights across Canada and beyond.
You'll be within a 10-minute drive of the University of Saskatchewan and Peter Zakreski Regional Park. This spa hotel is 0.1 mi (0.1 km) from Cielo and 0.4 mi (0.6 km) from Evelyn Edwards Park.
Prime Location in Regina's Financial District
Expand your business in the heart of one of Regina’s most prominent financial hubs. Establish your office in the prestigious Royal Bank Building, a landmark hosting top financial and professional services firms.
Impress clients and colleagues with stunning views of the city, then get to work in modern, light-filled surroundings designed for productivity. For business or leisure, enjoy easy access to the Regina International Airport, which offers frequent flights across Canada and beyond.
SQL Server Integration Services (SSIS) is a component of Microsoft SQL Server that provides a platform for data integration and workflow applications. It is used for data migration, warehousing, and transformation tasks.
This instructor-led, live training (online or onsite) is aimed at intermediate-level data professionals and developers who wish to focus on designing advanced SSIS data flows, transformations, and managing Slowly Changing Dimensions (SCD) for data warehousing scenarios.
By the end of this training, participants will be able to:
Design and implement robust data flows using SSIS.
Work with a variety of data sources, destinations, and transformations.
Implement Slowly Changing Dimensions (SCD) for handling historical data changes.
Deploy, execute, and troubleshoot SSIS packages effectively.
Format of the Course
Interactive lecture and discussion.
Lots of exercises and practice.
Hands-on implementation in a live-lab environment.
Course Customization Options
To request a customized training for this course, please contact us to arrange.
This instructor-led, live training in Saskatchewan (online or onsite) is aimed at beginner-level data professionals who wish to learn how to design, implement, and manage SSIS packages to perform data integration and transformation tasks.
By the end of this training, participants will be able to:
Understand the architecture and components of SSIS.
Design and implement ETL processes using SSIS.
Use SSIS tools to develop, deploy, and manage data integration solutions.
Troubleshoot and optimize SSIS packages for performance and reliability.
This instructor-led, live training in Saskatchewan (online or onsite) is aimed at beginner to intermediate-level developers and database administrators who wish to gain proficiency in SQL Server 2012 Integration Services.
By the end of this training, participants will be able to:
Understand the principles of ETL and the role of SSIS.
Create, deploy, and manage SSIS packages.
Design and implement Control Flow to define the flow of tasks in a package.
Implement Workflow and set up constraints for effective task execution.
Construct Data Flows to extract, transform, and load data.
Work with Variables and Containers to enhance package flexibility.
Manage Transactions to ensure data consistency.
Implement effective error handling and debugging techniques.
Set up Logging for tracking and monitoring.
Handle Slowly Changing Dimensions for managing changing data.
Deploy a Package for production use.
Implement Security measures to protect sensitive data.
Utilize Scripting to extend SSIS functionality.
Apply Best Practices for efficient and maintainable SSIS solutions.
Read more...
Last Updated:
Testimonials (1)
The thorough / hands-on knowledge the trainer has.
Pieter Peirs
Course - Introduction to SQL Server 2012 Integration Services (SSIS)
Online Microsoft SSIS training in Saskatchewan, SQL Server Integration Services training courses in Saskatchewan, Weekend MS SSIS courses in Saskatchewan, Evening MS SSIS training in Saskatchewan, SSIS instructor-led in Saskatchewan, SSIS classes in Saskatchewan, SSIS (SQL Server Integration Services) one on one training in Saskatchewan, SQL Server Integration Services (SSIS) boot camp in Saskatchewan, Evening SSIS courses in Saskatchewan, SQL Server Integration Services on-site in Saskatchewan, Online MS SQL Server Integration Services training in Saskatchewan, SSIS (SQL Server Integration Services) private courses in Saskatchewan, SQL Server Integration Services instructor in Saskatchewan, SQL Server Integration Services (SSIS) trainer in Saskatchewan, Weekend Microsoft SSIS training in Saskatchewan, SSIS (SQL Server Integration Services) instructor-led in Saskatchewan, SQL Server Integration Services (SSIS) coaching in Saskatchewan
