SQL Server 2019: What’s New
5.0 (4 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.
17 students enrolled

SQL Server 2019: What’s New

Learn about the exciting new features and enhancements in SQL Server 2019 Database. Many live demonstrations included!
New
5.0 (4 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.
17 students enrolled
Last updated 4/2019
English
English [Auto-generated]
Current price: $11.99 Original price: $49.99 Discount: 76% off
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • 5 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 Udemy's top 3,000+ 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 15 lectures 01:18:49
+ Introduction
1 lecture 03:04

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

Preview 03:04
+ About SQL Server 2019 and SSMS 18.0
3 lectures 22:21

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.

Preview 03:46

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.

Downloading and Installing SQL Server 2019
12:51

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.

Preview 05:44

Test your knowledge on SQL Server 2019 and SSMS 18.0

About SQL Server 2019 and SSMS 18.0
4 questions
+ Performance
1 lecture 13:21

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

Performance Enhancements
13:21

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

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

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

Security and Compliance Enhancements
13:59

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

Security and Compliance
4 questions
+ High Availability
1 lecture 01:53

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

High Availability Enhancements
01:53

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

High Availability
4 questions
+ Development
1 lecture 04:00

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

Development-Related Enhancements
04:00

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

Development
2 questions
+ Other Enhancements
1 lecture 01:53

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:53

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

Other Enhancements
4 questions
+ Special Topics (New)
4 lectures 13:23

This lecture, introduces the new section in this course, titled “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
+ 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
+ Learning More
1 lecture 03:04

Bonus lecture, with next steps on learning more about SQL Server 2019.

Bonus Lecture: Recommended eBooks and Blogs
03:04
Requirements
  • Basic SQL Server knowledge in prior versions of SQL Server
  • Basic database principles
Description

Hi there! My name is Artemakis Artemiou and I'm a Senior SQL Server & Software Architect with over than 15 years of experience on SQL Server administration, development, performance tuning and architecture, as well as on .NET development (C#).  Moreover, I'm a former Microsoft Data Platform MVP (2009-2018). I love talking about SQL Server, .NET, data access, and related topics, and make it easy for all to understand, by using a simple and understandable language as well as analytical guides.


In this course, you will learn about all the new major features and enhancements in SQL Server 2019 Database in an understandable and interactive way.


WHAT IS THIS COURSE ALL ABOUT?

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.


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


PREREQUISITES

  • Basic SQL Server knowledge in prior versions of SQL Server

  • Basic database principles


100% MONEY-BACK GUARANTEE

This course comes with a 30-day money back guarantee. If you're not satisfied with this course, you can ask for a refund.


This course contains/offers:

  • 1+ hour of high-quality video with live demonstrations

  • Six 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

  • 30-day no-questions-asked refund policy

  • Certificate on course completion


Also: This course is being updated with new material on a regular basis (check the "Special Topics" section for more info!)


Who this course is for:
  • People that work with previous versions of SQL Server and want to know what is new in SQL Server 2019.
  • People that 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.