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   download_img
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
Date Amount
Super Early Bird – Oct 30 to Nov 30, 2017 INR 8000 / USD 300
Early Bird – Dec 1 to Dec 31, 2017 INR 9000 / USD 350
Regular – Jan 1 to Feb 2, 2018 INR 10,000/ USD 400

Note:

    * INR & USD Prices quoted above are exclusive of 18% GST.
    * 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)
                    Registration                    
Key Highlights:

  • 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 & JSON

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