Using T-SQL in SQL Server 2000

Overview/Description
To discuss Transact-SQL and its elements and view and define data using Transact-SQL statements

Target 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 years experience administering SQL Server; at least one years 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

Expected Duration
185 Minutes

Objectives:

Using T-SQL in SQL Server 2000

  • describe Transact-SQL and discuss its capabilities.
  • use the Transact-SQL programming tools.
  • use the different elements of Transact-SQL statements.
  • use local variables and SQL Server functions.
  • retrieve data using the SELECT statement.
  • filter data in a SELECT statement using the WHERE clause.
  • format the output or results of the SELECT statement.
  • query data using the SELECT statement and filter and format the results.
  • use the INSERT, UPDATE, and DELETE Transact-SQL statements.
  • add, remove, and modify data using Transact-SQL statements.
  • insert, update, and delete data using Transact-SQL in Query Analyzer.
  • describe the concept of control of flow language.
  • execute T-SQL statements dynamically.
  • construct a T-SQL statement.


    • Course Number: 31905_eng