New Features of SQL Server Database Engine and T-SQL Enhancements Training Course

New Features of SQL Server Database Engine and T-SQL Enhancements Training Course

 

In this training course learn how the new features of SQL Server work and how it fits into your organisation.  Demos, examples and discussions. We cover the Database Engine and any important T-SQL enhancements.

Learning Outcomes 

How each version of SQL Server can improve performance and stability.

Course Requirements

Developers and DBAs

Course Length

Typically half a day per version

New Features of SQL Server Database Engine and T-SQL Enhancements Training Course Agenda

New Features of SQL Server 2012 Database Engine & T-SQL Enhancements
  • Columnstore Indexes
  • Contained Databases
  • Sequences but where’s your identity
  • T-SQL Enhancements
New Features of SQL Server 2014 Database Engine & T-SQL Enhancements
  • Backup Encryption
  • Cardinality Estimation – a brave new world
  • Delayed Durability
  • T-SQL Enhancements
New Features of SQL Server 2016 Database Engine & T-SQL Enhancements
  • Memory-Optimized Tables
  • Query Store – An Introduction
  • Live Query Statistics
  • Temporal Tables
  • Built-in JSON Support
  • T-SQL Enhancements
New Features of SQL Server 2017 Database Engine & T-SQL Enhancements
  • Adaptive Query Processing
  • Automatic Database Tuning
  • Graph Database Capabilities
  • Installation – TempDB
  • Availability Groups now includes clusterless support
  • In-memory and memory-optimized object enhancements
  • T-SQL Enhancements

Please note you can choose any topic from previous versions and assemble into your own New Feature Master Class!

Course Price

This course costs £475 excluding VAT

How to Book

Call us or email us on the form below, any questions, ask us!

You Might Also Like…

Power BI Training Course

 

Summary
New Features of SQL Server Database Engine and T-SQL Enhancements Training Course
Service Type
New Features of SQL Server Database Engine and T-SQL Enhancements Training Course
Provider Name
Sequallity Ltd,
80-83 Long Lane,London,EC1A 9ET,
Telephone No.020 3507 1989
Area
UK
Description
In this training course learn how the new features of SQL Server work and how it fits into your organisation. Demos, examples and discussions. We cover the Database Engine and any important T-SQL enhancements.