Administering Databases

The Administering Databases Practice Lab provides you with the instruction and server hardware to develop your hands-on skills in the defined topics. This module includes the following exercises:

Overview

Learning Outcomes:

In this module, you will complete the following exercises:

  • Exercise 1 - Securing Databases

  • Exercise 2 - Backup and Restore a Database

After completing this lab, you will be able to:

  • Create logins and users for a database

  • Assign roles to users and granting permissions

  • Perform backup and restore using T-SQL

  • Perform backup and restore using SSMS

Exam Objectives:

The following exam objectives are covered in this lab:

  • 5.3 Summarize methods used to interface with databases.

  • 6.7 Explain business continuity concepts.

Note: Our main focus is to cover the practical, hands-on aspects of the exam objectives. We recommend referring to course material or a search engine to research theoretical topics in more detail.

Courses