SQL Server 2000 Database Design MCSE 70-229: Optimization and Security
Product Code: SQL207 Time: 2 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

Outline:

  • 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

Features:

  • Activities that allow users to apply course concepts in an interactive questioning environment
  • Simulations that allow users to practice course skills, even if they don't have access to the application
  • A glossary
  • A Skill Assessment

Applicability:

This course is for anyone preparing for Microsoft Exam 70-229: "Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition."

Prerequisites:

SQL Server 2000 Database Design MCSE 70-229: Data Modeling and Database CreationSQL Server 2000 Database Design MCSE 70-229: Database ObjectsSQL Server 2000 Database Design MCSE 70-229: Retrieving and Modifying DataSQL Server 2000 Database Design MCSE 70-229: Indexes and ViewsSQL Server 2000 Database Design MCSE 70-229: Database ProgrammingSQL Server 2000 Database Design MCSE 70-229: Remote Data Access and XML

Technical Requirements:

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 98 or higher. Minimum Connection Speed: 28.8k. Internet Explorer 5.0 or higher (5.5 or higher for MindLeaders Central) required. Macromedia Flash player 6.0 is recommended for full functionality, but not required to play the courses. Sound card, with speakers or headphones is recommended, but not required to play the courses. JavaScript must be enabled. Netscape and AOL browsers not supported.

Google

Copyright Information:


Terms of Use:

None

Copyright © 2004 MindLeaders. All rights reserved.