Microsoft SQL Server Integration Services

DURATION

4 Days

LOCATION

Exeter or onsite at your premises.

SOFTWARE PLATFORM

All Microsoft SQL Server versions

INTRODUCTION

This 4 day course is intended for IT professionals, business analysts, and developers who need to implement data transfer, or ETL (Extract, Transform, and Load), solutions by using Microsoft SQL Server Integration Services. Students will learn about the SQL Server Data Tools (SSDT) development environment to create SSIS projects and packages, work with Control Flow Tasks, and design Data Flows using a variety of transformations and data sources/destinations (including SQL Server databases, flat files, and Excel). Delegates will also learn about SSIS project and package management, deployment, debugging, error handling, and logging techniques. The training is delivered with plenty of illustrated examples and augmented with practical hands-on exercises.

With the course structure being fully modularised, customised versions of this course can also be devised and delivered. For example, clients interested in only the essentials of SSIS could attend just the first 3 days of the course, omitting the Advanced SSIS Concepts ordinarily covered on day 4.

PREREQUISITES

No prior knowledge of the subject matter is assumed. However, students should ideally be familiar with basic programming concepts, and understand the fundamental design of relational databases and data normalisation. Some prior working knowledge of SQL Server, and the use of SQL Server Management Studio, is assumed. Attendees should additionally be familiar with the SQL query language, in particular the SELECT, UPDATE, INSERT, and DELETE statements.

COURSE OBJECTIVES

Upon successful completion of the full course, students will be able to:

Understand the Role SQL Server Integration Services Plays in Business Intelligence
Create and Develop Integration Services Projects and Packages in SSDT
Understand and Implement Control Flow Tasks
Understand and Implement Data Flow Transforms and Components
Implement Logging
Debug and Implement Error Handling
Implement Checkpoints and Transactions
Deploy Integration Services Projects
Manage and Secure Integration Services Projects and Packages
Understand Basic Data Warehousing Concepts
Manage Changing Data with the SSIS CDC Components
Understand the Role of Data Quality Services (DQS)
Understand the Role of Master Data Services (MDS)

To BOOK

For more information or to book onto our Microsoft SQL Server Integration Services training course please contact us on 01392 824 022 or email training@amesolutions.co.uk.

If there is a Microsoft SQL Server course that is not listed on our site, that you are interested in attending then please let us know and we can arrange one to one training onsite with our Trainer.

Still not convinced?
We can help you!

Fill out the form below and one of our IT specialists will contact you.

Testimonials

Force Cancer Charity

We are delighted with the service we receive from AME. Their team is highly professional and personable and their support and maintenance contract works extremely well for us as a small organisation.

C G Fry & Son Ltd

It has been a pleasure to work with the AME team who are professional, reliable and very competent at their jobs. They always provide great communication when we log a support call and when they come onsite. We would not hesitate in recommending AME.

Pathfinder Homes

The AutoCAD course has been better than I imagined. I really feel as though I have made some key skills and am looking forward to putting them into practice. Andrew was an excellent trainer, he was very informative, helpful and made it a good experience.

J. Wippell & Co Ltd

We have every confidence in recommending AME to other organisations that require expert I.T. advice, support, software development and training.

Devon & Cornwall Police

Excellent Microsoft Sharepoint course which provided comprehensive coverage of the Sharepoint site. Particularly impressed that we were able to explore an area of our business in such detail. The Trainer Andrew was professional and friendly.

Exeter Golf & Country Club

Steve and Simon can be proud of the manner in which all the team represent AME. They are professional, friendly, knowledgeable, and efficient and they get on really well with all of our employees. I have no hesitation in recommending AME to other companies.

South West Water

We have a long standing relationship with AME, who provide our employees with IT software training. They are efficient at arranging courses, professional at delivering them and sensitive to delegates’ learning styles. We recommend AME to any business looking for an excellent training provider.

Dart Marina Hotel & Spa

We would like to thank the team at AME for the excellent technical support we receive, and the professional IT advice you provide for us. We have no hesitation in recommending AME to other companies requiring professional IT support and consultation.

The Cavanna Group

The Directors of the Cavanna Group are so impressed with the knowledge, ability and above all the dedication shown by AME Solutions. We have no hesitation in recommending AME Solutions as an IT support provider, and we are very happy with the service they provide.

Saunton Golf club

The AME technical team are brilliant with my staff, and any support calls have been handled in an efficient and customer orientated way. It’s a pleasure to work with AME.

St. Pauls Dental Practice Ltd

AME Solutions provide us with an IT team of approachable, knowledgeable, real people that it is a pleasure to do business with.

After receiving commendation from one of their existing clients, we contacted AME for an overall review of our standing IT infrastructure. Having outgrown our current IT support we were looking for an established company who could cover our requirements now and through potential future development.