Development
Databases
SQL Server
SQL Server 2019: What’s New (New and Enhanced Features)
4.5 (21 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
96 students enrolled

SQL Server 2019: What’s New (New and Enhanced Features)

Learn about Intelligent Query Processing, UTF-8, Vulnerability Assessment, Data Discovery and Classification and more!
4.5 (21 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
96 students enrolled
Created by Artemakis Artemiou
Last updated 7/2020
English
English [Auto]
Preview this course
SQL Server 2019: What’s New (New and Enhanced Features)
Current price: $55.99 Original price: $79.99 Discount: 30% off
5 hours left at this price!
Buy now
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 1 article
  • 6 downloadable resources
  • 1 Practice Test
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • What are the major new enhancements and features in SQL Server 2019 and SSMS 18.0.
  • How to use many of the new features and enhancements in SQL Server 2019 via live demos and guides
  • What are the new Performance enhancements
  • What are the new Security and Compliance enhancements
  • What are the new High Availability enhancements
  • What are the new Development-related enhancements
  • How to download and install SQL Server 2019
  • How to download and install SQL Server Management Studio (SSMS) v18.0
Course content
Expand all 23 lectures 02:28:06
+ – Introduction
1 lecture 02:46

This is the introduction to the course. We will talk about what will you learn after completing this course.

Welcome to the Course!
Preview 02:46
+ – About SQL Server 2019 and SSMS 18.0
3 lectures 21:15

In this lecture, we will discuss about how SQL Server has been evolved over the years, and what major features have been added in the last versions.

SQL Server Evolution
Preview 03:16

In this lecture, we will talk about the system requirements for SQL Server 2019 and see in action how we can download it and install it (note that in the demo, we use a CTP release of SQL Server 2019 since RTM was not yet released, but the process is almost identical - the lectures will be updated very soon).

Downloading and Installing SQL Server 2019
12:36

In this lecture, we will talk about the system requirements for SQL Server Management Studio v18.0 and see in action how we can download it and install it.

Downloading and Installing SQL Server Management Studio v18.0
05:23

Test your knowledge on SQL Server 2019 and SSMS 18.0

About SQL Server 2019 and SSMS 18.0
4 questions
+ – Performance Enhancements
1 lecture 12:44

In this lecture, we will talk about the major performance enhancements in SQL Server 2019.

Performance Enhancements
12:44

Test what you've learned on SQL Server 2019 Performance enhancements

Performance Enhancements
4 questions
+ – Security and Compliance Enhancements
1 lecture 13:27

In this lecture, we will talk about the major security and compliance enhancements in SQL Server 2019.

Security and Compliance Enhancements
13:27

Test what you've learned on SQL Server 2019 Security and Compliance enhancements.

Security and Compliance
4 questions
+ – High Availability Enhancements
1 lecture 01:44

In this lecture, we will talk about the major high availability enhancements in SQL Server 2019.

High Availability Enhancements
Preview 01:44

Test what you've learned on SQL Server 2019 High Availability enhancements.

High Availability
4 questions
+ – Development Enhancements
1 lecture 03:51

In this lecture, we will talk about the major development-related enhancements in SQL Server 2019.

Development-Related Enhancements
Preview 03:51

Test what you've learned on SQL Server 2019 Development-related enhancements.

Development
2 questions
+ – Other Enhancements
1 lecture 01:47

In this lecture, we will talk about other significant enhancements in SQL Server 2019 such as additional support for Linux, Big Data and more.

Other Enhancements
01:47

Test what you've learned on SQL Server 2019 other significant enhancements.

Other Enhancements
4 questions
+ – Special Topics on SQL Server 2019 (New)
6 lectures 36:24

This lecture, introduces the new section in this course, titled “Special Topics”.

About Special Topics
Preview 00:55

This lecture talks about the new Dynamic Management Function (DMF) sys.dm_exec_query_plan_stats in SQL Server 2019 and further explains it via a live demonstratrion.

New DMF sys.dm_exec_query_plan_stats
02:14

This lecture talks about the new capability in SQL Server 2019, that allows to manually suspend and resume the TDE scan process.

Transparent Data Encryption (TDE) Scan - Suspend and Resume
06:00

This lecture talks about the new default truncation message in SQL Server 2019.

New Default Truncation Message
04:14

In this special topic, we will talk about Stretch Database in SQL Server 2019 and via a comprehensive live demonstration, we will see how it is possible via the Stretch Database technology, to store a database table on Azure SQL Database, while being able to access it from your on-premises SQL Server 2019 database.

How to Enable Stretch Database in SQL Server 2019
15:37

SQL Server provides many data protection features, as well as security and compliance features. Dynamic Data Masking is available since SQL Server 2016, but I considered it useful, to dedicate a special topic to this great feature and see a live demonstration in SQL Server 2019.

Dynamic Data Masking in SQL Server
07:24
+ – SQL Server 2019 on Linux (New)
6 lectures 49:13

Learn more information about this section.

About this Section
00:50

In this lecture and demo, we will see step by step, how we can install SQL Server 2019 CTP 3.0 on Ubuntu Linux 19.04.

How to Install SQL Server 2019 on Ubuntu Linux
08:39

In this lecture and demo, we will see how we can install the SQL Server command-line tools (sqlcmd and bcp) on Ubuntu Linux.

How to Install the SQL Server command-line tools on Ubuntu Linux
05:57

In this lecture and demo, we will see how we can access SQL Server 2019 on Ubuntu Linux, using Azure Data Studio.

How to Access SQL Server 2019 on Ubuntu Linux using Azure Data Studio
11:00

In this lecture and demo, you will learn how to perform an offline installation of SQL Server 2019 (CTP 3.1) on Ubuntu Linux 19.04.

How to Perform an Offline Installation of SQL Server 2019 on Ubuntu Linux
11:36

In this lecture and demo, we are going to see how to install SQL Server 2019 on CentOS Linux version 8.

How to Install SQL Server 2019 on CentOS Linux
11:11
+ – Wrap-Up
1 lecture 01:51

This lecture, is a recap of what we've learned in this course. A practice test follows.

What we’ve Learned in this Course
01:51

Test what you've learned in the course "SQL Server 2019: What's New".

Practice Test of SQL Server 2019: What's New
15 questions
Requirements
  • Basic SQL Server knowledge in prior versions of SQL Server
  • Basic database principles
Description

In this course, 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.


WHAT OTHER STUDENTS SAY ABOUT THE COURSE:

  • Great course, very understandable, very well constructed!! Worth my time absolutely!

  • The instructor makes it really easy to understand the new features in SQL Server 2019.

  • This course greatly helped me to understand the new features of SQL Server 2019. Very detailed and well presented course !!


MORE ABOUT THE COURSE:

SQL Server 2019, is the latest release of the powerful SQL Server. This is an exciting new version of the SQL Server Data Platform, with a plethora of new features, as well as with enhancements to existing features. In this course, we will go through all the new features and enhancements in SQL Server 2019, talk about it, as well as see many live demonstrations and guides that will help get hands on knowledge on how you can use these features. Moreover, we are will work with SQL Server 2019 on Linux.


AFTER THE COURSE:

You will know the below:

  • 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


PREREQUISITES:

  • Basic SQL Server knowledge in prior versions of SQL Server

  • Basic database principles


THIS COURSE OFFERS:

  • 2.5 hours of high-quality video lectures with live demonstrations and guides

  • 6 useful quizzes for testing your knowledge on each section

  • Useful downloadable resources

  • A practice test in the end of the course

  • Ability to ask the instructor questions related to the course via the Q&A section

  • Certificate on course completion

Who this course is for:
  • People who work with previous versions of SQL Server and want to know what is new in SQL Server 2019.
  • People who have basic SQL Server knowledge and want to learn more about the latest version of SQL Server.
  • Technology enthusiasts that explore new technologies and want to learn what’s new in this latest version of SQL Server.