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

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

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