Course Status:	Released	Courseware Features
Course Language:	English
Course Duration:	3 Hours
Deployment Options:	Online, Interactive CDs, Network, Downloads, Intranet

Audience

Database administrators, application developers, and system administrators; 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 new features, tools, and best practices for designing and implementing databases using Microsoft SQL Server 2000.

Learning Objectives

To show how to analyze and optimize queries

Topics Covered

Analyzing SQL Server 2000 queries Analyzing SQL Server 2000 queries using AND and OR Analyzing SQL Server 2000 queries using JOIN operators Recommended tuning practices in SQL Server 2000 Optimizing SQL Server 2000 query performance SQL Server 2000 Database Administration - Query Optimizer Analyzing a SQL Server 2000 query execution plan SQL Server 2000 indexing strategies Monitoring and troubleshooting SQL Server 2000 Monitoring SQL Server 2000 database performance

About Eno.com | Help | Terms of Use | Site Search | Contact Us | Site Map
Copyright © 1996-2002 E&A Inc. All rights reserved.