This course provides students with the knowledge and skills required to install, configure, administer, and troubleshoot the client-server database management system of Microsoft SQL Server 2000.
At the end of the course, students will be able to:
- Describe SQL Server architecture.
- Plan for a SQL Server installation, and then install an instance of SQL Server.
- Manage files and databases, including determining resource requirements.
- Choose a login security method, configure login security, plan and implement database permissions, and describe how to help protect SQL Server in an enterprise network.
- Perform and automate administrative tasks and create custom administrative tools.
- Back up databases and implement a backup strategy.
- Restore databases.
- Monitor and optimize SQL Server performance.
- Transfer and migrate data into databases.
- Maintain the high availability of SQL Server.
- Describe how to replicate data from one SQL Server to another.