Customer Service or Enrol: 0800 282 353 or +44 1372 364610
 

SQL Server 2005 Server-Side Programming: Hands-On

Course: 133   Type: Hands-On   Duration: 5 Days
Quick Enrol  

You Will Learn How To

  • Develop database applications for SQL Server 2005 with Transact-SQL and .NET
  • Create and alter database table definitions using DDL
  • Create stored procedures in Transact-SQL
  • Handle Transact-SQL runtime errors
  • Access data with user-defined functions and views
  • Develop functions and procedures in .NET CLR

Course Benefits
SQL Server 2005 offers development features that fully support the requirements of small- and large-scale organisations. Developers using Transact-SQL, .NET and XML can build flexible, scalable and robust applications that meet today's business demands. This course provides experience creating procedural code in T-SQL and .NET. You also gain the skills needed to develop XML-based applications.

Who Should Attend
Those working with or moving to SQL Server 2005. Course 131, "SQL Server 2005 Comprehensive Introduction", or equivalent experience is assumed. Those with a developer background in SQL Server 7 or 2000 should take Course 130, "SQL Server 2005 Programming: Skills Upgrade".

Hands-on Training
During this course, you perform extensive hands-on exercises that provide in-depth experience. Exercises include:
  • Adding a column to a database table using ALTER TABLE
  • Passing data into a stored procedure using parameters
  • Intercepting errors with TRY...CATCH
  • Writing a trigger that generates an audit trail
  • Extracting data from an XML column using XQuery
  • Developing stored procedures in .NET

Course Content
SQL Server 2005 Architecture
  • SQL Server 2005 edition overview
  • Introducing the new tools
  • SQL Server Management Studio
Managing Tables with DDL
Creating tables
  • Selecting appropriate SQL Server data types
  • Constructing tables with CREATE TABLE
Adding constraints
  • Enforcing uniqueness using PRIMARY KEY and UNIQUE constraints
  • Validating relationships using FOREIGN KEY
Retrieving Data with Transact-SQL Stored Procedures
Selecting data
  • Developing stored procedures that extract data from multiple servers
  • Executing remote procedures
  • Developing recursive queries with common table expressions (CTE)
  • Producing cross tabulations using PIVOT
Declaring variables and parameters
  • Creating and utilising local variables
  • Passing input and output parameters
  • Interrogating global variables
Calling built-in scalar functions
  • Converting data using CAST and CONVERT
  • Ordering data with ranking functions
Maintaining Data
Modifying data
  • Inserting, updating and deleting data
  • Ensuring data consistency with transactions
  • Managing concurrency with isolation levels
  • SQL Server locking fundamentals
  • Avoiding blocking problems
Programming procedural statements
  • Implementing conditions with IF...ELSE
  • Looping with WHILE and GOTO
  • Creating code blocks with BEGIN...END
  • Debugging with PRINT
Handling errors
  • Communicating problems to the client with RAISERROR
  • Intercepting errors with TRY...CATCH
Producing server-side result sets
  • Building and using temporary tables
  • Processing rows on the server with a cursor
  • Taking advantage of table variables
Developing Views, Functions and Triggers with Transact-SQL
Storing queries on the server
  • Concealing complexity with views
  • Solving business problems using multistatement table-valued functions
Defining computations
  • Calculating values with scalar functions
  • Calling functions from SQL
Formulating triggers
  • INSTEAD OF vs. AFTER triggers
  • Detecting row changes using the inserted and deleted table
  • Tracing metadata changes with DDL triggers
Querying and Storing XML
Exchanging XML data
  • Extending queries with FOR XML
  • Using PATH and TYPE to create nested XML
Leveraging XQuery capabilities
  • Filtering rows based on XML elements
  • Extracting data from an XML column
Integrating .NET CLR with SQL Server
  • Developing procedural code in .NET
  • Contrasting Transact-SQL with the rich .NET programming model
  • Building Common Language Runtime procedures, functions and triggers
Performance Tuning
  • Viewing query plans
  • Determining appropriate indexes
  • Utilising optimiser hints
SQL Server is a trademark of Sybase, Inc.
  

request more info Salutation*:

First Name*:

Last Name*:

Job Title:

Company*:

Post Code*:

Country*:
   Codes
Office Telephone*:

Extension:

E-mail*:

* Required

A Learning Tree representative will contact you to follow up your request for information.

Save 55%
SQL Server 2005 Server-Side Programming
Course Schedule
30 Jun - 4 Jul, 2008
London
1 - 5 Sep, 2008
London
3 - 7 Nov, 2008
London
5 - 9 Jan, 2009
London
9 - 13 Mar, 2009
London

Participants writing a stored procedure in SQL Server 2005.

£ 1,995 - Standard Tuition
Savings Plans
£ 1,350 - 10-Day Training Pass
£ 995 - Flex-Training Passport
£ 1,215 - 10-Training Vouchers
£ 1,300 - 5-Training Vouchers
£ 1,795 - Alumni Gold Tuition

 
Certification Core Course
 
Vendor Cert - Microsoft
 
SQL Server 2005 for the Enterprise
 
Customer Service or Enrol: 0800 282 353 or +44 1372 364610