|
This training 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.
Objectives:
After completing this training 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
Outline:
- 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
Features:
- Activities that allow users to apply training course concepts in an interactive questioning environment
- A glossary
- A Skill Assessment
|
