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

SQL Server 2005 Programming: Hands-On Skills Upgrade

Course: 130   Type: Hands-On   Duration: 3 Days
Quick Enrol  

You Will Learn How To

  • Develop database applications for SQL Server 2005
  • Exploit Transact-SQL features such as common table expressions and snapshot isolation
  • Retrieve and manipulate XML data
  • Build message-based applications using Service Broker
  • Develop stored procedures with .NET CLR
  • Create a .NET user-defined data type

Course Benefits
Programmers and developers experienced with SQL Server 7 or SQL Server 2000 need to enhance their skills in order to take full advantage of the features of SQL Server 2005.

In this course, you gain experience developing applications with the latest .NET, XML and Transact-SQL features.



Who Should Attend
This skills upgrade course is valuable for developers and programmers currently working with or planning to move to SQL Server 2005. Knowledge of SQL Server development at the level of Course 532, "SQL Server Transact-SQL Programming", is assumed.

Hands-on Training
During this course, you perform extensive hands-on exercises that provide in-depth, hands-on experience. Exercises include:
  • Upgrading a procedure to use TRY...CATCH error handling
  • Solving blocking problems using row versioning
  • Extracting data from an XML column using XQuery
  • Initiating a dialog using Service Broker
  • Developing stored procedures in .NET

Course Content
SQL Server 2005 Architecture
  • SQL Server 2005 edition overview
  • Introducing the new tools
  • SQL Server Management Studio
Developing with Transact-SQL
Managing data
  • Storing data in varchar (max) and XML columns
  • Ordering data with ranking functions
  • Developing recursive queries with common table expressions (CTE)
  • Producing cross tabulations using PIVOT
  • Encrypting and decrypting data
Working with metadata
  • Managing tables and procedures using schemas
  • Hiding the location of base objects using synonyms
  • Auditing table changes with DDL triggers
Handling errors and locking
  • Intercepting errors with TRY...CATCH
  • Implementing snapshot isolation
Querying and Storing XML
Storing XML data
  • Creating XML SCHEMA COLLECTIONS
  • Defining typed XML variables
  • Adding XML columns to tables
Exchanging XML data
  • Extending queries with FOR XML
  • Converting data with OPENXML
Capitalizing on XQuery capabilities
  • Filtering rows based on XML elements
  • Extracting data from an XML column
  • Exploiting XML data type methods
Creating Applications with Service Broker
Designing Asynchronous messaging systems
  • Achieving scalability with queuing
  • Ensuring reliable message delivery
Sending and receiving messages
  • Defining contracts to control conversations
  • Associating message types with XML schema collections
  • Handling message order and unique delivery with conversation group locks
  • Starting conversations with BEGIN DIALOG
Integrating .NET with SQL Server
Integrating CLR
  • Exploiting the rich .NET programming model
  • Streamlining development through a standardized environment
  • Improving safety and security using .NET
  • Applying best practices
Developing procedural code in .NET
  • Writing stored procedures in a .NET language
  • Converting a .NET expression into a function
  • Invoking a CLR function from a Transact-SQL SELECT statement
  • Loading and unloading assemblies
Extending SQL Server with .NET
  • Developing aggregates for enhanced functionality
  • Augmenting SQL Server with .NET user-defined data types
  • Adding customer methods to extend user-defined data types
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 Programming: Skills Upgrade
Course Schedule
6 - 8 Aug, 2008
London
26 - 28 Nov, 2008
London

Participants developing a stored procedure.

£ 1,395 - Standard Tuition
Savings Plans
£ 810 - 10-Day Training Pass
£ 995 - Flex-Training Passport
£ 800 - Short Course Vouchers
£ 1,255 - Alumni Gold Tuition

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