We can host this training at your preferred location. Contact us!

Design, develop, deploy, and operate SQL Server Integration Services (SSIS) solutions.

Developed in-house by Lucient, the Integration Services (SSIS) course focuses on developing and managing SSIS 2016 in the enterprise. In this course, you will understand how to design, develop, deploy, and operate SSIS solutions—this involves ETL solutions (extraction, transformation, and loading) from source systems extractions, data integration, SSIS server administration and package execution.

What Will I Learn?

In this course you will learn how to create and develop new SSIS projects and package and determine when to use project mode versus, how to apply SSIS to file and data managemen, to understand and apply ETL Concepts in SSIS including dimensions and fact table ETL and loading SSAS dimension and cubes and how to administer SSIS for server deployment and production execution.

Basic experience in business intelligence solutions and SQL Server
No prior experience with SQL Server SSIS is required

Create and develop new SSIS projects packages.
Apply SSIS to file and data management.
Loading SSAS dimensions and cubes.
Determine when to use projects mode versus.
Understand and apply ETL concepts in SSIS.
Administer SSIS for sever deployment and production execution.

Module 1. SSIS Overview and Core Features

Introduction to Business Intelligence
Microsoft tools for BI
Introduction to data integration
SSIS features overview
Lab 01: SSIS Overview and Core Features

Module 2. Data Warehousing

Dimensional modeling
Optimizing a dimensional database
Data preparation for advanced analytics
Lab 02: Preparing a DW
Module 3. SSIS Control Flow Objects and Features
What is Control Flow
Control Flow Concepts
Control Flow Objects
Control Flow Features
Lab 03: Using the Control Flow to Orchestrate SSIS Execution

Module 4. Extracting, Transforming and Loading data using SSIS Data Flows

The SSIS Data Flow Task
Data Flows and Data Paths
Data Connections and Connection Managers
Data Flow Components
Lab 04: Using Data Flows to Perform Data Movements in SSIS
Module 5. Working with Files, Importing and Exporting File Data
Using SSIS to Automate File System Maintenance
Extracting Data from Files
Loading Data into Files
Excel Considerations
Lab 05: Working with Files in SSIS

Module 6. Optimizing Data Extraction and Data Loading

Data Extraction Optimization Essentials
Determining the „Delta“
Change Tracking
Change Data Capture
Data Loading Optimization Essentials
Lab 06: Using Change Data Capture in SSIS Data Flows

Module 7. Data Quality and Cleasing

Data quality
Data profiling
Data Quality Services
Fuzzy matching
Lab 07: Data Profiling and Cleansing

Module 8. Advanced Enterprise Information Management

Script task and Script Component
Text mining
Advanced Analysis and SSIS
Lab 08: Validating Data against Regular Expressions

Module 9. Dimension ETL with SSIS

Dimension ETL Theory
SQL Server Temporal Tables
SSIS Slowly Changing Dimension Wizard
Custom Dimension ETL
Lab 09: Dimension ETL with SSIS
Module 10. Fact ETL with SSIS
Fact Table ETL Theory
Data preparation for fact tables
Advanced concepts
Lab 10: Fact ETL with SSIS

Module 11. Project Deployment Model: Execution and Reporting

Power Pivot
Power Query
Lab 11: Power Query
Module 12. Processing SSAS Objects in SSIS
SSAS tabular and multidimensional
Processing methods in SSIS
Dynamic processing and partition creation
Lab 12: Analysis Services Processing

Module 13. Project Deployment

Project Deployment Model
Deployment to the SSISDB Catalog
Administration, Security, Configuration
Execution
Monitoring
The Master Package Concept
Lab 13: SSIS Project Deployment, Configuration, Execution, and Monitoring

Module 14. Package Deployment

Package Deployment Model
Deployment to the SSIS package store
Administration, Configuration, and Security
Execution
Monitoring and Logging
Lab 14: SSIS Package Deployment, Configuration, Execution, and Monitoring

Module 15. Transactions and Restartability

Using Breakpoints in SSDT
Implementing Transactions in SSIS
Using SQL Server Database Snapshots
Restartability of SSIS Packages
Responding to Events
Lab 15: Using Transactions and Checkpoints in SSIS Packages

Module 16.Optimization and Scalability

Leveraging SSIS and Transact-SQL
Data Flow Engine Internals
SSIS Optimization Techniques
SSIS Performance Troubleshooting
Lab 16: Optimizing SSIS Packages for Performance

Why have you chosen us?

I have attended a training from Bilginc IT Academy before and I was satisfied.

I have attended a training from a different provider and it was not helpful.

Other

How many employees do you have in your IT department?

0 – 50

50 – 250

250 – 1000

1000+

Accelerated SQL Server Integration Services Training Course in Norway

The Nordic country Norway, is in Northern Europe. Known for its stunning natural beauty, including fjords, mountains, and forests, Norway is also famous for its high standard of living and strong social welfare system. Norway's capital and largest city is Oslo. Tromsø, Bergen, Trondheim and Stavanger are the other tourist attracting cities of Norway.

Norway is a constitutional monarchy with King Harald V as the head of state. The country has a population of 5,425,270 as of January 2022. Norway is a relatively small country and has a relatively low population density, with much of its land area covered by forests, mountains, and fjords. Despite its small size, Norway is known for its rich cultural heritage, strong economy, and stunning natural beauty, which attracts millions of visitors every year. This Nordic country is also known for its winter sports, such as skiing and snowboarding, and is a popular destination for outdoor enthusiasts.

Norway has a long history of invention and is home to numerous more top-tier tech firms and research facilities, such as; Kongsberg Gruppen, Telenor, Atea, Evry and Gjensidige Forsikring.

Due to the country's high latitude, there are large seasonal variations in daylight. From late May to late July, the sun never completely descends beneath the horizon. Which attracts many tourists around the world to see the "Land of the Midnight Sun". Tourists mainly visit Sognefjord, Norway's Largest Fjord, Pulpit Rock, one of the most photographed sites in Norway and of course the capital; Oslo.

Oslo is considered the business center of Norway. It is the country's largest city and the capital of Norway. The city is home to many of Norway's largest and most important companies, as well as several international organizations and research institutions. Additionally, the city is a popular tourist destination, known for its scenic location on the Oslo Fjord, its many museums and cultural attractions, and its vibrant nightlife and dining scene. Some of the most popular museums in Oslo are The Norwegian Museum of Cultural History, The Nobel Peace Center, The National Museum of Art, Architecture, and Design, The Munch Museum and The Vigeland Museum.

Accelerated SQL Server Integration Services Training in Norway

Upcoming Trainings

Accelerated SQL Server Integration Services Training in Norway

Prerequisites

What You Will Learn

Outline

Upcoming Trainings