SQL Server 2000 Database Design MCSE 70-229 Series: Optimization and Security
Product Code: sql207 Time: 2.0 hour(s) CEUs: Available

Summary:

This course shows users the tools and techniques that can be used to monitor and optimize the performance of a SQL Server 2000 database, and how to design and implement a database security plan.

Objectives:

After completing this course, students will be able to:
  • Configure Windows 2000 Server and SQL Server 2000
  • Use SQL Profiler, Query Analyzer, and other tools to monitor database activity
  • Design a database security plan


Topics:

  • Monitoring performance
  • Configuring Windows 2000 Server
  • Configuring SQL Server 2000
  • Using SQL Profiler
  • Analyzing performance
  • Login authentication
  • Permissions
  • Database user accounts
  • Roles
  • Authentication modes
  • The database security plan

Technical Requirements:

200MHz Pentium with 32MB Ram. 800 x 600 minimum screen resolution. Windows 98, NT, 2000, or XP. 56K minimum connection speed, broadband (256 kbps or greater) connection recommended. Internet Explorer 5.0 or higher required. Flash Player 7.0 or higher required. JavaScript must be enabled. Netscape, Firefox and AOL browsers not supported.

Copyright © 2006 Learn It Online. All rights reserved.