Flexi is a Video Recording of Live Online + Official Courseware + Hands-on Labs

Live Online
+
On Demand
=
Flexi

Implementing a SQL 2016 Data Warehouse (SSIS)

Includes:

  1. Power Packed 15 Hours (Edited from 40 hours of Live Training)
  2. 190+ Tests Questions (Qubits42)
  3. 6 months access to recordings.
  4. Access via Laptop, Tab, Mobile, and Smart TV.
  5. Certificate of completion.
  6. Official Courseware
  7. Hands-on labs
You can also purchase an annual plan for USD 999. For one year, all Flexi Videos will be free for you. Buy Annual Plan

You will get access to Flexi Video instantly.

Flexi Video

USD 99

Official Courseware

N/A

Hands-On-Labs

USD 59

Total

USD 99

100% Refund for Flexi Video (courseware is non-refundable) if user is not satisfied with the Video and seeks refund within 30 days of purchase.

Download Course Contents
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

Certifications

Skills

 
Microsoft:20761C:Querying Data with Transact-SQL 2016Microsoft:Administering a SQL Database Infrastructure
Microsoft:Administering Microsoft SQL and Azure SQL database solutionsMicrosoft:Analyzing Data with SQL Server 2016 Reporting Services (SSRS)
CompTIA:CompTIA Data+ DA0-001Microsoft:Course 55246-A: SQL 2016 AlwaysOn High Availability
Databricks:Data Analysis with Databricks SQLDatabricks:Data Engineering with Databricks
Microsoft:Developing SQL 2016 Data Models (SSAS)Microsoft:DP-203T00: Data Engineering on Microsoft Azure
Microsoft:DP-300T00: Administering Microsoft Azure SQL SolutionsMicrosoft:DP-500T00: Designing and Implementing Enterprise-Scale Analytics Solutions Using Microsoft Azure and Microsoft Power BI
Microsoft:Implementing a Cloud Data Warehouse in Microsoft Azure Synapse AnalyticsMicrosoft:Implementing a SQL 2016 Data Warehouse (SSIS)
Microsoft:Introduction To SQL Databases-55315Microsoft:Microsoft SQL Always on High availability with optimization
Microsoft:Microsoft SQL Database Administration on 2019Microsoft:Microsoft SQL High availability with Replication
Microsoft:Microsoft SQL Server 2019 Performance Tuning and ManagementOracle:Oracle Database 12c R2: Program with PL/SQL Ed 2

Learn more about Koenig. Download Presentation Buy Other Flexi

FAQ's

You will be provided access to LET ( Learning Enhancement Tool), where you will get the links to access all your purchases.
Yes, you can pay from this web page.
Videos can only be streamed and not downloaded.
We do not track the pass rate of Flexi students. However, we trust it will be lower than for Live Online.
Presently, Flexi is only available in English.
Yes, the site is secure by utilizing Secure Sockets Layer (SSL) Technology. SSL technology enables the encryption of sensitive information during online transactions. We use the highest assurance SSL/TLS certificate, which ensures that no unauthorized person can get to your sensitive payment data over the web.
We use the best standards in Internet security. Any data retained is not shared with third parties.
Flexi video for the new version will be provided free of cost.
6 months from the date of delivery.
Yes, you do. Flexi Videos do not include Courseware or Labs.
Yes, contact us for corporate packages.
Yes, c/w and Lab are not included in the annual plan. All Flexi videos are included.
It is only for one user.
It’s a unique subscription plan where customers can avail unlimited Flexi courses within a year.
The subscription plan is valid for 1 year from the date of purchase.
No, this is limited to one user and its non-transferable.

Feedbacks from Clients