Skip to main content

IT Courses – Microsoft SQL Server 2016 and 2017 Integration Services

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).

Book Now

Course Summary

Subject Area: IT, Digital Skills and Computer Science
Adult and Community
Location: Ilkeston
Full Time or Part Time: FT
Level: 2
Number Of Years:
Interview Required?: N
Ilkeston

Apply now at: https://www.derby-college.ac.uk/course/it-courses-microsoft-sql-server-2016-and-2017-integration-services
QR Code

Course Information for Students

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 SELECT, UPDATE, INSERT and DELETE statements.

• 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 and packages

• Manage and secure Integration Services projects and packages

• Understand basic data warehousing concepts

• Manage changing data with the SSIS CDC components

For more information contact the Roundhouse Thinking team on 01332 836 638 or enquiries@roundhousethinking.co.uk

Course Information for Employers

If you are an employer and would like to know more about the apprenticeships and professional training we deliver or how you can get involved in co-creating and co-delivering curriculum, please contact us via email on businessenquiries@derby-college.ac.uk, call us on 01332 387 421 or visit our employer pages here.

Career Information

Sorry - no lmi data
More Careers Information at: https://www.derby-college.ac.uk/career-pathways
QR Code

DCG Success Stories

Discover how our students have achieved success. Their hard work and dedication to learning has enabled them to succeed in rewarding careers or progress onto higher education.

role model

We encourage progress and aspirational outcomes by guiding people onto learning pathways that lead to positive destinations. Our students have gone on to achieve great things since leaving the College. We would like to share some of their inspiring success stories with you.

View Role Models

online application form

Get Started...

Check availibility and book now on this course.

Book Now

Course Information Last Updated On: November 22, 2021 3:57 pm