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

SQL Server 2005 Programming: Hands-On Skills Upgrade

 
Course: 130     Type: Hands-On Training     Duration: 3 Days

Quick Enroll    

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
SQL Server 2005 is a significant enhancement over previous SQL Server versions. Programmers and developers experienced with SQL Server 2000 or SQL Server 7 need to advance their skills in order to leverage SQL Server 2005's feature set. In this hands-on skills upgrade 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 2000 Transact-SQL Programming," is assumed.

Hands-On Training
During this course, you gain hands-on experience developing database applications with SQL Server 2005. 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 130 Content
SQL Server 2005 Architecture
  • SQL Server 2005 edition overview
  • 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
  • Combining data using INTERSECT and EXCEPT
  • Controlling access using EXECUTE AS
Working with metadata
  • Managing tables and procedures using schemas
  • Hiding the location of base objects using synonyms
  • Auditing table changes with DDL triggers
  • Tracking data changes using the OUTPUT clause
Handling errors and locking
  • Intercepting errors with TRY...CATCH
  • Avoiding blocking locks using row versioning
  • Contrasting snapshot isolation and read committed snapshot isolation
Encrypting data
  • Creating a MASTER KEY
  • Encrypting and decrypting with a pass phrase
  • Contrasting asymmetric and symmetric keys
  • Utilizing a certificate to encrypt data
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
  • Managing reliability using transactions
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
  • Improving code level security using the PERMISSION_SET clause
  • Controlling assembly deployment using the TRUSTWORTHY database option
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
Creating CLR routines with Visual Studio
  • Developing stored procedures and functions with templates
  • Deploying assemblies directly to SQL Server
  • Stepping through CLR code in the debugger

Related Courses
SQL Server is a 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 2005 Programming: Hands-On Skills Upgrade
Upcoming Dates
May 14 - 16, 2008
 New York
Jul 9 - 11, 2008
 Washington, DC (Rockville, MD)
Sep 3 - 5, 2008
 New York
Oct 22 - 24, 2008
 Washington, DC (Reston, VA)
Jan 7 - 9, 2009
 New York

SQL Server 2005 Programming: Hands-On Skills Upgrade
Bring Learning Tree On-Site

Course Tuition
$ 2,250 Standard Tuition
Tuition with a Savings Plan
$ 1,245 10-Day Pass
$ 1,665 Training Passport
$ 1,830 Flex-Pass
$ 2,095 Voucher 10-Pack
$ 2,025 Alumni Gold Discount
$ 2,000 Government Discount
 

 

SQL Server 2005 Programming: Hands-On Skills Upgrade
SQL Server 2005 Programming: Hands-On Skills Upgrade
Participants developing a stored procedure.

SQL Server 2005 for the Enterprise


Certification Core Course CPE 17 Credits 1 Hour(s) College Credit
Customer Service or Enroll: 1-800-843-8733