1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

SQL Server 2005 Programming: Hands-On Skills Upgrade

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

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 2000 or earlier versions 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 SQL Server 2005 applications with the latest .NET, XML and Transact-SQL features. You also learn to create message-based applications with Service Broker. Exercises offer practice in solving business problems with Transact-SQL and .NET programming languages.

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 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

Related Courses

 
SQL Server 2008 is a registered trademark of Microsoft Corporation. 		 

Upcoming Dates

Jan 21 - 23, 2009
 New York
Mar 4 - 6, 2009
 Washington, DC (Alexandria, VA)
Apr 1 - 3, 2009
 New York

For complete schedule, please visit www.learningtree.com
 
http://www.lerningtree.com/courses/130pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

SQL Server 2005 Programming: Hands-On Skills Upgrade

 
Course: 130   Type: Hands-On Training   Duration: 3 Days
 
 
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
 
http://www.lerningtree.com/courses/130pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

SQL Server 2005 Programming: Hands-On Skills Upgrade Tuition

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

Course Tuition
$ 2,390 Standard Tuition
Tuition with a Savings Plan
$ 1,350 10-Day Pass
$ 1,670 Training Passport
$ 1,700 Premium-Pass
$ 2,200 Voucher 10-Pack
$ 2,155 Alumni Gold Discount
$ 2,124 Government Discount
 

 

Your Course Tuition Entitles You To...

  • Class participation
  • Team workshops
  • Use of in-class hands-on equipment
  • Comprehensive course materials
  • Morning and afternoon refreshments
  • Course Completion Certificate awarding Continuing Education Units
  • FREE participation in Professional Certification
  • FREE participation in College Credit programs (including related exams)
  
 

Tuition Savings Plans

Training Passport
  • 3 courses in 12 months
  • As little as $1,670 per course
  • Savings as much as 40%
  • Only $5,000
Premium Pass
  • 4 courses in 24 months
  • As little as $1,700 per course
  • Save as much as 45%
10-Day Pass
  • A NEW way to save on training
  • 10 days of training for one person
  • Save as much as $990 per course
  • Only $4,500
Training Vouchers
  • Save as much as $990 per course
  • Fully transferable
  • As low as $2,200 per course
Alumni Gold Discount Attend your first course and you'll receive a personalized Alumni Gold Discount card, entitling you to save as much as $305 on each course you take within the following 12 months. Take just one course each year and you'll be entitled to ongoing discounts...year after year!

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 tuition.

Enrolling is Easy and Flexible!

Enroll 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.lerningtree.com/courses/130pf.htm