Course Status:	Released	Courseware Features
Course Language:	English
Course Duration:	5 Hours
Deployment Options:	Online, Interactive CDs, Network, Downloads, Intranet

Audience

Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition

Prerequisites

Experience working in a medium to enterprise computing environment that uses SQL Server 2000 Enterprise Edition; at least one year?s experience administering SQL Server; at least one year?s experience implementing relational databases in environments that contain heterogeneous databases, SQL Server security integrated with Windows Authentication, client/server configurations of 50 to 50,000 or more users, web configurations that use Internet Information Services (IIS) or COM+, databases as large as 2 TB, and multiple installations of SQL Server 2000

Course Aim

This learning path describes in detail the basic configuration and administration of Microsoft SQL Server 2000.

Learning Objectives

To explain how to plan and implement security on a SQL 2000 database

Topics Covered

Accessing SQL Server 2000 SQL Server 2000 security architecture Creating a SQL Server 2000 login account Permissions and roles Accessing SQL Server 2000 databases Assigning a login to a role Implementing SQL Server permissions Assigning user permissions in SQL Server 2000 Planning SQL Server 2000 security Security tools SQL Server 2000 security auditing Creating a security audit trace Implementing a SQL Server 2000 audit using Profiler

About Eno.com | Help | Terms of Use | Site Search | Contact Us | Site Map
Copyright © 1996-2002 E&A Inc. All rights reserved.