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

Live Online
On Demand

Performance Tuning and Optimizing SQL Databases


  1. Power Packed 10 Hours (Edited from 32 hours of Live Training)
  2. 120+ 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 will get access to Flexi Video instantly.

Flexi Video

USD 99

Official Courseware1

USD 19


USD 59

1Delivery lead time is 1 Day


USD 99

Download Course Contents
Module 1: SQL Server Architecture, Scheduling, and Waits
  • SQL Server Components and SQL OS
  • Windows Scheduling vs SQL Scheduling
  • Waits and Queues
  • Core Concepts
  • Storage Solutions
  • I / 0 Setup and Testing
  • Database Structure Internals
  • Data File Internals
  • TempDB Internals
  • Windows Memory
  • SQL Server Memory
  • In-Memory OLTP
  • Concurrency and Transactions
  • Locking Internals
  • Statistics Internals and Cardinality Estimation
  • Index Internals
  • Columnstore Indexes
  • Query execution and optimizer internals
  • Query execution plans
  • Analyzing query execution plans
  • Adaptive query processing
  • Plan cache internals
  • Troubleshooting plan cache issues
  • Automatic tuning
  • Query store
  • Extended events core concepts
  • Working with extended events
  • Monitoring and tracing
  • Baselining and benchmarking
Prem Sharma



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
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 SQL 2016 Data Warehouse (SSIS)Microsoft:Introduction To SQL Databases-55315
Microsoft:Microsoft SQL Always on High availability with optimizationMicrosoft:Microsoft SQL High availability with Replication
Oracle:Oracle Database 12c R2: Program with PL/SQL Ed 2Microsoft:Performance Tuning and Optimizing SQL Databases
Microsoft:Provisioning SQL DatabasesMicrosoft:Sql Server 2016 Admin High Availability and Performance Tuning

Learn more about Koenig. Download Presentation Buy Other Flexi


Yes, you can pay from this web page.
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.
You will be provided access to LET ( Learning Enhancement Tool), where you will get the links to access all your purchases.
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.
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.

Feedbacks from Clients