SQL Server 2019: What’s New

Learn all about the new features in SQL Server 2019! Stay up to date!

Hi, I'm Artemakis and I'd love to share with you What's New in SQL Server 2019!

What is SQL Server?

SQL Server is one of the world’s leading data platforms, that among other, allows you to:

  • Store, organize, and process your data with the use of Databases, and other Database Objects
  • Transform raw data into meaningful insights and knowledge
  • Process very large volumes of data (on disk and in-memory)
  • Perform Business Intelligence operations (i.e. set up a Data Warehouse)
  • Run complex analytics
  • Produce sophisticated reports
  • Work with encrypted data
  • Apply Machine Learning algorithms and operations against your data
    Data integrations, ETL, etc.
  • …and much more

Why Learn About the new Features in SQL Server 2019?

SQL Server 2019, is the brand new upcoming release of SQL Server. Packed with many new features and enhancements, more support for linux, as well as more integration with Azure, it is definitely a version of SQL Server for which you should be fully aware of what it can offer, and how you can make use of all these new features and enhancements.

By learning about the new features and enhancements in SQL Server 2019 and how you can use them, you will be ready to use one of the world’s leading data platforms at its full potential.

What can you do with SQL Server 2019?

With SQL Server 2019, you can do even more, compared to previous versions. For example, you can use its sophisticated performance-related enhancements such as: Approximate COUNT DISTINCT, Scalar UDF Inlining and Lightweight Query Profiling.

Moreover, you can use its new and enhanced security and compliance features such as: Data Discovery and Classification, native Certificate Management and Vulnerability Assessment.

Also, you can use its new high availability features, development-related features, its enhanced support for Linux and Big Data, and much more.

All these exciting new features and enhancements in SQL Server 2019, make it a “must” for all Database Professionals, to be fully educated about this new version of SQL Server, in order to utilize SQL Server 2019 at its full potential.

What's Included

  • SQL Server Evolution and Major Features
  • Downloading and Installing SQL Server 2019
  • Learn about the Security and Compliance Enhancements
  • Learn about the High Availability-Related Enhancements
  • Learn about the Development-Related Enhancements
  • Learn about SQL Server 2019 Support for Linux
  • Learn How to Use Azure Data Studio in Linux
  • Entity Framework Core
  • See Many Live Demonstrations and Guides
  • Special Topics
  • Lifetime Access
  • Enroll with Discount
  • Certificate of Completion
  • Regular Course Updates
  • Live Demonstrations

Learn about all the major new features and enhancements by the end of this course.

Prerequisites

  • Basic SQL Server knowledge in prior versions of SQL Server
  • Basic database principles

30-Day Money-Back Guarantee

Try it risk-free

I’m confident you’ll get everything you need from this course and be 100% satisfied. But in the unlikely event you decide it’s not for you just ask for a refund any time during the first 30 days and you’ll get your money back with no questions asked.

introduction-azure-sql

Your Instructor

Hi there, my name is Artemakis Artemiou. I love talking about SQL Server, .NET, Programming, Data Access, Azure Cloud Computing, and related topics, and make it easy for all to understand, by using a simple and understandable language as well as simple, step by step guides.

This has been the motto for my entire career, over the past 15 years: “Keep things simple“.

I’m a Senior SQL Server & Software Architect with over than 15 years of experience on SQL Server administration, development, performance tuning and architecture, as well as on .NET development (C#).  Moreover, I’m a former Microsoft Data Platform MVP (2009-2018), professional author, certified SQL Server Engineer, and founder of SQLNetHub.com and TechHowTos.com

MVP Reconnect - Databases and Programming with Artemakis

Course Curriculum

  • Welcome to the Course
    This is the introduction to the course. We will talk about how this course is structured and what will you learn after completing this course.
  • SQL Server Evolution
  • Downloading and Installing SQL Server 2019
  • Downloading and Installing SQL Server Management Studio v18.0
  • Performance Enhancements
  • Security and Compliance Enhancements
  • High Availability Enhancements
  • Development-Related Enhancements
  • Other Enhancements
  • About Special Topics
  • New DMF sys.dm_exec_query_plan_stats
  • Transparent Data Encryption (TDE) Scan – Suspend and Resume
  • New Default Truncation Message
  • How to Install SQL Server 2019 on Ubuntu Linux
  • How to Install and use the SQL Server command-line tools on Ubuntu Linux
  • How to Access SQL Server 2019 on Ubuntu Linux using Azure Data Studio
  • What we’ve Learned in this Course
    This lecture, is a recap on what we’ve learned in this course.

 

  • Bonus Lecture
    Bonus lecture, with next steps on learning more about SQL Server 2019, as well as, with special student-only discounts for my other online courses.

Frequently Asked Questions

  • When does the course start and finish?
    • This is a completely self-paced online course – you decide when you start and when you finish.

  • How long do I have access to the course?
    • By the time you enroll in the course, you have unlimited access to this course for as long as you like – across any and all devices you own.

  • What if I’m not satisfied with the course?
    • If you are unhappy with the course, you can request a refund in the first 30 days.

  • Do I get a certificate in the end of the course?
    • Yes. Right after you complete the course and pass the quizzes and practice test, Udemy will issue a certificate for successful completion of the course.

Enroll Now with Discount!

Enroll now to the course and save 90%!

This is a special time-limited offer!

The course is offered on the Udemy platform.

Discount Coupon Code: AR19LEARN

What my Other Students Say About the Course

This course greatly helped me to understand the new features of SQL Server 2019. Very detailed and well presented course !!
Andreas Josephides
Senior Database Architect
Great course, very understandable, very well constructed!! Worth my time absolutely!
Doros Demetriou
Senior Software Architect

Check my Other Courses

Feel free to check my other courses on the “Courses” section on my website.

There, you can find high-quality online courses on different SQL Server topics, Data Access, Azure/Cloud Computing and more!