Microsoft SQL Server 2019

The SQL Server 2019 course and lab provide knowledge and skills required to plan, implement, manage, and secure SQL Server 2019. The lab provides a hands-on learning experience in a safe and online environment.

This SQL Server course covers topics such as SQL Server 2019’s toolset, SQL Server management studio, Azure data studio, configuration manager, and more. This SQL training course also helps in understanding basic and advanced concepts associated with SQL Server Administration.

Course Outline

Lesson 1: Introduction

Lesson 2: Getting Started with SQL Server tools

Lesson 3: Introducing database server components

Lesson 4: Designing and implementing an on-premises database infrastructure

Lesson 5: Installing and configuring SQL Server instances and features

Lesson 6: Installing and configuring SQL Server on Linux

Lesson 7: Provisioning and configuring SQL Server databases

Lesson 8: Understanding table features

Lesson 9: Maintaining and monitoring SQL Server

Lesson 10: Automating SQL Server administration

Lesson 11: Developing, deploying, and managing data recovery

Lesson 12: Implementing high availability and disaster recovery

Lesson 13: Administering security and permissions

Lesson 14: Protecting data through encryption, privacy and auditing

Lesson 15: Performance tuning SQL Server

Lesson 16: Understanding and designing indexes

Lesson 17: Designing and implementing hybrid and Azure database infrastructure

Lesson 18: Provisioning Azure SQL Database

Lesson 19: Provisioning Azure SQL Database managed instance

Lesson 20: Migrating to SQL Server solutions in Azure

Lesson 21: Leveraging big data and machine learning