|
Provided by: Serebra Learning Corporation MS SQL Server 2000: Database Administration Part 3: Security and Data RecoveryMS SQL Server |
 |
Training
Provided by Serebra Learning Corporation
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.
|
|
||||||||||
MS SQL Server 2000: Database Administration Part 3: Security and Data Recovery
Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada
Audience
Candidates 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.
Objective
- 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.
Topics Include
Unit 1: Security
- Identify how login accounts are processed.
- 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
- 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.
Duration
7
Minimum Requirements
The CDROM version of this course requires:
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
- At least a double speed CDROM drive.
- An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM and 22MB available hard disk space or file server space.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
Media
Web Based Training
Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
