PeopleCert, on behalf of Axelos
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
Courses
01344203999 Available 24/7
close
Press esc to close
close
Fill out your contact details below and our training experts will be in touch.
If you wish to make any changes to your course, please
log a ticket and choose the category ‘booking change’
close
One of our training experts will be in touch shortly to go over your training requirements.
close
Press esc to close
Back to Course Information
Back to course information
One of our training experts will be in touch shortly to go overy your training requirements.
One of our training experts will be in touch shortly to go over your training requirements.
Our Microsoft Certifications (Microsoft Partner)
course is accredited by Microsoft
Our Microsoft Certifications (Microsoft Partner)
course is accredited by Microsoft
Module 1: SSIS Overview and Core Features
Module 2: Data Warehousing
Module 3: SSIS Control Flow Objects and Features
Module 4: Extracting, Transforming and Loading Data Using SSIS Data Flows
Module 5: Working with Files, Importing and Exporting File Data
Module 6: Optimising Data Extraction and Data Loading
Module 7: Data Quality and Cleansing
Module 8: Advanced Enterprise Information Management
Module 9: Dimension ETL with SSIS
Module 10: Fact ETL with SSIS
Module 11: Project Deployment Model: Execution and Reporting
Module 12: Processing SSAS Objects in SSIS
Module 13: Project Deployment
Module 14: Package Deployment
Module 15: Transactions and Restartability
Module 16: Optimisation and Scalability
This Accelerated SQL Server 2016 Integration Services Training Course is designed for professionals who work with Data Integration, ETL development, and those who need to efficiently design and manage data workflows using SSIS (SQL Server Integration Services). This training course is beneficial for the following professionals:
There are no formal prerequisites for this Accelerated SQL Server 2016 Integration Services Course. However, a foundational understanding of database and SQL concepts would be beneficial for the delegates.
SSIS (SQL Server Integration Services) is part of the Microsoft SQL Server software data utilised for various data migration tasks. SQL (Structured Query Language) Server Integration Service is a quick and adaptable data warehousing tool applied to extract, transform, and load data. It presents easy to load the data from one database to a different database like Oracle, Excel file, SQL Server, etc. We can say that the SSIS tool is used for data migration and used to perform a wide variety of integration tasks and transformations. Many companies use SSIS because it assists them in joining data from multiple data stores and filling data to various objectives quickly and effectively. Having in-depth knowledge of SSIS is very important in this digital era. Individuals with advanced SQL knowledge are one step ahead of the rest and work as highly paid posts in various multinational investigation organisations.
This 4-day Accelerated SQL Server 2016 Integration Services training course provides delegates with a comprehensive knowledge of SQL Server Integration Services and its various features. This training will provide in-depth knowledge about how to add and configure a flat file connection manager. They will get to know about Excel connection manager, data quality and cleansing, dimension ETL with SSIS, SSIS slowly changing dimension wizard, and many more things. This course will be taught by our expert trainers who have years of experience in teaching technical courses.
This course will cover various essential topics, such as:
At the end of this training, delegates will be able to use SQL Server Integration Services and its feature effectively. They will extract, transform, and load data using SSIS data flow without facing any issues. They will also be able to restart packages by using checkpoints.
Why choose us
Our easy to use Virtual platform allows you to sit the course from home with a live instructor. You will follow the same schedule as the classroom course, and will be able to interact with the trainer and other delegates.
Our fully interactive online training platform is compatible across all devices and can be accessed from anywhere, at any time. All our online courses come with a standard 90 days access that can be extended upon request. Our expert trainers are constantly on hand to help you with any questions which may arise.
This is our most popular style of learning. We run courses in 1200 locations, across 200 countries in one of our hand-picked training venues, providing the all important ‘human touch’ which may be missed in other learning styles.
All our trainers are highly qualified, have 10+ years of real-world experience and will provide you with an engaging learning experience.
We only use the highest standard of learning facilities to make sure your experience is as comfortable and distraction-free as possible
We limit our class sizes to promote better discussion and ensuring everyone has a personalized experience
Get more bang for your buck! If you find your chosen course cheaper elsewhere, we’ll match it!
This is the same great training as our classroom learning but carried out at your own business premises. This is the perfect option for larger scale training requirements and means less time away from the office.
Our courses can be adapted to meet your individual project or business requirements regardless of scope.
Cut unnecessary costs and focus your entire budget on what really matters, the training.
This gives your team a great opportunity to come together, bond, and discuss, which you may not get in a standard classroom setting.
Keep track of your employees’ progression and performance in your own workspace.
You won't find better value in the marketplace. If you do find a lower price, we will beat it.
Microsoft Gold Learning Partner
Flexible delivery methods are available depending on your learning style.
Resources are included for a comprehensive learning experience.
"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"
Joshua Davies, Thames Water
Back to course information
We may not have any package deals available including this course. If you enquire or give us a call on 01344203999 and speak to our training experts, we should be able to help you with your requirements.
If you miss out, enquire to get yourself on the waiting list for the next day!
