SQL Server 7.0 Database Administration Part I

This course builds upon previous courses by covering database management, and provides a foundation for advanced courses on data warehousing, client/server application development, and SQL to IIS active server pages. Related Exams: Prepares users for both Microsoft Exams #70-028 Administering Microsoft SQL Server 7.0 and #70-029 - Designing and Implementing Databases with Microsoft SQL Server 7.0.

Database Administration Part I training covers such topics as:

The SQL Server Agent
Using the SQL Server Agent
SQL Server Security

Database administrators, Database analysts, and Database developers who are working toward the Microsoft Certified Database Administrator (MCDBA) credential. The series is designed to help the student pass the Microsoft Exam 70-028: Administering Microsoft SQL Server 7.0 and Exam 70-029: Designing and Implementing Databases with Microsoft SQL Server 7.0. This series is also appropriate for individuals who derive physical database designs, develop logical data models, create physical databases, create data services by using Transact-SQL, manage and maintain databases, configure and manage security, monitor and optimize databases, and install and configure Microsoft SQL Server.

Description
This course builds upon previous courses by covering database management, and provides a foundation for advanced courses on data warehousing, client/server application development, and SQL to IIS active server pages. Related Exams: Prepares users for both Microsoft Exams #070-028 Administering Microsoft SQL Server 7.0 and #070-029 Designing and Implementing Databases with Microsoft SQL Server 7.0.
Audience
Database administrators, Database analysts, and Database developers who are working toward the Microsoft Certified Database Administrator (MCDBA) credential. The series is designed to help the student pass the Microsoft Exam 70-028: Administering Microsoft SQL Server 7.0 and Exam 70-029: Designing and Implementing Databases with Microsoft SQL Server 7.0. This series is also appropriate for individuals who derive physical database designs, develop logical data models, create physical databases, create data services by using Transact-SQL, manage and maintain databases, configure and manage security, monitor and optimize databases, and install and configure Microsoft SQL Server.
Prerequisites
Students understand computer system fundamentals, and have user knowledge of Windows 95, Microsoft Office, Internet browsing, and HTML, and e-mail systems. Students are expected to have successfully completed SQL Server 7.0: Introduction, SQL Server 7.0: Installing and Upgrading, SQL Server 7.0: Management Parts I, II, and III courses
Course Duration
» 5 hours
Topics Include
Unit 1: The SQL Server Agent
» SQL Server Agent Features
» Configuring the SQL Server Agent
Everything Courseware
SQL Server 7.0 Database Administration. Part I
Unit 2: Using the SQL Server Agent
» Managing Alerts
» Managing SQL Server Agent Jobs
» Multi Server Administration
» Troubleshooting
Unit 3: SQL Server Security
» Security Principles
» SQL Server 7.0 Security Hierarchy
» SQL Server 7.0 Security Model

System Requirements CD-Based » Pentium class computer » 200 MHz processor (266 MHz recommended) » 32 MB RAM (64 MB recommended) » CD-ROM drive » Any one of Windows 95, Windows 98, Windows Me, Windows NT 4.0, Windows 2000 or Windows XP (both Windows NT 4.0 and Windows 2000 require at least 64 MB RAM) » SVGA monitor capable of 16-bit color and 800 x 600 screen resolution » Sound card with speakers or headphones (optional)