Database Fundamentals Administration

11/2015
1:14 hours

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