Click Here for the Outline in PDF Version Course Outline: Microsoft SQL Server 2000: System Administration (5 Days) with Hands-On Labs Learning Objectives Understand the capabilities of Microsoft SQL Server 7.0 Install Microsoft SQL Server Design, create, and manage databases Create and manage tables Design and configure security on SQL Server Transfer data between SQL servers Optimize the performance of SQL Server Back up a SQL server’s databases Restore database backups Automate administrative tasks Design and implement replication between SQL servers Manage replication Create a Web page This course description should be used to determine whether the course is appropriate for you based on your current skill and technical training needs. Technical information is provided on the intended audience, course prerequisites, and covered topics. Course content, prices, and availability are subject to change without notice. Course Audience Attendees for this course should be able to complete the tasks necessary to implement and administer a Windows NT Server 4.0 domain. Course Description This five day information-packed seminar with hands-on labs provides attendees with the opportunity to learn how to install, configure, administer, and troubleshoot Microsoft SQL Server 7.0 in a Windows NT 4.0 environment. Course Objectives At course completion the student will be able to perform the following tasks: Understand the capabilities of Microsoft SQL Server 7.0 Install Microsoft SQL Server Design, create, and manage databases Create and manage tables Design and configure security on SQL Server Transfer data between SQL servers Optimize the performance of SQL Server Back up a SQL server’s databases Restore database backups Automate administrative tasks Design and implement replication between SQL servers Manage replication Create a Web page Prerequisites Attendees should have experience with Windows NT 4.0: System Architecture and Network Support or equivalent knowledge. TOPICS COVERED IN LECTURE & LAB Introduction to Microsoft SQL Server Exploring the components of SQL Server Identifying SQL Server administration tasks Installing SQL Server Identifying the requirements for installing SQL Server Installing SQL Server Exploring the SQL Server installation Troubleshooting the SQL Server installation Designing and implementing databases Developing a strategy for implementing databases Creating databases Managing databases Creating and managing tables Creating tables Working with tables Using Microsoft Access to connect to a SQL server Designing and configuring SQL Server security Identifying the security features of SQL Server Creating login IDs Assigning login IDs as database users Implementing statement and object permissions Designing a security strategy Importing and exporting data Introduction to data transfer Bulk data transfers Monitoring SQL Server Designing a strategy for monitoring SQL Server Using monitoring tools Backing up SQL Server databases Planning backups Performing a backup Designing your backup strategy Restoring SQL Server databases Identifying methods to restore databases Restoring databases and transaction logs Recovering system databases Automating SQL Server administration Configuring SQL Server to send mail Defining SQL operators Managing jobs Managing alerts Designing and implementing replication Introduction to replication Configuring replication Managing replication Monitoring and maintaining replication Troubleshooting replication Publishing SQL Server data on a Web page Creating a Web page

Policy