. Planning,
installing, upgrading, troubleshooting, and verifying
SQL Server 2000 installation
. Understanding SQL server 2000 database architecture
. Creating and configuring SQL Server 2000 databases
. Optimising and monitoring databases performance in SQL
2000
. Backup and recovery in SQL server 2000
. Extracting and transforming data in SQL server 2000
. Configuring and using SQL Mail and SQL AgentMail
. Configuring and using SQL Agentmail
. Configuring and managing Linked servers
. Working with replication services
. Creating and managing security roles |
. Enforcing security using
objects and setting permissions
. Maintaining database consistency using objects and setting
permissions
. Maintaining database consistency using database Maintenance
Plan Wizard
. Monitoring events using SQL profiler
. Creating SQL Server 2000 Agent Jobs
. Configuring Alerts and Operators using SQL server 2000
agent
. Monitoring and optimising hardware resource usage
. Resolving System bottlenecks
. Monitoring and optimising SQL Server 2000 system activity
. Troubleshooting SQL Server 2000 system activity |