Kurs 73477 - Microsoft SQL Server 2000 Database Administration Part 3: Security and Data Recovery
Ziele- Identify how login accounts are processed. - Identify the characteristics of the two authentication modes. - Sequence the steps to implement an authentication mode. - Identify the guidelines for preventing data loss. - Match database recovery models with their features. - Identify the process behind SQL Server 2000 backup.
AnforderungenCandidates for this exam operate in medium to very large computing environments that use SQL Server 7.0 (and plan to upgrade to SQL Server 2000), Windows 2000 Active Directory, and Internet Information Server (IIS). They have a minimum of one year's experience administering SQL Server environments. General categories include system administrators, database administrators, application developers, systems analysts, and software engineers. Students are expected to have an understanding of basic relational database concepts. Students should be familiar with basic transact-SQL syntax.
TitelKurs 73477 - Microsoft SQL Server 2000 Database Administration Part 3: Security and Data Recovery
InhaltCourse Overview
This is the third course in a five part series that deals with the backup and restore strategies for SQL Server 2000 and with managing security and permissions with SQL Server 2000.
Deployment Options
Self-Study
Accreditation
CEU credits: 0.70 CEUs
Total Learning Time
6 to 8 hours
Objectives
Unit 1: Security 3 hours
- Identify the characteristics of the two authentication modes.
- Sequence the steps to implement an authentication mode.
- Identify the properties of a SQL Server login.
- Configure SQL Server 2000 to use Windows Authentication Mode.
- Authorize Windows 2000 users and groups to access SQL Server 2000.
- Test the logins created for Windows 2000 user and group accounts.
- Revoke access from a Windows 2000 user or group.
- Deny access to a Windows 2000 group or user.
- Identify the methods for assigning a login account to user accounts.
- Match fixed server roles with their permissions.
- Identify features of fixed database roles in SQL Server 2000.
- Identify the features of user-defined database roles.
- Create a user-defined database role.
- Identify types of permissions.
- Identify guidelines for managing permissions.
- Identify the methods for revoking granted and denied permissions.
- Assign statement permissions by using SQL Server Enterprise Manager.
- Assign object permissions by using SQL Server Enterprise Manager.
- Identify the guidelines for managing security with views and stored procedures.
- Implement permissions by using views and stored procedures.
- Identify the features of application roles in managing client application security.
- Create an application role.
- Activate an application role.
Unit 2: Backup and Restore Strategies 3 - 5 hours
- Identify the guidelines for preventing data loss.
- Match database recovery models with their features.
- Identify the process behind SQL Server 2000 backup.
- Identify when to back up system databases.
- Identify when to back up a user database.
- Identify the guidelines for creating a backup device.
- Create a backup device by using SQL Server Enterprise Manager.
- Create a backup device by using Transact-SQL.
- Identify the guidelines for using multiple backup files to store backups.
- Identify the guidelines for using the BACKUP DATABASE statement.
- Identify the features of backing up to a tape device.
- Identify guidelines for performing a full database backup.
- Back up a database.
- Back up a database to multiple files.
- Identify guidelines for performing a differential backup.
- Identify the process for implementing a transaction log backup.
- Identify guidelines for clearing the transaction log.
- Backup a transaction log.
- Identify the reasons for performing a database file and filegroup backup.
- Sequence stages of the SQL Server 2000 recovery process.
- Identify the functions of the RESTORE statements for verifying backups.
- Identify the tasks that you must perform before restoring a backup.
- Match RESTORE DATABASE statement options with their functions.
- Identify guidelines for initiating the recovery process.
- Identify guidelines for restoring from a full database backup.
- Identify guidelines for restoring from a differential backup.
- Restore a full database backup.
- Identify guidelines for restoring a transaction log backup.
- Restore a transaction log backup.
- Sequence the steps to restore a damaged system database.
Course Access
Each student has access to the course for a period of 6 months from the day of enrollment in the course.
Ähnliche angebote die in bezug zu ihrer anfrage "microsoft" stehen