What is new with SQL Server 2019
Lecture
Joseph D'Antoni
Beginner
1 h 49 m
2020-07-08
Lecture Overview
In this course, we will take you through the key features of SQL Server 2019. Throughout the course you will learn about intelligent performance, security, availability, Linux, Kubernetes, big data, as well as other topics.

Related Learning Path(s):
What is new with SQL Server 2019
Objectives
  • In this course, you will take you through the key features of SQL Server 2019. Throughout the course you will learn about intelligent performance, security, availability, Linux, Kubernetes, big data, as well as other topics.
Pre-Requisites
  • Fundamental knowledge of a previous version of SQL Server
  • Basic knowledge of databases
Lecture Modules
In this module you will learn the basics of SQL Server 2019, the business challenges that it faces such as silos relational and big data. This module will discuss its strong foundation on SQL Server 2016 and 2017 along with the different versions for SQL Server 2019. Finally, this module will review the new features that solve modern data challenges. 
In this module, you will learn about SQL Server 2019’s new capabilities designed to enhance your performance with no application changes
In this module, you will learn about security enhancements in SQL Server 2019. These enhancements include Encryption, Data Classification, Auditing, and Certificate Management.
In this module, you will learn about Availability in SQL Server 2019. Topics include indexing, availability groups, and database recovery.
In this module, you will learn about the different programming languages supported by SQL Server 2019, support for UTF-8 Encoding, enhancements to Machine Learning Services, and extending the T-SQL Language.
In this module, you will learn about Replication, Change Data Capture, Distributed Transactions, Polybase, and Tempdb file automatic configuration.
In this module, you will learn how to use Kubernetes with SQL Server 2019. Kubernetes is an open source container orchestration engine for automating deployment, scaling, and management of containerized applications. The open source project is hosted by the Cloud Native Computing Foundation (CNCF).
 
Kubernetes comes with built-in basic high-availability, networking, storage, and container interfaces. A Kubernetes deployment is known as a cluster and consists of software components to run the cluster, and various objects such as nodes, pods, services, and storage.
In this module, you will learn about SQL Server 2019’s new capabilities for data virtualization by extending the Polybase feature introduced in SQL Server 2016 with the ability to connect to other data sources with client drivers installed.
In this module, you will learn techniques for making your application scale and be ready for production. We’ll explore common troubleshooting techniques you can use for your application, as well discuss how to design for data concurrency. This module will also explore the Cosmos DB Change Feed feature for building event driven applications with Cosmos DB. Finally, the module will close on how to distribute your Cosmos back end globally using multiple Azure regions
Try Risk Free

Start a free trial

Skill Me Up subscriptions include unlimited access to on-demand courses with live lab lab environments with our Real Time Labs feature for hands-on lab access.

Subscription Benefits
  • Access to Real Time Lab environments and lab guides
  • Course Completion Certificates when you pass assessments
  • MUCH MORE!