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

SQL Server 2005 Server-Side Programming: Hands-On

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

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

Related Courses

 
SQL Server is a trademark of Sybase, Inc. 		 

Upcoming Dates

Sep 8 - 12, 2008
 New York
Sep 8 - 12, 2008
 Toronto
Sep 22 - 26, 2008
 Washington, DC (Reston, VA)
Oct 27 - 31, 2008
 Washington, DC (Alexandria, VA)
Nov 18 - 21, 2008
 New York
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 24 - 27, 2009
 Washington, DC (Reston, VA)
Apr 14 - 17, 2009
 Washington, DC (Rockville, MD)
Apr 28 - May 1, 2009
 New York
May 12 - 15, 2009
 Toronto

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

SQL Server 2005 Server-Side Programming: Hands-On

 
Course: 133   Type: Hands-On Training   Duration: 5 Days
 
 
Course 133 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 utilizing 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
  • Utilizing optimizer hints
 
http://www.learningtree.com/courses/133pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

SQL Server 2005 Server-Side Programming: Hands-On Tuition

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

Course Tuition
$ 2,950 Standard Tuition
Tuition with a Savings Plan
$ 1,580 10-Day Pass
$ 1,665 Training Passport
$ 1,830 Flex-Pass
$ 2,095 Voucher 10-Pack
$ 2,655 Alumni Gold Discount
$ 2,620 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,665 per course
  • Savings as much as 40%
  • Only $4,990
Flex Pass
  • 3 courses in 24 months
  • As little as $1,830 per course
  • Save as much as 35%
10-Day Pass
  • A NEW way to save on training
  • 10 days of training for one person
  • Save as much as $1,070 per course
  • Only $3,950
Training Vouchers
  • Save as much as $960 per course
  • Fully transferable
  • As low as $2,095 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 $295 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.learningtree.com/courses/133pf.htm