Total Time: 2 hour(s)

Summary: 
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.

Ojectives: 
After completing this course, students will be able to:
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

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

Technical Requirements: 
P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.