SQL Server 7 Admin: Security Strategy

Products

Resources

Specials

Summary:

This training course shows users how to plan the security policies for a SQL Server 7 installation.

Objectives:

After completing this training course , students will be able to:

Assess whether to use Microsoft Windows NT or Microsoft SQL Server accounts
Decide whether to use the Windows NT group structure for a SQL Server 7.0 installation
Plan the use and structure of SQL Server roles
Assess whether to map Windows NT groups directly into a database or use SQL Server logins
Choose which NT accounts will be used to run SQL Server services
Plan an n-tier application security strategy and determine whether to use application roles or other mid-tier security mechanisms such as Microsoft Transaction Server
Plan the security requirements for linked databases

Outline:

SQL Server Authentication Methods
Using Windows NT Groups
Planning the Use of SQL Server Roles
Developing a Security Strategy
Other Security Issues

Features:

Exercises that allow users to practice the application
A file containing the text of the exercises
Activities that allow users to apply training course concepts in an interactive questioning environment
A glossary
A Skill Assessment

Applicability:

This training course is for database administrators who want to learn how to administer SQL Server 7.0, or who are preparing for the MCSE exam 70-028: Administering Microsoft SQL Server 7.0.

Prerequisites:

Experience working with relational database systemsPrevious training course s in, or experience with, NT Server administrationtraining course s on Database Concepts or equivalent experiencetraining course s on SQL or equivalent experience

Technical Requirements:

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 95, 98, NT, 2000, or XP. Minimum Connection Speed: 28.8k. Internet Explorer 5.0 or higher required. Authorware and Macromedia Flash player recommended but not required. JavaScript must be enabled. Netscape and AOL browsers not supported.

Copyright Information:

Microsoft® is a registered trademark of Microsoft Corporation.

Terms of Use:

None