SUMMARY:   The Microsoft SQL Server Advanced Programming Techniques class will teach students methods to utilize in order to write highly efficient and effective stored procedures, batches, transactions, cursors, and ad hoc queries. Participants will be shown how to properly code functions, joins, subqueries, Case statements, and grouping facilities. Additionally, students will learn the structure of locking, search arguments, optimizations, and stored procedure compilations. AUDIENCE:   This course is recommended for Microsoft SQL Server Application Programmers who require an in depth knowledge of advanced programming techniques. PREREQUISITES:   Students should have an understanding of the facilities of the Microsoft SQL Server Relational Database Management System. Students should also have attended the Introduction to Microsoft SQL Server and Transact_SQL facilities class. DURATION:   This class is presented in four days. OBJECTIVES:   Upon successful completion of this course, participants will be able to code advanced techniques of the Microsoft SQL Server with relative ease and understanding. Students will understand the most advantage method of coding to be performed in various situations. COURSE CONTENT:   Using Functions for Presentation Padding Signs Sorting Decoding Date processing Strings Arithmetic facilities Locking Concepts Schemes Isolation levels Deadlocks Table locking CASE processing Select Updates Frequency tables Table pivoting Table folding CURSORS Read cursors Update cursors Coding techniques Joins Inner joins Outer joins Self joins Table lookups Merge joins Hash Joins Subqueries Non-correlated Correlated Exception reporting Coding Unions Group by Cumulative totals Numbering rows Missing data Ranking Stored procedures Creating Executing Testing Transaction modes Error processing Effective coding Search arguments Indexes Optimizations Plans Variables Parameters MT/07