|
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
|
