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

SQL Server Server-Side Programming: Hands-On

 
Course: 133   Type: Hands-On Training   Duration: 4 Days
 
 

You Will Learn How To

  • Develop server-side database programs for SQL Server databases
  • Retrieve XML data with XQuery
  • Build scalable message-based applications with Service Broker
  • Access data using LINQ
  • Create functions and stored procedures in .NET CLR
  • Persist objects in the database with ADO.NET Object Services

Course Benefits

SQL Server 2005 and 2008 offer development features that fully support the requirements of small- and large-scale organizations. Developers can use .NET CLR and XML features together with Transact-SQL to build flexible, scalable and robust applications that meet today's business demands. This course provides experience creating server-side applications in .NET, XML and T-SQL.

Who Should Attend

Developers and programmers working with or moving to SQL Server 2005 or 2008. Basic Transact-SQL programming experience at the level of Course 131, "SQL Server 2005 Comprehensive Introduction," Course 137, "SQL Server 2008 Comprehensive Introduction," or equivalent knowledge is assumed.

Hands-On Training

During this course, you perform extensive hands-on exercises that provide in-depth experience. Exercises include:
  • Extracting data from an XML column using XQuery
  • Developing stored procedures in .NET
  • Extending SQL Server by adding new .NET user-defined data types
  • Creating a message-based application using Service Broker
  • Persisting .NET objects in the database using ADO.NET Object Services

Related Courses

 
SQL Server is a registered trademark of Microsoft Corporation. 		 

Upcoming Dates

Dec 9 - 12, 2008
 Washington, DC (Rockville, MD)
Jan 6 - 9, 2009
 New York
Jan 13 - 16, 2009
 Toronto
Jan 20 - 23, 2009
 Ottawa
Feb 24 - 27, 2009
 Los Angeles
Mar 3 - 6, 2009
 Atlanta
Mar 10 - 13, 2009
 New York
Mar 24 - 27, 2009
 Washington, DC (Reston, VA)
Mar 31 - Apr 3, 2009
 N. New Jersey
Apr 7 - 10, 2009
 Philadelphia
Apr 14 - 17, 2009
 Washington, DC (Rockville, MD)
Apr 28 - May 1, 2009
 New York
May 5 - 8, 2009
 Dallas
May 12 - 15, 2009
 Chicago (Schaumburg)
May 12 - 15, 2009
 Toronto

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

SQL Server Server-Side Programming: Hands-On

 
Course: 133   Type: Hands-On Training   Duration: 4 Days
 
 
Course 133 Content
 

SQL Server Architecture

  • SQL Server edition overview
  • SQL Server Management Studio

Working with XML

Storing XML data

  • Creating and managing XML SCHEMA COLLECTIONS
  • Defining untyped and typed XML columns
  • Converting query results for storage in an XML variable
  • Loading XML from the file system into a variable

Leveraging XQuery capabilities

  • Filtering rows based on XML elements
  • Extracting data from an XML column
  • Directly updating XML data in the database

Producing XML data

  • Extending queries with FOR XML PATH
  • Using PATH, TYPE and sub-queries to create nested XML
  • Controlling XML elements and attributes using column aliases

Receiving XML data

  • Converting XML data to a relational form using OPENXML
  • Using XPATH at row and column level to transform complex XML structures

Encrypting data

  • Creating a MASTER KEY
  • Encrypting and decrypting with a pass phrase
  • Contrasting asymmetric and symmetric keys
  • Utilizing a certificate to encrypt data

Creating Applications with Service Broker

Designing asynchronous messaging systems

  • Improving scalability with queuing
  • Taking advantage of reliable message delivery
  • Offload processing to multiple back end servers

Managing routing and security

  • Defining security credentials with remote services
  • Adding new transport routes to the routing table
  • Creating service broker end points

Sending and receiving messages

  • Defining contracts to control conversations
  • Handling message order and unique delivery with conversation group locks

Controlling message delivery

  • Associating message types with XML schema collections
  • Starting conversations with BEGIN DIALOG
  • Managing reliability using transactions
  • Ensuring messages are safe using encryption
  • Designing an effective error handling strategy

Integrating .NET with SQL Server

Incorporating CLR

  • Contrasting Transact-SQL with the rich .NET programming model
  • Improving code safety and security using .NET

Developing procedural code in .NET

  • Writing stored procedures in a .NET language
  • Loading and unloading assemblies
  • Carrying out a refresh on an existing assembly
  • Improving code level security using the PERMISSION_SET clause
  • Controlling assembly deployment using the TRUSTWORTHY database option

Defining scalar and table valued functions

  • Converting a .NET expression into a function
  • Invoking a CLR function from a Transact-SQL SELECT statement
  • Taking advantage of asynchronous data access using .NET table value functions

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

Managing Data from .NET Code

Extending SQL Server with .NET

  • Developing aggregates for enhanced functionality
  • Augmenting SQL Server with .NET user-defined data types
  • Adding custom methods to extend user-defined data types
  • Contrasting .NET data types and the XML data type for storing complex data structures

Retrieving and storing data

  • Taking advantage of the SqlContext object
  • Accessing data using traditional ADO.NET and "context connection"
  • Querying and retrieving data using LINQ
  • Persisting .NET objects in the database with ADO.NET Object Services
 
http://www.lerningtree.com/courses/133pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

SQL Server Server-Side Programming: Hands-On Tuition

 
Course: 133   Type: Hands-On Training   Duration: 4 Days
 
 

Course Tuition
$ 2,790 Standard Tuition
Tuition with a Savings Plan
$ 1,800 10-Day Pass
$ 1,670 Training Passport
$ 1,700 Premium-Pass
$ 2,200 Voucher 10-Pack
$ 2,515 Alumni Gold Discount
$ 2,484 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/133pf.htm