Click Here for the Outline in PDF Version Course Outline: Microsoft SQL Server 7.0 System Administration (5 Days) with Hands-On Labs Learning Objectives Understand the full capabilities of Microsoft SQL Server 7.0 Install Microsoft SQL Server on a Windows NT machine Learn to design, create, and manage databases Learn to create and manage tables Design and configure security on SQL Server Transfer data between SQL servers Learn how to optimize the performance of SQL Server Learn to back up a SQL server’s databases Learn to perform Restore procedure database backups Learn to automate administrative tasks Design and implement replication between SQL servers 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 Students enrolling in this course should be able to complete the tasks necessary to implement and administer a Windows NT Server 4.0 domain. Course Description Students will learn how to install, configure, administer, and troubleshoot Microsoft SQL Server 7.0 in a Windows NT 4.0 environment. This course will assist students in preparing for Microsoft Certified Systems Engineer Exam #70-028, System Administration for Microsoft SQL Server 7.0. 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 Ziff-Davis Education’s course Windows NT 4.0: System Architecture and Network Support or have 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