uCertify

SQL Server 2019 Lab

(SQL-SVR-2019.AP1.0L0)
Lab
Get A Free Trial

Skills You’ll Get

Download Course Outline

1

Getting started with SQL Server tools

  • Exporting Data with the Import/Export Wizard
2

Introducing database server components

  • Installing the Failover Cluster Feature
3

Designing and implementing an on-premises database infrastructure

  • Designing Multiple Filegroups
4

Installing and configuring SQL Server instances and features

  • Installing SQL Server Analysis Services
  • Installing SQL Server Integration Services
5

Installing and configuring SQL Server on Linux

  • Configuring SQL Server
6

Provisioning and configuring SQL Server databases

  • Creating a SQL Login
  • Using the ALTER Command with the ROLLBACK IMMEDIATE Command
7

Understanding table features

  • Creating a Table
8

Maintaining and monitoring SQL Server

  • Using CHECKDB
  • Managing Resource Utilization Using Resource Governor
9

Automating SQL Server administration

  • Configuring Database Mail
10

Developing, deploying, and managing data recovery

  • Creating a Differential Backup
  • Creating a Full Database Backup
11

Implementing high availability and disaster recovery

12

Administering security and permissions

  • Granting Permissions to Create Tables
13

Protecting data through encryption, privacy and auditing

  • Creating a New Server Audit and Configuring a Server Audit Specification
14

Performance tuning SQL Server

  • Optimizing Queries
15

Understanding and designing indexes

  • Creating a Non-Clustered Index
  • Creating a Columnstore Index
  • Configuring Full-Text Indexing
16

Designing and implementing hybrid and Azure database infrastructure

  • Creating a Virtual Machine in Azure

Related Courses

All Courses