SQL Server 2019: What’s New - New and Enhanced Features

Dive into SQL Server 2019 with this comprehensive course designed to unlock its powerful new features and enhancements. Learn in an engaging, interactive way through video lectures, step-by-step live guides, and practical demonstrations. This course covers both SQL Server 2019 on Windows and SQL Server 2019 on Linux, giving you a versatile skillset.

What makes SQL Server 2019 so exciting? This release of the SQL Server Data Platform boasts a wealth of new capabilities alongside improvements to existing ones. You'll gain hands-on knowledge of these features through practical exercises.

Here's what you'll discover:

• SQL Server Evolution: Understand how SQL Server has evolved over the years and the key features introduced in each version.
• Performance Enhancements: Explore the new performance improvements in SQL Server 2019 and how to leverage them.
• Security & Compliance: Learn about the latest security enhancements and compliance features in SQL Server 2019.
• High Availability: Discover the new high availability capabilities of SQL Server 2019.
• Development Enhancements: Explore new development features to streamline your SQL development process.
• SQL Server Management Studio (SSMS) 18.0: Master the new and enhanced built-in tools in SQL Server Management Studio, including the Vulnerability Assessment Tool and Data Classification Tool.
• Key Enhancements: Get in-depth knowledge of other significant enhancements in this new version of SQL Server.
• Practical Application: Learn how to effectively utilize these new features and enhancements in your projects.
• Linux Deployment: Gain the skills to install and use SQL Server 2019 on Linux.

Who is this course for?

This course is ideal for anyone with a basic understanding of SQL Server from previous versions and a foundational knowledge of database principles.

Course Highlights:

• 3+ hours of video lectures: Benefit from high-quality video instruction with live demonstrations and practical guides.
• 6 Quizzes: Test your understanding with useful quizzes after each section.
• Downloadable Resources: Access valuable resources to support your learning.
• Practice Test: Prepare for certification with a comprehensive practice test.
• Instructor Q&A: Get your questions answered directly by the instructor.
• Certificate of Completion: Receive a certificate upon successful completion of the course.

Prerequisites: Basic SQL Server knowledge and understanding of database principles.