![]() |
Profile |
Contact |
Search |
Cart |
| Microsoft SQL Server 2000 Database Administration II: Managing SQL Server 2000 Databases |
| Course Status: | Released | Courseware Features |
| Course Language: | English | |
| Course Duration: | 5 Hours | |
| Deployment Options: | Online, Interactive CDs, Network, Downloads, Intranet |
Audience |
| Database administrators, application developers, system administrators, and students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition |
Prerequisites |
| Experience working in a medium to enterprise computing environment that uses SQL Server 2000 Enterprise Edition; at least one year?s experience administering SQL Server; at least one year?s experience implementing relational databases in environments that contain heterogeneous databases, SQL Server security integrated with Windows Authentication, client/server configurations of 50 to 50,000 or more users, web configurations that use Internet Information Services (IIS) or COM+, databases as large as 2 TB, and multiple installations of SQL Server 2000 |
Course Aim |
| This learning path describes in detail the basic configuration and administration of Microsoft SQL Server 2000. |
Learning Objectives |
| To guide students in configuring, performing, and automating routine administrative tasks |
Topics Covered |
| SQL Server 2000 automation Introducing SQL Server 2000 automation Configuring automation in SQL Server 2000 Configuring SQL Mail in SQL Server 2000 Automating routine SQL Server 2000 maintenance tasks Creating and implementing jobs and operators Creating a job with multiple steps in SQL Server 2000 The SQL Server 2000 database maintenance plan Creating a maintenance plan for SQL Server Troubleshooting SQL Server 2000 automation Creating and implementing alerts in SQL Server 2000 Introducing alerts in SQL Server 2000 Creating alerts with Enterprise Manager Creating SQL Server 2000 alerts |