SQL Server 2014, 2016 & 2017 Master Class (In-person, Bangalore)

Module 1:  In-Memory OLTP Overview

Business & Hardware Trends, Motivational Factors, Architecture Pillars, Memory Optimized Tables Overview, Stored Procedures Overview, Customer Experiences and more

Module 2:  In-Memory OLTP (Database Administration)

Memory Usage and Management, Row Format, Hash Indexes, BW Tree, Garbage Collection, Monitoring, Durability, Disk Storage, Data & Delta Files, Merge Operation, Checkpoint, Storage Considerations and Best Practices, Recover, HADR and more!

Module 3:  In-Memory OLTP (Database Development)

Create Table DDL, Create Table Type, Table Creation Process, Memory Optimized Indexes, Index Creation, Accessing Memory Optimized Tables, Stored Procedure Creation, Transactions, Concurrency Control, Isolation Levels, Write Conflict, Guidelines & Limitations and more

Module 4:  In-Memory OLTP Migration

Analysing Applications & Patterns, Understanding Impact, Establishing Baseline, Identifying Bottlenecks, AMR tool, DMVs, Testing, Durability Consideration, Estimating Memory Consumption, Indexing Guidelines and Considerations, Query Performance, Interpreted Transact-SQL vs. Natively Compiled and more

Module 5:  In-Memory OLTP Performance Troubleshooting

Performance Considerations, Troubleshooting Tools, Hardware & Concurrency, Index Troubleshooting, Native Procedures Troubleshooting and more

Module 6:  In-Memory OLTP: Memory/Storage Monitoring and Troubleshooting

Memory Challenges, Resolutions, Garbage Cleanup, OOM and Resolution, Data and Delta Files States & Transitions, Merge Operation, Backups and more

Module 7:  Buffer Pool Extension

Motivation, Benefits, Ease of Use, Troubleshooting, Performance Counters, Storage Class Memory, Buffer Pool Manager, Scenarios and more

Module 8:  Columnstore Index Overview

DW Intro, Star Schema & Star Join, DW Performance, Speeding Storage & IO, Query Execution, Row Mode vs Batch Mode, Performance and more

Module 9:  Non-Clustered Columnstore Index

Business Rationale, Trends in DW Space, Why Columnstore, Terminology, Compression, Row Groups & Column Segment, Memory Internals, Query Performance and more

Module 10:  Clustered Columnstore Index

Why CCI, Data Compression, Columnstore TSQL, Query Performance, Improved Batch Mode Processing, Update Process, Tuple Mover, Concurrency, Materialized View, HA, Columnstore Metadata, DBCC and more

Module 11:  Columnstore Index Internals

Metadata, Extended Events, Memory Internals, Storage Internals, Transaction Internals, Data Loading, Compression Internals, Compatibility with Other Features and more

Module 12:  Optimizer & Query Plan Enhancements

New Cardinality Estimator, Incremental Statistics and more

Module 13:   Resource Governor for I/O

Overview, IO Governance, T-SQL, DMVs, XE, Real-Time IO Throttling and more

Module 14:  Delayed Durability

Architecture, Why We Need It, Pros & Cons and more

Module 15:  Always On Availability Groups in SQL Server 2014 & 2016

New Enhancements in AGs in SQL 2014 & 2016

Module 16:  In-Memory OTLP in SQL Server 2016 – What’s New?

New Enhancements in In-Memory OLTP Engine

Module 17:  Columnstore Index in SQL Server 2016 – What’s New?

New Enhancements in Columnstore Indexes

Module 18:  Security in SQL Server 2016 – What’s New?

New Security Enhancements in SQL Server 2016

Module 19:   Query Store and Live Query Statistics

Enabling/Disabling, Query Store Metadata, Configuration, Usage Scenario, Using with In-Memory OLTP, Performance Tuning with Query Store, Performance Tuning with Live Query Statistics and more!

Module 20:   SQL Server 2016 Operational Analytics

Traditional DW Architecture, Minimizing Data Latency, Understanding Real Time Analytics, Real Time Analytics with Columnstore Index, Real Time Analytics with Columnstore on In-Memory OLTP, Scenarios, Best Practices and more.

Module 21:  Temporal & JSON in SQL Server 2016

Overview, Consistency Checks, Partitioning, Considerations & Limitations, Security, Metadata, JSON Representation, FOR JSON, and more!

Module 22:   Always Encrypted

Benefits, What, Whay & How, Architecture, Security & Permissions, Stretch Database Advisor and more!

Module 23:   Stretch Database

Architecture, Scenarios, Always Encrypted Keys & Driver, T-SQL, Best Practies and more!

Module 24:   Dynamic Data Masking & Row Level Security

Defining a Dynamic Data Mask, Permissions, Querying, Limitations & Restrictions, Use Cases, Best Practices and more!

Module 25:  Miscellaneous Enhancements in SQL Server 2014 & 2016

Miscellaneous Enhancements in SQL 2014 & 2016.

Module 26:  SQL Server 2014 & 2016 – Hybrid Scenarios

SQL Server Data Files in Windows Azure, Hosting a SQL Server Database in a Windows Azure Virtual Machine, Backup to Azure &URL, Azure HADR and more!

Module 27:  SQL Server Upgrade

Upgrading from a lower version to SQL Server 2014/2016.

[/fusion_tab/]

In The Words Of Amit Bansal

“Hi, My name is Amit Bansal and I am the instructor for this course. SQL Server is an enterprise level RDBMS server with a very powerful database engine capable of handling toughest of requirements in terms of scalability, availability, extensibility and performance. SQL Server 2014 & 2016 takes the toughness to the next level. It has award-winning (Gartner) & record-breaking (TPC) features and functionalities including In-Memory & Columnstore. In this 40-hour course, I will go deep inside In-Memory & columnstore concepts, their internal working, practical usage and with tons of real-world demos. There are some less-known yet very powerful features like Buffer Pool Extension & Resource Governor IO and I will be covering them as well with relevant demos/examples. SQL 2016 administration and programmability features will be covered with practical examples. SQL is big on performance and features like Query Store will be covered in-depth. A solid understanding of the new features is very critical for anyone who is implementing 2014/2016. Note that this 3 day class is rigorous and deep-dive! The course is packed with Hands-On-Labs powered by SQLMaestros.com.