SUMMARY:   This course is designed for those intending to develop databases and database applications using Microsoft SQL Server 7.0 and the T-SQL programming language. PREREQUISITES:   No previous experience will be assumed although some programming experience will be of advantage. A thorough knowledge of the Windows interface and operation will be assumed. DURATION:   5 Days COURSE CONTENT:   Architectural Overview SQL Server components SQL Server SQL Server Agent Distributed Transaction Coordinator Microsoft Search Developer tools SQL Server Enterprise Manager Query Analyser SQL Profiler Retrieving Data Querying tables Retrieving data from a single table Transact-SQL conditions and expressions Dealing with collation sequences Using scalar and aggregate functions Multiple table queries Creating linked servers Querying across databases and instances Performing dynamic distributed queries Executing full-text searches Creating a full-text index Using full-text functions in SQL Taking advantage of proximity and weighting Managing Data and Concurrency Modifying records Working with INSERT, UPDATE and DELETE Configuring transaction isolation levels Controlling locks with hints Working with distributed data Querying remote servers Managing distributed transactions Making use of two-phase commit Developing Server-Side Code Programming in Transact-SQL Transact-SQL procedural extensions Creating and using local variables Referencing global variables Raising and managing errors Writing stored procedures Passing input and output parameters Examining return values Executing remote stored procedures Debugging a stored procedure Advanced Transact-SQL constructs Building and using temporary tables Processing rows on the server with a cursor LOCAL vs. GLOBAL cursors Creating user-defined functions Calculating values with scalar functions Solving complex problems with multiple- statement table-valued functions Calling functions from SQL Deterministic vs. non-deterministic Binding a function to the schema Formulating triggers INSTEAD OF vs. AFTER triggers Detecting row changes using the inserted and deleted tables Coding advanced validation Nested and recursive triggers Performance Tuning Monitoring queries Profiling client applications Viewing query plans Optimising queries Determining appropriate indexes Managing distribution statistics Using optimiser hints Integrating XML With Transact-SQL Retrieving XML using HTTP Submitting SQL as part of a URL Exploiting Transact-SQL extensions Using the FOR XML clause to select data JWAssociates