What you'll learn:
- How to download and install SQL Server 2019 on both Windows and Linux.
- What are the major new enhancements and features in SQL Server 2019 and SSMS 18.x
- How to use many of the new features and enhancements in SQL Server 2019 via live demos and guides
- What are the new Performance enhancements
- What are the new Security and Compliance enhancements
- What are the new High Availability enhancements
- What are the new Development-related enhancements
- How to download and install SQL Server Management Studio (SSMS) v18.0
In this course, you will learn all about the new major features and enhancements in SQLServer 2019, in an understandable and interactive way, via a rich set of video lectures and step-by-step live guides and demonstrations. Moreover, besides SQLServer 2019 on Windows, we are going to install and use SQLServer 2019 on Linux.
WHAT OTHER STUDENTS SAY ABOUT THE COURSE:
Great course, very understandable, very well constructed!! Worth my time absolutely!
The instructor makes it really easy to understand the new features in SQL Server 2019.
This course greatly helped me to understand the new features of SQL Server 2019. Very detailed and well presented course !!
MORE ABOUT THE COURSE:
SQLServer 2019, is the latest release of the powerful SQLServer. This is an exciting new version of the SQL Server Data Platform, with a plethora of new features, as well as with enhancements to existing features. In this course, we will go through all the new features and enhancements in SQLServer 2019, talk about it, as well as see many live demonstrations and guides that will help get hands on knowledge on how you can use these features. Moreover, we are will work with SQLServer 2019 on Linux.
AFTER THE COURSE:
You will know the below:
How SQLServer evolved over the years and the different main features shipped with each version
What are the new Performance enhancements in SQL Server 2019
What are the new Security and Compliance enhancements in SQL Server 2019
What are the new High Availability enhancements in SQL Server 2019
What are the new Development-related enhancements in SQL Server 2019
What are the new and enhanced built-in tools in SQLServer Management Studio 18.0 and how to use them such as:
Vulnerability Assessment Tool
Data Classification Tool
Other significant enhancements in this new release of SQLServer
How you can use many of these new features and enhancements
How to install and use SQLServer 2019 on Linux
PREREQUISITES:
Basic SQL Server knowledge in prior versions of SQL Server
Basic database principles
THIS COURSE OFFERS:
3+ hours of high-quality video lectures with live demonstrations and guides
6 useful quizzes for testing your knowledge on each section
Useful downloadable resources
A practice test in the end of the course
Ability to ask the instructor questions related to the course via the Q&Asection
Certificate on course completion
