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

Hi there! I’m proudly announcing the general availability of my new online course titled: “SQL Server 2019 – What’s New (New and Enhanced Features)“!

 

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.5 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
• Certificate on course completion

 

Course Preview

 

Enroll Now!

Enroll now to the course with special discount!

Enroll Now with Discount!

 

Featured Online Courses:

• .NET Programming for Beginners: Windows Forms (C#)
• Boost SQL Server Database Performance with In-Memory OLTP 
• Essential SQL Server Administration Tips
• SQL Server Fundamentals (SQL Database for Beginners)
• The Philosophy and Fundamentals of Computer Programming
• Introduction to SQL Server Machine Learning Services
• Introduction to Azure SQL Database
• SQL Server 2019: What’s New
• Entity Framework: Getting Started (Ultimate Beginners Guide)
• How to Import and Export Data in SQL Server
• Get Started with SQL Server in 30 Minutes
• A Guide on How to Start and Monetize a Successful Blog

 

Read Also:

• What’s New in SQL Server 2019
• How to Offline Install SQL Server on Linux
• What are SQL Server Always On Availability Groups?
• Essential SQL Sever Administration Tips
• How to Patch a SQL Server Failover Cluster
• How to Add a Database to a SQL Server Availability Group Using T-SQL
• Top 10 SQL Server DBA Daily Tasks List
• The “Public” Database Role in SQL Server
• Encrypting a SQL Server Database Backup
• Learn Azure Data Lake Analytics by Example
• Azure Cosmos DB: Learn by Example
• How to Create an Azure SQL Server Virtual Machine
• How to Backup a SQL Server Database from On-Premises to Azure Storage
• … all our SQL Server Administration Articles

 

Rate this article: (4 votes, average: 5.00 out of 5)

Loading... 

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

© SQLNetHub