Companies Home Search Profile

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

Focused View

Artemakis Artemiou

3:16:38

66 View
  • 1 - Welcome to the Course What will you Learn.mp4
    03:37
  • 1 - About SQL Server 2019 and SSMS 180.html
  • 2 - Section Overview.mp4
    00:48
  • 3 - SQL Server Evolution.mp4
    04:31
  • 3 - Supported-SQL-Server-Versions-and-their-End-Dates-SQL-Server-2019-Course.pdf
  • 4 - Downloading and Installing SQL Server 2019.mp4
    17:27
  • 5 - Downloading and Installing SQL Server Management Studio v18.mp4
    06:52
  • 6 - SQL2K19-Section-2-Summary.pdf
  • 6 - Section Recap.mp4
    00:59
  • 2 - Performance Enhancements.html
  • 7 - Section Overview.mp4
    00:56
  • 8 - Performance Enhancements.mp4
    16:02
  • 9 - SQL2K19-Section-3-Summary.pdf
  • 9 - Section Recap.mp4
    01:02
  • 3 - Security and Compliance.html
  • 10 - Section Overview.mp4
    01:34
  • 11 - Security and Compliance Enhancements.mp4
    19:24
  • 12 - SQL2K19-Section-4-Summary.pdf
  • 12 - Section Recap.mp4
    00:54
  • 4 - High Availability.html
  • 13 - Section Overview.mp4
    00:33
  • 14 - High Availability Enhancements.mp4
    02:24
  • 15 - SQL2K19-Section-5-Summary.pdf
  • 15 - Section Recap.mp4
    00:47
  • 5 - Development.html
  • 16 - Section Overview.mp4
    00:37
  • 17 - DevelopmentRelated Enhancements.mp4
    07:25
  • 18 - SQL2K19-Section-6-Summary.pdf
  • 18 - Section Recap.mp4
    00:52
  • 6 - Other Enhancements.html
  • 19 - Section Overview.mp4
    00:39
  • 20 - Other Enhancements.mp4
    02:37
  • 21 - SQL2K19-Section-7-Summary.pdf
  • 21 - Section Recap.mp4
    00:53
  • 7 - SQL Server 2019 on Linux.html
  • 22 - About this Section.mp4
    01:07
  • 23 - How to Install SQL Server 2019 on Ubuntu Linux.mp4
    08:39
  • 24 - How to Install the SQL Server commandline tools on Ubuntu Linux.mp4
    05:57
  • 25 - How to Access SQL Server 2019 on Ubuntu Linux using Azure Data Studio.mp4
    11:00
  • 26 - How to Perform an Offline Installation of SQL Server 2019 on Ubuntu Linux.mp4
    11:36
  • 27 - How to Install SQL Server 2019 on CentOS Linux.mp4
    11:11
  • 28 - Section Recap.mp4
    01:04
  • 29 - About Special Topics.mp4
    01:02
  • 30 - New DMF sysdmexecqueryplanstats.mp4
    02:14
  • 31 - Transparent Data Encryption TDE Scan Suspend and Resume.mp4
    06:00
  • 32 - New Default Truncation Message.mp4
    04:14
  • 32 - Special-Topics-Links.pdf
  • 33 - How to Enable Stretch Database in SQL Server 2019.mp4
    15:37
  • 34 - Dynamic Data Masking in SQL Server.mp4
    07:24
  • 35 - Working with Temporal Tables in SQL Server 2019.mp4
    09:38
  • 1 - Practice Test for SQL Server 2019 Whats New New and Enhanced Features.html
  • 36 - SQL2K19-Course-Summary.pdf
  • 36 - What Have You Learned in this Course.mp4
    02:02
  • 37 - Bonus Lecture.mp4
    07:00
  • 37 - Bonus-Lecture-Links-Updated.pdf
  • Description


    Learn what's new and enhanced in SQL Server 2019 such as Intelligent Query Processing and much more

    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

    Who is this 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.
  • More details


    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.

    User Reviews
    Rating
    0
    0
    0
    0
    0
    average 0
    Total votes0
    Focused display
    Artemakis Artemiou
    Artemakis Artemiou
    Instructor's Courses
    Artemakis is a Senior Database and Software Architect and a former Microsoft Data Platform MVP (awarded for 9 consecutive years). He has over 20 years of experience and he has taught thousands of people to efficiently work with SQL Server, Data Access/Entity Framework, Azure, .NET/C#, Programming and more, via his video tutorials, blog and guest articles, public speaking, eBooks and online courses.Artemakis is the founder of the SQLNetHub and {essentialDevTips} communities and published hundreds of articles and videos that explain in simple words, how to perform complex technical tasks and he really enjoys the interaction with the technical communities.Besides his regular blogging activities, Artemakis is also a guest author on many prestigious online technology journals.Moreover, he currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA).Artemakis, really enjoys sharing hands-on knowledge on a large set of technology topics, and thus helping his fellow tech community members, to easily start using these great technologies. To this end, he is really looking forward to seeing you in his online courses on Udemy!
    Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.
    • language english
    • Training sessions 37
    • duration 3:16:38
    • English subtitles has
    • Release Date 2023/05/18

    Courses related to SQL Server

    Courses related to Database Programming