Microsoft SQL Server Training | Accelerated SQL Server 2016 Integration Services in Teesside

Accelerated SQL Server 2016 Integration Services Course Outline

Module 1: SSIS Overview and Core Features

• Introduction to Business Intelligence (BI)
• Tools for Business Intelligence (BI)
• Introduction to Data Integration
• SSIS Features

Module 2: Data Warehousing

• Dimensional Modelling
• Dimensional Modelling Rules
• Data Preparation for Advanced Analytics

Module 3: SSIS Control Flow Objects and Features

• What is Control Flow?
• Control Flow Concepts
• Types of Control Flow Elements
• SSIS Control Flow Tasks
• SSIS Control Flow Containers
• Control Flow Objects
• Group or Ungroup Components
• Using the Control Flow to Orchestrate SSIS Execution

Module 4: Extracting, Transforming and Loading Data Using SSIS Data Flows

• SSIS Data Flow Task
• Data Flow Path
• Data Connection Managers
• Data Flow Components

Module 5: Working with Files, Importing and Exporting File Data

• File Connection Manager
• Add and Configure a Flat File Connection Manager
• Loading Data into Files
• Excel Connection Manager

Module 6: Optimising Data Extraction and Data Loading

• Change Tracking
• Change Data Capture

Module 7: Data Quality and Cleansing

• Data Quality
• Data Profiling
• Data Quality Services
• Fuzzy Lookup Transformation
• Data Profiling Task in SSIS

Module 8: Advanced Enterprise Information Management

• Script Task and Script Component
• Text Mining
• Advanced Analytics

Module 9: Dimension ETL with SSIS

• Dimension ETL Theory
• SQL Server Temporal Tables
• SSIS Slowly Changing Dimension Wizard
• Slowly Changing Dimension Transformation

Module 10: Fact ETL with SSIS

• Fact Table ETL Theory
• Advanced Fact Table Techniques

Module 11: Project Deployment Model: Execution and Reporting

• Pivot Transformation

Module 12: Processing SSAS Objects in SSIS

• SSAS Tabular and Multidimensional
• Tabular Model Designer
• DAX for Multidimensional Models
• Processing Methods in SSIS

Module 13: Project Deployment

• Project Deployment Model
• Create the SSIS Catalog
• Monitoring
• SSIS Master Package

Module 14: Package Deployment

• Package Deployment Model
• Deployment to the SSIS Package Store
• Monitor Running Packages

Module 15: Transactions and Restartability

• Using Breakpoints in SSDT
• Implementing Transactions in SSIS
• Using SQL Server Database Snapshots
• Restart Packages by Using Checkpoints
• Responding to Events

Module 16: Optimisation and Scalability

• Leveraging the Data Flow
• Transact-SQL
• Data Flow Tasks
• SSIS Optimisation Techniques
• SSIS Performance Troubleshooting

Who should attend this Accelerated SQL Server 2016 Integration Services Course?

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:

• ETL Developers
• Data Engineers
• Data Analysts
• Database Developers
• IT Administrators
• Business Analysts
• DevOps Engineers

Prerequisites of the Accelerated SQL Server 2016 Integration Services Course

There are no formal prerequisites for this Accelerated SQL Server 2016 Integration Services Training Course. However, a foundational understanding of database and SQL concepts would be beneficial for the delegates.

Accelerated SQL Server 2016 Integration Services Course Overview

The Accelerated SQL Server 2016 Integration Services Course is designed to provide an intensive, hands-on learning experience for database professionals. This one-day course delves into the core features and functionalities of SQL Server Integration Services (SSIS), enabling delegates to efficiently manage data integration and transformation tasks.

Proficiency in SQL Server Integration Services is crucial for Data Professionals seeking to enhance their capabilities in data warehousing, ETL (Extract, Transform, Load) processes, and data migration. This course is particularly beneficial for Database Administrators, Data Analysts, and Developers who aim to streamline their data management workflows and improve their technical proficiency in SSIS.

This 4-day training will provide delegates with comprehensive knowledge and practical skills through immersive exercises and real-world scenarios. Delegates will learn how to design and implement SSIS packages, automate administrative tasks, and troubleshoot common issues. The hands-on approach ensures that attendees can apply their newly acquired skills directly to their professional roles.

Course Objectives

• To understand the architecture and components of SQL Server Integration Services
• To design and develop SSIS packages for data integration
• To implement control flow and data flow in SSIS packages
• To manage SSIS package execution and security
• To troubleshoot and debug SSIS packages effectively
• To integrate SSIS with other SQL Server features

After completing the course, delegates will receive a certification validating their expertise in SQL Server 2016 Integration Services. This certification will enhance their professional credentials and demonstrate their capability to manage complex data integration tasks efficiently.

What’s included in this Accelerated SQL Server 2016 Integration Services Course?

• World-Class Training Sessions from Experienced Instructors
• Accelerated SQL Server 2016 Integration Services Certificate
• Digital Delegate Pack