MP9004: Microsoft - Retrieving and Modifying Data > SQL Server 2000 Database Design MCSE 70-229

This course shows users how to retrieve, filter, and modify data using Transact-SQL, and explains techniques for importing and exporting data in SQL Server 2000. 

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

Objectives:
Use the Transact-SQL Data Manipulation Language statements SELECT, INSERT, UPDATE, and DELETE to retrieve and modify data
Use SQL Server built-in functions, including CASE, CONVERT, and CAST
Define a collation at the server, database, or column level
Use the Transact-SQL BULK INSERT statement, the BCP utility, or Data Transformation Services (DTS) to import and export data

Duration:
2 Hours