Using T-SQL in SQL Server 2000

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

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

Database administrators, application developers, and system administrators; students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition

WEB

Introducing SQL Server 2000 T-SQL| - describe Transact-SQL and discuss its capabilities.|SQL Server 2000 programming tools| - use the Transact-SQL programming tools.|SQL Server 2000 T-SQL elements| - use the different elements of Transact-SQL statements.|SQL Server 2000 T-SQL functions and expressions| - use local variables and SQL Server functions.|Using the SELECT statement in SQL Server 2000| - retrieve data using the SELECT statement.|Filtering data in SQL Server 2000| - filter data in a SELECT statement using the WHERE clause.|Formatting data in SQL Server 2000| - format the output or results of the SELECT statement.|Querying data in SQL Server 2000| - query data using the SELECT statement and filter and format the results.|Introducing SQL Server 2000 data modification| - use the INSERT, UPDATE, and DELETE Transact-SQL statements.|Inserting, updating, and deleting SQL Server 2000 data| - add, remove, and modify data using Transact-SQL statements.|Modifying SQL Server 2000 data| - insert, update, and delete data using Transact-SQL in Query Analyzer.|Controlling flow in SQL Server 2000| - describe the concept of control of flow language.|Executing T-SQL statements in SQL Server 2000| - execute T-SQL statements dynamically.|Creating a SQL Server 2000 script| - construct a T-SQL statement.|

123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace: E-Learning available for - ABAP 6. 10 - Access 2003 - Acrobat 6. 0 - ASP - ASP. NET - C - Captivate 1. 0 - Crystal Reports 8. 5 - Crystal Reports v10 -...