Description
This is the second course in a five part series that will provide students with the knowledge to install, configure, administer and troubleshoot Microsoft SQL Server 7.0.
Audience
This course is designed for IT professionals responsible for installing, configuring, administering and troubleshooting Microsoft SQL Server 7.0. Participants should have completed the first course in this series.
Prerequisites
(Currently no course prerequisite information)
Objective
- Work with Microsoft SQL Server 7.0, its architecture, security, and database structure.
- Understand the basics of SQL Server databases and how to create databases and other objects.
- Modify databases; manage data on multiple disks; assess database size requirements and to plan for growth.
Topics Include
Unit 1: Managing Security - Identify the elements of Windows NT Authentication.
- Identify the benefits of SQL Server Authentication.
- Sequence the steps to implement server authentication using Enterprise Manager.
- Perform the steps for setting Mixed Mode authentication using Enterprise Manager.
- Identify the three types of security accounts available for login creation.
- Perform the steps for adding a Windows NT login using Enterprise Manager.
- Perform the steps for adding a SQL Server login using Transact-SQL.
- Perform the steps to assign a login to a user account in SQL Server using Enterprise Manager.
- Identify the two types of default user accounts.
- Match each server role with the permission.
- Perform the steps for assigning logins to Fixed Server Roles using Transact-SQL.
- Match each database role with the permission.
- Perform the steps for assigning logins to Fixed Database Roles using Enterprise Manager.
- Perform the steps for creating User-Defined Database roles.
- Perform the steps to assign a security account to a User-Defined Database Role using Transact-SQL.
- Identify the three types of permissions for logins.
- Match each permission state with the definition.
- Perform the steps for granting permissions using Transact-SQL.
- Perform the steps for denying permissions using Enterprise Manager.
- Perform the steps for revoking granted or denied permissions using Transact-SQL.
- Identify the properties of default administrator logins.
- Deduce the function of a Guest User Account.
- Deduce the best use for the public Role Permissions.
- Map logins to user accounts and roles.
- Identify the recommended Fixed Database Roles used for object creation.
- Identify the principles of planning security for linked databases.
- Identify how views and stored procedures can be used to simplify security.
- Distinguish between application roles and other roles.
- Perform the steps for creating an application role for users/logins within SQL Server Enterprise Manager.
- Perform the steps for activating an application role for users/logins using Transact-SQL.
- Identify the recommended practices for security implementation.
Unit 2: SQL Server Database Basics - Match each data storage term with its description.
- Sequence the steps for the transaction logging process.
- Perform the steps for creating a database using Enterprise Manager.
- Identify the tasks involved in implementing a full-text search.
- Perform a simulation using the Full-Text Indexing Wizard.
- Perform the steps to schedule a full-text index population.
- Match each frequently used database option with its function.
- Perform the steps for setting database options using Enterprise Manager.
- Perform the steps to view options for all databases using Transact-SQL.
Unit 3: Managing Databases - Identify the methods of managing data and log file growth.
- Perform the steps for adding a data and transaction log file to a database using Enterprise Manager.
- Perform the steps for expanding a transaction log using Enterprise Manager.
- Perform the steps for shrinking a database using Enterprise Manager.
- Perform the steps for dropping a database using Transact-SQL.
- Match the RAID levels with their description.
- Identify the benefits of using files and filegroups.
- Perform the steps for creating a filegroup using Transact-SQL.
- Perform the steps to change the default filegroup using Transact-SQL.
- Identify the benefits of using clustering.
- Sequence the steps for estimating the number of pages required for a table.
- Identify the actions that may be taken to affect system performance.
Duration
8
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).
The network 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 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
|
