Ongoing, regular administration is critical to the security and perfmance of databases such as acle and SQL Server. It's also a key topic of the Microsoft Technology Associate (MTA) Exam. Whether you're studying to pass the test simply to keep your admin skills up to date, this course will cover the most current techniques and best practices f administering a database. Adam Wilbert covers the ce concepts, including securing the server with user authentication and roles, assigning object-level permissions, and perfming a backup and reste.
Along the way, he'll provide tips f wking with SQL Server Management Studio and some challenges to help you practice what you've learned.
Note: This course will also prepare certification candidates f the "Administer a database" domain of the Microsoft Technology Associate (MTA) Exam 98-364, Database Administration Fundamentals.
* Securing the database server
* Understanding Windows authentication vs. SQL Server authentication
* Assigning fixed server roles and fixed database roles
* Granting object-level permissions
* Understanding ownership claims
* Creating backups
* Resting a database
I recommends Buy premimum account for High speed+parallel downloads!