« Go Back

IT Courses - Microsoft SQL Server 2016 and 2017 Integration ServicesMore Information »

Course Image

Location: Broomfield Hall

Interview: N

Course Summary

You 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 various transformations and
data sources/destinations (including SQL Server databases, flat files
and Excel). We also cover SSIS project and package management,
deployment, debugging, error handling and logging techniques. Our
training is enriched by illustrated examples and practical exercises.
Delegates 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 2017
(or earlier), and the use of SQL Server Management Studio, is assumed,
along with knowledge of the SQL query language, in particular the

Did you find the course information on this page useful?


This course is run at the Broomfield Hall Campus

broomfiled hall campus

About Broomfield Hall »

Aimee Woore

Aimee Woore

New qualification is “massive help” for assessor Aimee

Business Administration assessor Aimee Woore has found that taking the Level 4 Preparing to Deliver Apprenticeship Standards course at Derby College is helping her massively in her daily work.
Aimee, a sales and marketing co-ordinator for Kettering Borough Council, also delivers business admin training to staff across the borough via the ETF, the Education & Training Foundation.
And, since completing her course at Derby College's Academy of Professional Education, Training and Development, she has taken on an additional role – heading up a work experience programme for 16 to 18 year olds in Kettering – and has found her new qualification invaluable.
Aimee, who found the course online via the ETF, opted to take it at Derby College, rather than at another centre in London, and is pleased with her decision. She also welcomed the opportunity to be in a roomful of people in similar roles to her own but from a variety of different sectors and providers.

Taking the Derby College course has helped me massively in my job. The course was well structured, the facilities and materials were good and our tutors were excellent. The biggest thing I learned while on the course was teaching strategies, including hints and tips on the different options available. It was interesting to see our tutors demonstrate these options in their own teaching.

The techniques and strategies we were taught have been very helpful, both in my work and on a personal level. I thoroughly enjoyed the course and would like to use the credits to continue studying.


Go to top