SQL Server 2000 Advanced TSQL Tricks and Techniques for Microsoft SQL Server 2000 Courses and other IT courses from TEKsystems Education Services

Note: All fields are required

First Name:

Last Name:

Company:

Title:

Email Address:

Phone Number:

Address:

City:

State:

Zip Code:

Which Topic(s) Currently Interests Your Organization:

Tell Us More:

I have an immediate training or educational service need and I wish to be contacted today

I am a current TEKsystems Education Services client and wish to speak to someone

I have a training budget approved and I am ready to talk to someone about the details of my organization’s training need

I do not have an approved training budget, but I have a need and would like to talk to TEKsystems Education Services about their solutions

Unfortunately, I do not have a group training request

At the present time we do not offer training for individuals or groups less then 6 individuals. We apologize for any inconvenience.

My Delivery Method Needed Is:

Instructor-Led Classroom Training

Instructor-Led Virtual Training

Self-Paced Online Training

Code Number:

We Value Your Privacy!

Course Code:	RT 236
Course Abstract:	This course is designed to teach the advanced tricks and techniques of SQL Server 2000. Participants will learn the following topics; good code and debugging techniques, report formatting techniques, joins and subqueries, key assignments and SQL Profiler with Traces. This course is comprised of 50% lecture and 50% labs.
Audience:	This course is designed for experienced SQL Developers, Programmers or System Administrators.
Duration:	4 days
Learning Outcomes:	Upon completion of this course, the participant will be able to: > Write conditional logic and case statements > Use the SQL Debugger > Work with User Defined Functions > Understand the Enterprise Manager
Course Topics:	Good Code and Debugging Query Analyzer DateTime Columns and Functions Report Formatting Techniques Conditional Logic and Case Statements Table Pivoting, Spreadsheet Presentation Joins and Subqueries Loop Processing Summary and Statistical Techniques Transaction Batches with Temporary Tables Key Assignment Better Stored Procedures SQL Debugger External Procedures User Defined Functions Indexed Views SQL Profiler with Traces Enterprise Manager
Prerequisites:	Prior experience with SQL Server 2000 and experience with SQL development

SQL Server 2000 Advanced TSQL Tricks and Techniques for Microsoft SQL Server 2000 Course