SQL Server 2019: What’s New (Online Course)

In our “SQL Server 2019: What’s New” course on Udemy, you will learn about all major new features and enhancements in SQL Server 2019. Via a 1-hour journey with a combination of lectures, live demonstrations, quizzes and a practice test, you will get up to date with SQL server 2019 in no time!

What will you learn with this course:

  • What are the new features in SQL Server 2019
  • What are the existing feature enhancements in SQL Server 2019
  • See live demonstrations for many of those features and enhancements!

 

Enroll Now with Discount

 

Below, you can watch a preview of the course.

 

 

Course Curriculum

More specifically, the “SQL Server 2019: What’s New” course, focuses on the below areas:

  • About SQL Server 2019 and SSMS 18.0
    • SQL Server evolution over the years and major features
    • System requirements of SQL Server 2019 and installation (with live demonstration)
    • System requirements for SSMS v18.0 and installation (with live demonstration)
  • Performance
    • Performance enhancements
      • Intelligent Query Processing (with live demonstrations)
        • Batch mode on row store
        • Row mode memory grant feedback
        • Table variable deferred compilation
        • Approximate COUNT DISTINCT
        • Scalar UDF inlining
      • Expanded Support for Persistent Memory Devices
      • Hybrid Buffer Pool
      • Columnstore Statistics in DBCC CLONEDATABASE
      • Lightweight Query Profiling Infrastructure
  • Security and Compliance
    • Security and Compliance Enhancements (with live demonstrations)
      • Always Encrypted with Secure Enclaves
      • Data Discovery and Classification
      • Certificate Management in SQL Server Configuration Manager
      • Vulnerability Assessment
  • High Availability
    • High Availability enhancements
      • Enhancements for Availability Groups
      • High Availability with Remote Storage On Kubernetes
      • Online Operations
  • Development
    • Development-related enhancements (with live demonstrations)
      • UTF-8 Support
      • Java Language Programmability Extension
  • Other Enhancements
    • Other significant enhancements
      • SQL Server on Linux Enhancements
      • Big Data
      • sp_estimate_data_compression_savings

After each section, a quiz follows that will help you test your knowledge on what you’ve learned in that section.

Also, in the end of the course, there is a practice test with 15 questions, that will help you test your knowledge on SQL Server fundamentals.

 

Enroll Now with Discount

 

SQL Server 2019: What's New? - Online Course by Artemakis Artemiou

 

Enroll using Coupon on Udemy

Enroll Now with Discount!

 

Enroll on Skillshare

Enroll to this course on Skillshare

 

Reference: SQLNetHub.com (https://www.sqlnethub.com)

© SQLNetHub