Administering Databases

Practice Labs Module
Time
40 minutes
Difficulty
Intermediate

The "Administering Databases" module provides you with the instruction and server hardware to develop your hands on skills in the defined topics. This module includes the following exercises: 1) Securing Databases, 2) Backing up and Restoring Database

Join over 3 million cybersecurity professionals advancing their career
Sign up with
or

Already have an account? Sign In »

Overview

Introduction

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

  1. Securing Databases
  2. Backing up and Restoring Database

Exercise 1- Securing Databases

In this exercise, you will learn the following in Microsoft SQL Server 2008 R2:

  • Create logins and users for a database using T-SQL and using SSMS
  • Grant database permissions and roles using T-SQL and using SSMS

Exercise 2 - Backing up and Restoring Database

In this exercise, you will learn the following in Microsoft SQL Server 2008 R2:

  • Create a full, differential, and transaction log database backups using T-SQL and SSMS
  • Restore a database using T-SQL and SSMS
Learning Partner
Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.