0800 282 353 or +44 1372 364610
TRAINING YOU CAN TRUST
 
 

SQL Server 2000 Transact-SQL Programming: Hands-On

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

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 organisations. This course provides extensive experience creating stored procedures and triggers, and developing SQL queries that utilise 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

Related Courses

  • 534 SQL Queries for SQL Server
  • 535 High-Performance SQL Server Databases
  • 523 SQL Server 2005 Reporting Services
  • 542 XML Comprehensive Introduction
  • 531 SQL Server 2000 Database Administration
  • 539 Deploying Clusters on Windows Server 2003
  • 315 Developing User Requirements
  • 319 Technical Writing Comprehensive Introduction

 
SQL Server is a trademark of Sybase, Inc. Transact-SQL is a registered trademark of Sybase, Inc.
   SQL Server 2000 Transact-SQL Programming

Upcoming Dates

13 - 16 Jan, 2009
London
21 - 24 Apr, 2009
London
28 - 31 Jul, 2009
London

For complete schedule, please visit www.learningtree.co.uk
 
http://www.learningtree.co.uk/courses/uk532.htm
 
 
0800 282 353 or +44 1372 364610
TRAINING YOU CAN TRUST
 
 

SQL Server 2000 Transact-SQL Programming: Hands-On

 
Course: 532   Type: Hands-On Training   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

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

Optimising queries

  • Determining appropriate indexes
  • Managing distribution statistics
  • Utilising optimiser 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
 
http://www.learningtree.co.uk/courses/uk532.htm
 
 
0800 282 353 or +44 1372 364610
TRAINING YOU CAN TRUST
 
 

SQL Server 2000 Transact-SQL Programming: Hands-On Tuition

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

Course 532 Tuition

£ 1,995Standard Tuition
Tuition with a Savings Plan
£ 1,22510-Day Training Pass
£ 995Flex-Training Pass
£ 1,31410-Training Vouchers
£ 1,4045-Training Vouchers
£ 1,795Alumni Gold Tuition

Your Course Fee Entitles You To...

  • Class participation
  • Team workshops
  • Use of in-class hands-on equipment
  • Comprehensive course materials
  • Morning and afternoon refreshments
  • Lunch
  • Course Completion Certificate
  • FREE participation in the Learning Tree Professional Certification Programmes (including related exams)
  
 

Tuition Savings Plans

Flex-Training Pass
  • 3 Courses for £2 ,995
  • As little as £995
  • Savings as much as 50%
  • 3 courses in 24 months
10-Day Training Pass
  • Save as much as £770 per course
  • Any combination of courses
  • Only £2,695
Training Vouchers
  • Save as much as £681 per course
  • Fully transferable
  • As low as £1,314 per course
Alumni Gold Discount Attend your first course and you will receive a personalised Alumni Gold Discount card, entitling you to save as much as £200 on each course you take in the following 24 months. Take just one course every two years, and you will be entitled to ongoing discounts...year after year. You save 10%.
* Exact savings may vary depending on courses selected.

Your Guarantee of Satisfaction

Unless you feel 100% satisfied that Learning Tree delivered even more than you expected, there is no fee for your course attendance. Our Guarantee of Quality lets you experience the value of the course - and then pay only if you feel the course was well worth the fee.

Enrolling is Easy and Flexible!

Enrol by phone or online. If your plans change, just let us know and, without a fee, you can transfer to another course or cancel your enrollment. Pay after you've taken the course, and then only if you are 100% satisfied.
 
http://www.learningtree.co.uk/courses/uk532.htm