This course is not meant to be an introduction to SQL Server 2019. It assumes prior knowledge of a previous release in order to have a frame of reference for how the product’s features have been improved. If you’re new to SQL Server, consider Adam’s Essential Training course to get up to speed before coming back to this course.
- [Instructor] To get the most out of this course, you should a working knowledge of a pervious version of SQL Server and Management Studio so that you'll have a frame of reference on how the new features that I'll cover build upon existing capabilities. You won't need to be familiar with every feature that SQL Server 2019 touches, though, as I'll describe the current state before the upgrade as well as how the features have been improved. I won't be going over how to build databases or how to write T-SQL scripts in this course, though. So if you're brand new to SQL Server, consider starting with my SQL Server 2019 Essential Training's course first. Then you could come back here better prepared to understand what's new.
- Intelligent query processing
- Improvements to persistent memory
- Table virtualization with PolyBase
- Creating a unified data cluster
- Training and creating machine learning models
- Running SQL Server in containers
- Updates to the SQL Server Management Studio (SSMS)