SQL Server 2019: What’s New - New and Enhanced Features (Online Course Preview)
Enroll to the FULL course (with discount): https://www.sqlnethub.com/go/course-s...
In this course (updated in 2020), you will learn all about the new major features and enhancements in SQL Server 2019, in an understandable and interactive way, via a rich set of video lectures and step-by-step live guides and demonstrations. Moreover, besides SQL Server 2019 on Windows, we are going to install and use SQL Server 2019 on Linux.
The course agenda, is the following:
Introduction
About SQL Server 2019 and SSMS 18.0
-- SQL Server evolution over the years and major features
-- System requirements of SQL Server 2019 and installation (with live demonstration)
-- System requirements for SSMS v18.0 and installation (with live demonstration)
Performance
Performance enhancements
-- Intelligent Query Processing (with live demonstrations)
--- Batch mode on row store
--- Row mode memory grant feedback
--- Table variable deferred compilation
--- Approximate COUNT DISTINCT
--- Scalar UDF inlining
-- Expanded Support for Persistent Memory Devices
-- Hybrid Buffer Pool
-- Columnstore Statistics in DBCC CLONEDATABASE
-- Lightweight Query Profiling Infrastructure
Security and Compliance
Security and Compliance Enhancements (with live demonstrations)
-- Always Encrypted with Secure Enclaves
-- Data Discovery and Classification
-- Certificate Management in SQL Server Configuration Manager
-- Vulnerability Assessment
High Availability
High Availability enhancements
-- Enhancements for Availability Groups
-- High Availability with Remote Storage On Kubernetes
-- Online Operations
After the course, you will know:
-How SQL Server evolved over the years and the different main features shipped with each version
-What are the new Performance enhancements in SQL Server 2019
-What are the new Security and Compliance enhancements in SQL Server 2019
-What are the new High Availability enhancements in SQL Server 2019
-What are the new Development-related enhancements in SQL Server 2019
-What are the new and enhanced built-in tools in SQL Server Management Studio 18.0 and how to use them such as:
-Vulnerability Assessment Tool
--Data Classification Tool
--Other significant enhancements in this new release of SQL Server
-How you can use many of these new features and enhancements
-How to install and use SQL Server 2019 on Linux
Enroll to the FULL course (with discount): https://www.sqlnethub.com/go/course-s...
© SQLNetHub
All rights reserved.