DATABASE FOUNDATION - ADMINISTRATION

Database Foundations - Administration

Database administration is the function of managing and maintaining database management systems (DBMS) software. As such, corporations that use DBMS software often hire specialized information technology personnel called database administrators or DBAs.

Topics Cover In This Course

Introduction:

• Preparing for the MTA Exam 98-364
• Using the exercise files
• Challenges explained
• What you should know

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

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

Working with Fixed Database Roles:

• Granting access to a database
• Understanding fixed database roles
• Assigning fixed database roles

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

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

That Is All

Subscribe Our YouTube Channel And Stay Tuned

⇓

Brought To You Free By VJ SECURITY

⇓

Thank You