Implementing Microsoft SQL Server 2014, 2016 & 2017
SQL Server 2014 & 2016 have been the best release ever with some spell bounding features and functionalities including In-Memory & Columnstore. SQL Server 2016 has been rated as a leader in OLTP databases by Gartner Research and holds record breaking performance in TPC benchmarks. SQL Server handles some of the toughest database deployments across the globe. This 40-hour course is designed to give you the right amount of internal knowledge and loads of practical on all the new features & functionalities of SQL Server 2014 & 2016, and what’s new in SQL Server 2017. The course has advanced coverage of In-Memory & Columnstore feature and comprehensively covers many less-used features like Resource Governor IO & Buffer Pool Extension. Overall, this is the most detailed, advanced & comprehensive training on SQL Server 2014/2016/2017 database engine.
This Master Class will be delivered by Amit Bansal, Microsoft Certified Master of SQL Server & 11 times Microsoft’s Most Valuable Professional awardee.
All Master Class participants will get a 1-month FREE subscription to SQLMaestros Hands-on-Labs. Apart from practicing course specific labs, participant’s will have access to the entire library during this period.
|Course Title||Implementing Microsoft SQL Server 2014, 2016 & 2017|
|Delivery Format||Online (Instructor-led, synchronous) using GoToMeeting Platform. Learn more about our Online Delivery Model|
|Date, Time & Duration||To Be Announced Later|
|List Price||To Be Announced Later
|Level||300-400 (Advanced to Expert)|
|Target Audience||This course is intended for SQL Server Database Administrators, SQL Database Engineers, SQL Developers & SQL Architects. Anyone who works with the database engine of SQL Server.|
|Prerequisites||This course requires that participants have at least 2 years of genuine experience with Microsoft SQL Server. This course is not meant for Fresher|
|Trainer/Instructor||Amit R S Bansal (SQL MCM, SQL MVP)|
- The most advanced SQL Server 2014, 2016 & 2017 Workshop in India
- 40 hours of deep-dive learning
- Exclusive, level 300/400 content
- Packed with real-world scenarios and examples
- Get your own copy of SQLMaestros course material developed by Amit Bansal
- Learn from the Master: Amit Bansal is the only Microsoft Certified Master of SQL Server in India (outside Microsoft)
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.
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 5 day class is rigorous and deep-dive! The course is packed with Hands-On-Labs powered by SQLMaestros.com.
Please feel free to contact us if you need any further information or Book a call with us now!
Email : email@example.com
Skype : firstname.lastname@example.org
Contact: +91-7829999046 / +91-9503124667