Education Online - Career Education --- e-learning for Everyone.

 

Synopsis
SQL Server 2000 Database Design MCSE 70-229: Retrieving and Modifying Data shows users how to retrieve, filter, and modify data using Transact-SQL, and explains techniques for importing and exporting data in SQL Server 2000.

Audience
This course is for anyone preparing for Microsoft Exam 70-229: "Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition."

Time
2 hours

Product Code: SQL203
SQL Server 2000 Database Design MCSE 70-229: Retrieving and Modifying Data covers the following topics:

Referring to a SQL Server object
Transact-SQL
System functions
Collation precedence
Using the SELECT statement
Clauses for the SELECT statement
Subqueries
Using the DELETE statement
Using the UPDATE statement
Using the INSERT statement
Bulk copy operations
Data Transformation Services

This course has the following features:

Activities that allow users to apply course concepts in an interactive questioning environment
A glossary
A Skill Assessment

SQL Server 2000 Database Design MCSE 70-229: Data Modeling and Database Creation (SQL201)
SQL Server 2000 Database Design MCSE 70-229: Database Objects (SQL202)

Microsoft® is a registered trademark of Microsoft Corporation.
SQL Server 2000 is a trademark of Microsoft Corporation.
Home | Training | Products | Specials | Tips | Resources
Copyright © 2001 - 2003 StaffKit, Inc.
All Rights Reserved.