Microsoft SQL Server 2019: New Features
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.
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
- Intelligent Query Processing
- Improvements to persistent memory
- Secure enclaves
- Resumable online index create
- UTF-8 support
- Certification management
- Always On availability groups
- PolyBase connections
- Scale-out groups
- Create a unified data cluster
- SQL Server, Apache Spark, and HDFS
- Train and create machine learning models
- Big data tools
- Updates to Linux installations
- Running SQL Server in containers
- Enhancements to MLS
- Management Studio 18.0
- Integration with Azure Data Studio
- Query Tuning Assistant
- SQL Data Discovery and Classification
- Next steps
Taught by
Adam Wilbert
Related Courses
Reviews
0.0 rating, based on 0 reviews