Do you Need Live Online Training? Do you not have Time for Live Online? Do you Want to Start Immediately? Koenig's Flexi can help You.

Flexi is a Video Recording of Live Online + Official Courseware + Hands-On-Labs + Qubits Test

Flexi is a Unique Union of Live Online and On-Demand Learning Options.
Live Online
On Demand

Implementing a SQL 2016 Data Warehouse (SSIS)
Power Packed 15:00 Hours (Edited from 40 hours of video content) Recorded on 11-Feb-22

Includes 200+ Tests Questions (Qubits42)
Module 1: Introduction to Data Warehousing
  • Lesson 1: Overview of Data Warehousing
  • Lesson 2: Considerations for a Data Warehouse Solution
  • Lab: Exploring a Data Warehousing Solution
  • Lesson 1: Considerations for Data Warehouse Infrastructure
  • Lesson 2: Planning Data Warehouse Hardware
  • Lab: Planning Data Warehouse Infrastructure
  • Lesson 1: Data Warehouse Design Overview
  • Lesson 2: Designing Dimension Tables
  • Lesson 3: Designing Fact Tables
  • Lesson 4: Physical Design for a Data Warehouse
  • Lab: Implementing a Data Warehouse
  • Lesson 1: Introduction to Columnstore Indexes
  • Lesson 2: Creating Columnstore Indexes
  • Lesson 3: Working with Columnstore Indexes
  • Lab: Using Columnstore Indexes
  • Lesson 1: Advantages of Azure SQL Data Warehouse
  • Lesson 2: Implementing an Azure SQL Data Warehouse Database
  • Lesson 3: Developing an Azure SQL Data Warehouse
  • Lesson 4: Migrating to an Azure SQL Data Warehouse
  • Lesson 5: Copying Data with the Azure Data Factory
  • Lab: Implement an Azure SQL Data Warehouse
  • Lesson 1: Introduction to ETL with SSIS
  • Lesson 2: Exploring Source Data
  • Lesson 3: Implementing Data Flow
  • Lab: Implementing Data Flow in an SSIS Package
  • Lesson 1: Introduction to Control Flow
  • Lesson 2: Creating Dynamic Packages
  • Lesson 3: Using Containers
  • Lab A: Implementing Control Flow in an SSIS Package
  • Lesson 4: Managing Consistency
  • Lab B: Using Transactions and Checkpoints
  • Lesson 1: Debugging an SSIS Package
  • Lesson 2: Logging SSIS Package Events
  • Lesson 3: Handling Errors in an SSIS Package
  • Lab: Debugging and Troubleshooting an SSIS Package
  • Lesson 1: Introduction to Incremental ETL
  • Lesson 2: Extracting Modified Data
  • Lab A: Extracting Modified Data
  • Lesson 3: Loading Modified Data
  • Lesson 4: Temporal Tables
  • Lab B: Loading a Data Warehouse
  • Lesson 1: Introduction to Data Quality
  • Lesson 2: Using Data Quality Services to Cleanse Data
  • Lab A: Cleansing Data
  • Lesson 3: Using Data Quality Services to Match Data
  • Lab B: Deduplicating Data
  • Lesson 1: Introduction to Master Data Services
  • Lesson 2: Implementing a Master Data Services Mode
  • Lesson 3: Hierarchies and Collections
  • Lesson 4: Creating a Master Data Hub
  • Lab: Implementing Master Data Services Model
  • Lesson 1: Using Scripts in SSIS
  • Lesson 2: Using Custom Components in SSIS
  • Lab: Using Custom Scripts
  • Lesson 1: Overview of SSIS Development 13-2
  • Lesson 2: Deploying SSIS Projects 13-5
  • Lesson 3: Planning SSIS Package Execution 13-14
  • Lab: Deploying and Configuring SSIS Packages
  • Lesson 1: Introduction to Business Intelligence
  • Lesson 2: Introduction to Data Analysis
  • Lesson 3: Introduction to Reporting
  • Lesson 4: Analyzing Data with Azure SQL Data Warehouse
  • Lab: Using a Data Warehouse
Prem Sharma



Microsoft:20761C:Querying Data with Transact-SQL 2016Microsoft:20762C: Developing SQL 2016 Databases
Microsoft:Administering a SQL Database InfrastructureMicrosoft:Administering Microsoft SQL Server 2014 Databases
Microsoft:Advance SQL TrainingMicrosoft:Course 55246-A: SQL 2016 AlwaysOn High Availability
Microsoft:DP-203T00: Data Engineering on Microsoft AzureMicrosoft:DP-300 : Administering Relational Database on Microsoft Azure
Microsoft:Implementing a SQL 2016 Data Warehouse (SSIS)Oracle:MySQL Fundamentals Ed 1
Oracle:Oracle Database 12c : Administration WorkshopOracle:Oracle Database 12c R2: Program with PL/SQL Ed 2
Oracle:Oracle Database 12c: Admin, Install and Upgrade AcceleratedOracle:Oracle Database: Administration Workshop Ed 1
Microsoft:Performance Tuning and Optimizing SQL DatabasesMicrosoft:PL-300: Microsoft Power BI Data Analyst
Microsoft:Provisioning SQL DatabasesMicrosoft:Sql Server 2016 Admin High Availability and Performance Tuning
Microsoft:Updating Your Skills to SQL Server 2016

You will get access to Flexi instantly.

Flexi Video

USD 99

Official Courseware1

USD 49


USD 59

1Delivery lead time is 1 Day


USD 99

100% Secure Transaction

Learn more about Koenig. Download Presentation


Q1. How long do you have access to Flexi after purchase?

A. 3 months from date of delivery.

Q2. Can the content be shared or is it only available for one user?

A. It is only for the self-use of the purchaser.

Q3. Do you have business packages that you offer to companies that would make use of these packages on a regular basis?

A. Yes, contact us for corporate packages.

Q4. What is the pass rate of students that used Flexi as their method of preparation?

A. We do not track the pass rate of Flexi students. We, however suspect that it will be lower than for Live Online.

Q5. If we buy Flexi today, and there are any updates in the course, do we get the updated recordings as well or do we need to repurchase Flexi?

A. If the latest update comes within 3 months after the sale we can give the updated version.

Q6. Can we download the videos or we stream them online?

A. Videos can only be streamed and not downloaded.

Q7. Do you have courses in languages other than English?

A. Presently Flexi is only available in English.

Feedbacks from Clients