Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

MTA Database Fundamentals (98-364) Cert Prep: 4 Administration

via LinkedIn Learning

Overview

Discover the most current techniques and best practices for securing, backing up, and restoring databases.

Syllabus

Introduction
  • Welcome
  • Preparing for the MTA Exam 98-364
  • Using the exercise files
  • Challenges explained
  • What you should know
1. Securing the Database Server
  • Understanding security fundamentals
  • Securing the database server
  • Implementing server-level security in SQL Server Management Studio
  • Understanding Windows authentication
  • Creating a new Windows user
2. Enforcing Database Roles
  • Managing password policies
  • Understanding fixed server roles
  • Assigning server roles
  • Challenge: Creating a new user account
  • Solution: Creating a new user account
3. Working with Fixed Database Roles
  • Granting access to a database
  • Understanding fixed database roles
  • Assigning fixed database roles
4. Assigning Database Object Permissions
  • Understanding object permissions
  • Granting object-level permissions in SSMS
  • Granting user permissions to objects
  • Managing roles
  • Understanding ownership chains
  • Creating and using a guest account
  • Challenge: Assigning object permissions
  • Solution: Assigning object permissions
5. Creating Database Backups
  • Using SQL Server recovery models
  • Understanding the available backup options
  • Creating backups in SSMS
  • Restoring a database in SSMS
Conclusion
  • Next steps

Taught by

Adam Wilbert

Reviews

4.7 rating at LinkedIn Learning based on 117 ratings

Start your review of MTA Database Fundamentals (98-364) Cert Prep: 4 Administration

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.