SQL Server 2022- What New New and Enhanced Features

SQL Server 2022: Whats New – New and Enhanced Features, available at $54.99, has an average rating of 4.41, with 31 lectures, 6 quizzes, based on 44 reviews, and has 184 subscribers.

You will learn about How to download and install SQL Server 2022 on Windows What are the major new enhancements and features in SQL Server 2022 and SSMS 19 How to use many of the new features and enhancements in SQL Server 2022 via live demos and guides What are the new business continuity features and enhancements What are the new security features and enhancements What are the new performance features and enhancements Other enhancements in SQL Server 2022 such as T-SQL enhancements, Azure Synapse Link and more This course is ideal for individuals who are Professionals who work with previous versions of SQL Server and want to know whats new in SQL Server 2022. or Professionals 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 version of SQL Server. It is particularly useful for Professionals who work with previous versions of SQL Server and want to know whats new in SQL Server 2022. or Professionals 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 version of SQL Server.

Enroll now: SQL Server 2022: Whats New – New and Enhanced Features

Summary

Title: SQL Server 2022: Whats New – New and Enhanced Features

Price: $54.99

Average Rating: 4.41

Number of Lectures: 31

Number of Quizzes: 6

Number of Published Lectures: 31

Number of Published Quizzes: 6

Number of Curriculum Items: 37

Number of Published Curriculum Objects: 37

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 2022 on Windows

What are the major new enhancements and features in SQL Server 2022 and SSMS 19

How to use many of the new features and enhancements in SQL Server 2022 via live demos and guides

What are the new business continuity features and enhancements

What are the new security features and enhancements

What are the new performance features and enhancements

Other enhancements in SQL Server 2022 such as T-SQL enhancements, Azure Synapse Link and more

Who Should Attend

Professionals who work with previous versions of SQL Server and want to know whats new in SQL Server 2022.

Professionals 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 version of SQL Server.

Target Audiences

Professionals who work with previous versions of SQL Server and want to know whats new in SQL Server 2022.

Professionals 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 version of SQL Server.

In this course, you will learn all about the new major features and enhancements in SQL Server 2022. Via a comprehensive set of video lectures, enriched with step by step live demonstrations, you will learn about all the major features and enhancements in SQL Server 2022, such as: Bidirectional HA/DR to Azure SQL Managed Instance, Contained Availability Groups, SQL Server Ledger/Blockchain Ledger Tables and other security-related features, Query Store enhancements, Built-in Intelligent Query Processing Enhancements such as Parameter Sensitive Plan Optimization, Azure Synapse Link, T-SQL enhancements and much more.

MORE ABOUT THE COURSE:

SQL Server 2022, is the most Azure-enabled release of SQL Server yet. Besides the many new features and enhancements for the on-premises Database Engine, it also includes a large number of significant Azure integration features. In this course, we will be discussing all these, in order to get a clear picture about all the new features and enhancements in this version of SQL Server, that is SQL Server 2022.

We will begin the course by discussing about, how SQL Server evolved to a hybrid data platform, by listing the Azure integration features that were added in each release of SQL Server up to the 2022 version. Then, we will start discussing about the new features and enhancements, by first discussing about the Business Continuity features and enhancements such as Bidirectional HA/DR to Azure SQL Managed Instance, Contained Availability Groups and other related enhancements. Right after these, we will be discussing about the security features and enhancements. To this end, among other, we will be talking about SQL Server ledger tables and see a relevant live demonstration.

In the next section, we will be discussing about the Performance Features and Enhancements in SQL Server 2022, and more precisely, about the Query Store enhancements and Built-in Intelligent Query Processing enhancements and see some interesting live demonstrations on Query Store and Parameter Sensitive Plan Optimization.

Last but not least, we will be discussing about other features and enhancements, such as: Azure Synapse Link, Management Features & Enhancements and T-SQL Enhancements.

AFTER THE COURSE:

After completing the course, you will know:

How SQL Server evolved over the years and why this release, makes SQL Server a hybrid data platform

How to install and use SQL Server 2022 on Windows along with following the best practices

What are the new Business Continuity Features and Enhancements in SQL Server 2022

What are the new Security Features and Enhancements in SQL Server 2022

What are the new Performance Features and Enhancements in SQL Server 2022

Other significant new features and enhancements in SQL Server 2022, such as main T-SQL enhancements, Azure Synapse Link, Management Features & Enhancements, etc.

How you can start using many of these new features and enhancements

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

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?

Lecture 2: SQL Server 2022 Overview: A Hybrid Data Platform

Lecture 3: Setting up our Demo Environment – Installing SQL Server 2022 & SSMS

Lecture 4: Section Recap

Chapter 2: Business Continuity Features and Enhancements

Lecture 1: Section Overview

Lecture 2: Bidirectional HA/DR to Azure SQL Managed Instance

Lecture 3: Availability Group-Related and Other Enhancements

Lecture 4: Section Recap

Chapter 3: Security Features and Enhancements

Lecture 1: Section Overview

Lecture 2: SQL Server Ledger – Blockchain Ledger Tables

Lecture 3: Demo: SQL Server Ledger

Lecture 4: Other Security Enhancements

Lecture 5: Section Recap

Chapter 4: Performance Features and Enhancements

Lecture 1: Section Overview

Lecture 2: Query Store Enhancements

Lecture 3: Demo: Query Store

Lecture 4: Built-in Intelligent Query Processing Enhancements

Lecture 5: Demo: Parameter Sensitive Plan Optimization

Lecture 6: Other Performance Improvements

Lecture 7: Section Recap

Chapter 5: Other Features and Enhancements

Lecture 1: Section Overview

Lecture 2: Azure Synapse Link

Lecture 3: Management Features & Enhancements

Lecture 4: T-SQL Enhancements

Lecture 5: Demo: T-SQL Enhancements

Lecture 6: Section Recap

Chapter 6: Special Topics (Updated)

Lecture 1: Section Overview

Lecture 2: New Fixed Server-Level Roles

Lecture 3: Demystifying SQL Server 2022: Common Questions and Answers (New)

Chapter 7: Putting it All Together

Lecture 1: What you’ve Learned in this Course

Chapter 8: Learning More

Lecture 1: Bonus Lecture

Instructors

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

Rating Distribution

1 stars: 1 votes

2 stars: 0 votes

3 stars: 3 votes

4 stars: 18 votes

5 stars: 22 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!