New Online Course – SQL Server 2019: What’s New

New Online Course – SQL Server 2019: What’s New

New Online Course – SQL Server 2019: What’s New

Hi folks! I’m proudly announcing the general availability of my new online course titled: SQL Server 2019 – What’s New!

 

What will i learn in this course?

In this course, you can learn in an interactive and efficient way, about all the major new features and enhancements in SQL Server 2019 categorized as per below categories:

  • 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
  • Special Topics
    • About Special Topics
    • New DMF sys.dm_exec_query_plan_stats
    • Transparent Data Encryption (TDE) Scan – Suspend and Resume
    • New Default Truncation Message
  • SQL Server 2019 on Linux
    • How to Install SQL Server 2019 on Ubuntu Linux
    • How to Install and use the SQL Server command-line tools on Ubuntu Linux
    • How to Access SQL Server 2019 on Ubuntu Linux using Azure Data Studio
    • How to Perform an Offline Installation of SQL Server 2019 on Ubuntu Linux

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, that will help you test your knowledge regarding the new and enhanced features in SQL Server 2019 and SSMS 18.0.

 

Enroll Now with Discount!

 

What does the course offer?

This course contains/offers:

  • 2 hours of high-quality video with live demonstrations
  • Downloadable resources
  • Six useful quizzes for testing your knowledge on each section
  • 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 refund policy
  • Certificate on course completion

 

Course Preview

 

Enroll Now!

Enroll now to the course with special discount!

Enroll Now with Discount!

 

 

Check Also: My Other Online Courses

 

Rate this article: 1 Star2 Stars3 Stars4 Stars5 Stars (3 votes, average: 5.00 out of 5)

Loading... 

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

© SQLNetHub

 

Artemakis Artemiou
Artemakis Artemiou is a Senior SQL Server Architect, Author, and a 9 Times Microsoft Data Platform MVP (2009-2018). He has over 15 years of experience in the IT industry in various roles. Artemakis is the founder of SQLNetHub and TechHowTos.com. Artemakis is the creator of the well-known software tools Snippets Generator and DBA Security Advisor. Also, he is the author of many eBooks on SQL Server. Artemakis currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA). Artemakis's official website can be found at aartemiou.com.