SQL Server 2014, 2016 & 2017 (In-person)
Instructor: Amit R S Bansal (SQL MCM, SQL MVP)
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 8-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.
This Accelerator will be delivered by Amit Bansal, Microsoft Certified Master of SQL Server & 11 times Microsoft’s Most Valuable Professional awardee.
Course Code | PI_SQL_103_A | ||||||||
Course Title | Microsoft SQL Server 2014, 2016 & 2017 | ||||||||
Course Brochure | Download ![]() | ||||||||
Delivery Format & Location | In-Person (Classroom-based), Bangalore. | ||||||||
Date, Time & Duration | February 2, 2018, 8 hours Timing: 9 am to 6 pm with one-hour of lunch break | ||||||||
List Price |
Note:
* Prices in USD are applicable ONLY for international participants registering and/or planning to join the class from outside India. * There will be an additional service charge of 4% for online payment (using debit/credit card) * There are group discounts available. Reach out to the team for updated offers. | ||||||||
Level | Level 300-400(Intermediate to Advanced) | ||||||||
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) |
- 8-hour training
- Advance & exclusive content
- 100% demo-based
- Based on real-world scenarios
- Intermediate to Advanced level content
- Available In-person & Online
Module 1: In-Memory OLTP
Module 2: In-Memory OLTP Migration
Module 3: Buffer Pool Extension
Module 4: Columnstore Index
Module 5: Optimizer & Query Plan Enhancements
Module 6: Resource Governor for I/O
Module 7: Delayed Durability/h3>Module 8: Always On Availability Groups Enhancements
Module 9: New Security Features
Module 10: Query Store and Live Query Statistics
Module 11: Temporal & JSONModule 12: Miscellaneous Enhancements in SQL Server 2014, 2016 & 2017
Hands-On-Labs
Module 12: Miscellaneous Enhancements in SQL Server 2014, 2016 & 2017
Hands-On-Labs
SQLMaestros Accelerators are one-day demo-oriented training, and hence they do not have hands-on component as part of the course curriculum. However, if a participant wishes to practice using SQLMaestros Hands-On-Labs, then he/she can purchase a subscription (monthly or annual) of SQLMaestros HOLs. Additionally, participants can opt for the 3-day SQLMaestros Master Classes or the 5-day SQLMaestros Hackathons, that have mandatory Hands-on-labs as part of the comprehensive curriculum.
Please feel free to contact us if you need any further information
Email : classes@sqlmaestros.com
Skype : classes@sqlmaestros.com
Contact: +91-9606482133 / +91-9503124667