SQL Server 2019: What’s New - New and Enhanced Features
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
Requirements
- Basic SQL Server knowledge in prior versions of SQL Server
- Basic database principles
Description
In this course, you will learn all about the new major features and enhancements in SQL Server 2019, in an understandable and interactive way, via a rich set of video lectures and step-by-step live guides and demonstrations. Moreover, besides SQL Server 2019 on Windows, we are going to install and use SQL Server 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:
SQL Server 2019, is the latest release of the powerful SQL Server. 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 SQL Server 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 SQL Server 2019 on Linux.
AFTER THE COURSE:
You will know the below:
How SQL Server 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 SQL Server 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 SQL Server
How you can use many of these new features and enhancements
How to install and use SQL Server 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&A section
Certificate on course completion
Who this course is for:
- People who work with previous versions of SQL Server and want to know what is new in SQL Server 2019.
- People who have basic SQL Server knowledge and want to learn more about the latest version of SQL Server.
- Technology enthusiasts that explore new technologies and want to learn what’s new in this latest version of SQL Server.
Instructor
- 4.5 Instructor Rating
- 3,850 Reviews
- 18,010 Students
- 17 Courses
Hi, I’m Artemakis, and I’ve spent over 20 years immersed in the world of technology, specializing in AI, automation, databases, data management, cloud computing, and programming. My journey has allowed me to explore and master these fields, and now I’m excited to share my knowledge with you.
As a Certified Cloud, Database, and AI professional and a former Microsoft Data Platform MVP (nine years in a row), I’ve had the privilege of helping thousands of people sharpen their skills in SQL Server, Data Access/Entity Framework, Azure, .NET/C#, AI, Data Management and much more. Whether it’s through video tutorials, articles, public speaking, eBooks, or online courses, my goal is simple: to break down complex topics and make them accessible to everyone.
I’m also the founder of SQLNetHub and GnoelixiAI Hub, where I continue my mission of making advanced technology concepts easier to understand. Throughout my career, I’ve contributed to many renowned technology journals, and I truly enjoy the process of teaching and inspiring others to harness the power of cutting-edge technologies.
So, if you're ready to dive deeper into these fascinating fields and elevate your skills, I invite you to join me in one of my Udemy courses. Let’s embark on this learning journey together!