Company: Linkedin Learning Author: Adam Wilbert Full Title: Microsoft SQL Server 2019: New Features Year: 2019 Language: English Genre: Educational: Databases Skill Level: Intermediate Price: €24.99 - Files: MP4 (+ Exercise Files, Subtitles .SRT) Time: 01:07:56 Video: AVC, 1280 x 720 (1.778) at 30.000 fps, 150 kbps Audio: AAC at 128 Kbps, 2 channels, 48.0 KHz 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. Lessons: 1. Introduction 01. What's new in SQL Server 2019 02. Make the most of the exercise files 03. What you should know 2. Database Engine Enhancements 04. Intelligent Query Processing 05. Improvements to persistent memory 06. Secure enclaves 07. Resumable online index create 08. UTF-8 support 09. Certification management 10. Always On availability groups 3. Table Virtualization with PolyBase 11. PolyBase connections 12. Scale-out groups 4. Big Data Clusters 13. Create a unified data cluster 14. SQL Server, Apache Spark, and HDFS 15. Train and create machine learning models 16. Big data tools 5. Beyond Windows 17. Updates to Linux installations 18. Running SQL Server in containers 6. Machine Learning Services 19. Enhancements to MLS 7. Updates to SSMS 20. Management Studio 18.0 21. Integration with Azure Data Studio 22. Query Tuning Assistant 23. SQL Data Discovery and Classification 8. Conclusion 24. Next steps Our members see more. Join us! ------------- Our members see more. Join us!