Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Provider Logo

Microsoft SQL Server 2019: New Features

via LinkedIn Learning

Overview

Learn about the new and improved features in SQL Server 2019, including support for big data clusters and machine learning services.

SQL Server 2019 offers a number of performance enhancements and new features, including support for big data clusters and machine learning services. In this course, Adam Wilbert helps you get up to speed with the latest and greatest in the powerful relational database management system. Learn about database engine enhancements, including improvements to persistent memory and UTF-8 support. Adam also goes over table virtualization with PolyBase, training and creating machine learning models, how Apache Spark and the Hadoop Distributed File System (HDFS) now work together in SQL Server, and other changes that are coming with the 2019 release.

Syllabus

Introduction
  • What's new in SQL Server 2019
  • Make the most of the exercise files
  • What you should know
1. Database Engine Enhancements
  • Intelligent Query Processing
  • Improvements to persistent memory
  • Secure enclaves
  • Resumable online index create
  • UTF-8 support
  • Certification management
  • Always On availability groups
2. Table Virtualization with PolyBase
  • PolyBase connections
  • Scale-out groups
3. Big Data Clusters
  • Create a unified data cluster
  • SQL Server, Apache Spark, and HDFS
  • Train and create machine learning models
  • Big data tools
4. Beyond Windows
  • Updates to Linux installations
  • Running SQL Server in containers
5. Machine Learning Services
  • Enhancements to MLS
6. Updates to SSMS
  • Management Studio 18.0
  • Integration with Azure Data Studio
  • Query Tuning Assistant
  • SQL Data Discovery and Classification
Conclusion
  • Next steps

Taught by

Adam Wilbert

Related Courses

Reviews

0.0 rating, based on 0 reviews

Start your review of Microsoft SQL Server 2019: New Features

Never stop learning Never Stop Learning!

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free