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, 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 discuss Transact-SQL and its elements and view and define data using Transact-SQL statements

Topics Covered

Overview of using T-SQL in SQL Server 2000 Introducing SQL Server 2000 T-SQL SQL Server 2000 programming tools SQL Server 2000 T-SQL elements SQL Server 2000 T-SQL functions and expressions Selecting data in SQL Server 2000 Using the SELECT statement in SQL Server 2000 Filtering data in SQL Server 2000 Formatting data in SQL Server 2000 Querying data in SQL Server 2000 SQL Server 2000 data modification Introducing SQL Server 2000 data modification Inserting, updating, and deleting SQL Server 2000 data Modifying SQL Server 2000 data Using T-SQL statements in SQL Server 2000 Controlling flow in SQL Server 2000 Executing T-SQL statements in SQL Server 2000 Creating a SQL Server 2000 script

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