1-800-THE-TREE (1-800-843-8733)
 

SQL Server 2000 Transact-SQL Programming: Hands-On

 
Course: 532     Type: Hands-On Training     Duration: 5 Days

Quick Enroll    

You Will Learn How To
  • Develop database applications for SQL Server 2000 with Transact-SQL
  • Create and debug stored procedures
  • Take advantage of AFTER and INSTEAD OF triggers
  • Manage concurrency using transactions and locking options
  • Exchange data effectively using Transact-SQL's support for XML
  • Tune database queries for optimal performance

Course Benefits
Transact-SQL is integral to the power of SQL Server. Transact-SQL features, including stored procedures, indexing and partitioning, allow developers to create scalable, distributed applications to meet the demanding requirements of modern organizations. This course provides extensive experience creating stored procedures and triggers, and developing SQL queries that utilize SQL Server to the fullest.

Who Should Attend
Database developers, administrators and analysts who want to expand their knowledge of SQL Server 2000. Course 530, "SQL Server 2000 Comprehensive Introduction," or equivalent experience is assumed.

Hands-On Training
A series of hands-on exercises provides immediate experience in Transact-SQL development, including:
  • Joining local and remote tables
  • Modifying data in a transaction
  • Developing stored procedures
  • Calling a user-defined function in a SQL statement
  • Writing triggers to carry out advanced validation
  • Finding poorly performing queries with SQL Profiler
  • Creating an XML stream from Transact-SQL

Course 532 Content
Architectural Overview
SQL Server components
  • SQL Server
  • SQL Server Agent
  • Distributed Transaction Coordinator
  • Microsoft Search
Developer tools
  • SQL Server Enterprise Manager
  • Query Analyzer
  • SQL Profiler
Managing Tables with DDL
Creating tables
  • Selecting appropriate SQL Server
  • Constructing tables with CREATE TABLE
Adding constraints
  • Enforcing uniqueness using PRIMARY KEY and UNIQUE constraints
  • Validating relationships using FOREIGN KEY
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
  • Taking advantage of table variables
Creating user-defined functions
  • Calculating values with scalar functions
  • Solving complex problems with multiple-statement table-valued functions
  • Calling functions from SQL
  • 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
  • Generating an audit trail
  • Exploring nested and recursive triggers
  • Creating data correction triggers
Performance Tuning
Monitoring queries
  • Profiling client applications
  • Viewing query plans
Optimizing queries
  • Determining appropriate indexes
  • Managing distribution statistics
  • Utilizing optimizer hints
  • Improving performance with partitioned views
Integrating XML with Transact-SQL
  • Using the FOR XML clause to select data
  • Modifying data using the OpenXML function
  • Contrasting RAW, AUTO and EXPLICIT modes

Related Courses

SQL Server is a trademark of Sybase, Inc. Transact-SQL is a registered trademark of Sybase, Inc.
  
 
Request More Info

Salutation

First Name

Last Name

Company

Zip Code

Country
   Codes
Work Phone

Extension

E-mail

A representative will contact you to follow up your request.
Privacy Statement

Save as much as $2,350 on a Triple-Pack!

SQL Server 2000 Transact-SQL Programming: Hands-On
Upcoming Dates
Jun 9 - 13, 2008
 Washington, DC (Reston, VA)
Aug 4 - 8, 2008
 Washington, DC (Rockville, MD)
Aug 18 - 22, 2008
 Toronto
Oct 27 - 31, 2008
 New York
Dec 8 - 12, 2008
 Washington, DC (Reston, VA)

SQL Server 2000 Transact-SQL Programming: Hands-On
Bring Learning Tree On-Site

Course Tuition
$ 2,950 Standard Tuition
Tuition with a Savings Plan
$ 2,075 10-Day Pass
$ 1,665 Training Passport
$ 1,830 Flex-Pass
$ 2,095 Voucher 10-Pack
$ 2,655 Alumni Gold Discount
$ 2,620 Government Discount
 

 

SQL Server 2000 Transact-SQL Programming: Hands-On
SQL Server 2000 Transact-SQL Programming: Hands-On
Participants debugging a stored procedure in Transact-SQL.


Certification Core Course CPE 29 Credits Vendor Cert - Microsoft 2 Hour(s) College Credit
Customer Service or Enroll: 1-800-843-8733