|
Provided by: 123-CBT Computer Based Training SQL Server 7 0 System Administration - Part 2 |
 |
Training
Provided by 123-CBT Computer Based Training
Course Overview
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.
Learn To:
- Work with Microsoft SQL Server is and 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.
Content Emphasis
Skills-Based
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.
Total Learning Time
6 - 8 Hour(s)
Course Contents
Unit 1: Managing Security
Duration: 2 - 3 Hour(s)- 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
Duration: 2 - 3 Hour(s)- 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 functio
This is primarily online training 
This is an online eLearning or CBT training program 
This program may be available on CD 
Contact 123-CBT Computer Based Training for more information Training Presented in: English
SQL Server 7 0 System Administration - Part 2
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6. 10
- Access 2003
- Acrobat 6. 0
- ASP
- ASP. NET
- C
- Captivate 1. 0
- Crystal Reports 8. 5
- Crystal Reports v10
-...
