SQL Server 2019- What’s New New and Enhanced Features

SQL Server 2019: What’s New – New and Enhanced Features, available at $49.99, has an average rating of 4.71, with 38 lectures, 8 quizzes, based on 401 reviews, and has 1385 subscribers.

You will learn about How to download and install SQL Server 2019 on both Windows and Linux. What are the major new enhancements and features in SQL Server 2019 and SSMS 18.x 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 Management Studio (SSMS) v18.0 This course is ideal for individuals who are People who work with previous versions of SQL Server and want to know what is new in SQL Server 2019. or People who have basic SQL Server knowledge and want to learn more about the latest version of SQL Server. or Technology enthusiasts that explore new technologies and want to learn what’s new in this latest version of SQL Server. It is particularly useful for People who work with previous versions of SQL Server and want to know what is new in SQL Server 2019. or People who have basic SQL Server knowledge and want to learn more about the latest version of SQL Server. or Technology enthusiasts that explore new technologies and want to learn what’s new in this latest version of SQL Server.

Enroll now: SQL Server 2019: What’s New – New and Enhanced Features

Summary

Title: SQL Server 2019: What’s New – New and Enhanced Features

Price: $49.99

Average Rating: 4.71

Number of Lectures: 38

Number of Quizzes: 8

Number of Published Lectures: 38

Number of Published Quizzes: 8

Number of Curriculum Items: 46

Number of Published Curriculum Objects: 46

Number of Practice Tests: 1

Number of Published Practice Tests: 1

Original Price: $89.99

Quality Status: approved

Status: Live

What You Will Learn

How to download and install SQL Server 2019 on both Windows and Linux.

What are the major new enhancements and features in SQL Server 2019 and SSMS 18.x

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 Management Studio (SSMS) v18.0

Who Should Attend

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.

Target Audiences

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.

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:

3+ 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

Course Curriculum

Chapter 1: Introduction

Lecture 1: Welcome to the Course! What will you Learn?

Chapter 2: About SQL Server 2019 and SSMS 18.0

Lecture 1: Section Overview

Lecture 2: SQL Server Evolution

Lecture 3: Downloading and Installing SQL Server 2019

Lecture 4: Downloading and Installing SQL Server Management Studio v18

Lecture 5: Section Recap

Chapter 3: Performance Enhancements

Lecture 1: Section Overview

Lecture 2: Performance Enhancements

Lecture 3: Section Recap

Chapter 4: Security and Compliance Enhancements

Lecture 1: Section Overview

Lecture 2: Security and Compliance Enhancements

Lecture 3: Section Recap

Chapter 5: High Availability Enhancements

Lecture 1: Section Overview

Lecture 2: High Availability Enhancements

Lecture 3: Section Recap

Chapter 6: Development Enhancements

Lecture 1: Section Overview

Lecture 2: Development-Related Enhancements

Lecture 3: Section Recap

Chapter 7: Other Enhancements

Lecture 1: Section Overview

Lecture 2: Other Enhancements

Lecture 3: Section Recap

Chapter 8: SQL Server 2019 on Linux

Lecture 1: About this Section

Lecture 2: How to Install SQL Server 2019 on Ubuntu Linux

Lecture 3: How to Install the SQL Server command-line tools on Ubuntu Linux

Lecture 4: How to Access SQL Server 2019 on Ubuntu Linux using Azure Data Studio

Lecture 5: How to Perform an Offline Installation of SQL Server 2019 on Ubuntu Linux

Lecture 6: How to Install SQL Server 2019 on CentOS Linux

Lecture 7: Section Recap

Chapter 9: Special Topics on SQL Server 2019

Lecture 1: About Special Topics

Lecture 2: New DMF sys.dm_exec_query_plan_stats

Lecture 3: Transparent Data Encryption (TDE) Scan – Suspend and Resume

Lecture 4: New Default Truncation Message

Lecture 5: How to Enable Stretch Database in SQL Server 2019

Lecture 6: Dynamic Data Masking in SQL Server

Lecture 7: Working with Temporal Tables in SQL Server 2019

Lecture 8: Integration between Active Directory and SQL Server 2019 on Linux via OpenLDAP

Chapter 10: Wrap-Up

Lecture 1: What Have You Learned in this Course?

Chapter 11: Learning More

Lecture 1: Bonus Lecture

Instructors

Artemakis Artemiou
Award-Winning Database & AI Expert, Trainer, Author, Speaker

Rating Distribution

1 stars: 3 votes

2 stars: 6 votes

3 stars: 38 votes

4 stars: 174 votes

5 stars: 180 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!