Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certifications Network & Security Hardware Operating Systems & Servers Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Paid Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement & Gardening Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition & Diet Yoga Mental Health Martial Arts & Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js Typescript HTML5 PHP
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA CompTIA Security+ Microsoft AZ-900
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Data Analysis Data Warehouse Blockchain Business Intelligence
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Mobile Game Development
Google Flutter iOS Development Android Development Swift React Native Dart (programming language) Kotlin SwiftUI Mobile App Development
Graphic Design Photoshop Adobe Illustrator Drawing Canva Digital Painting InDesign Design Theory Procreate Digital Illustration App
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Life Purpose Mindfulness Sound Therapy Emotional Intelligence Coaching
Business Fundamentals Entrepreneurship Fundamentals Freelancing Business Strategy Online Business Startup Business Plan Blogging Amazon Kindle Direct Publishing (KDP)
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Copywriting Google Analytics Email Marketing Startup Advertising Strategy

DevelopmentDatabase Design & DevelopmentSQL Server

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

Learn what's new and enhanced in SQL Server 2019 such as Intelligent Query Processing and much more
Rating: 4.4 out of 54.4 (232 ratings)
856 students
Created by Artemakis Artemiou
Last updated 4/2022
English
English [Auto]

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

Artemakis Artemiou
Award-Winning Database Expert, Trainer, Author, Speaker.
Artemakis Artemiou
  • 4.4 Instructor Rating
  • 1,422 Reviews
  • 9,181 Students
  • 13 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!

Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Terms
  • Privacy policy
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.