Microsoft SQL Server 7 Admin - Security Strategy

Summary:

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

This lesson is part of our Microsoft SQL Server 7 Admin online training series which contains over 60 hours of self-paced courseware. Our web-based training provides 6 months of unlimited access.

Objectives:

After completing this course you 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

Applicability:
This course is for anyone who wants to get the most out of using Microsoft SQL Server 7 Admin.

Prerequisites: None:

Technical Requirements:

• Internet connection
• Browser: Internet Explorer, FireFox, Chrome, Safari, Opera or any standards compliant browser.
• Authorware and Macromedia Flash player recommended but not required.
• JavaScript must be enabled.

Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 6 months of unlimited access (1 user), includes a variety of features and all courses qualify for Continuing Education Unit credit.

StaffKit is an e-learning leader in providing computer training tutorials and online education. We have satisfied customers in over 75 countries using our online training courses. We have been a leading provider of self-paced web based training for the past 10 years.