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

SQL Server 2005 Server-Side Programming: Hands-On

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

Quick Enroll    

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

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

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 Server-Side Programming: Hands-On
Upcoming Dates
Jun 2 - 6, 2008
 Washington, DC (Reston, VA)
Jul 14 - 18, 2008
 Ottawa
Aug 11 - 15, 2008
 Washington, DC (Rockville, MD)
Aug 25 - 29, 2008
 Los Angeles
Sep 8 - 12, 2008
 New York
Sep 8 - 12, 2008
 Toronto
Sep 22 - 26, 2008
 Washington, DC (Reston, VA)
Dec 8 - 12, 2008
 Washington, DC (Rockville, MD)
Jan 5 - 9, 2009
 New York
Jan 12 - 16, 2009
 Toronto

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

Course Tuition
$ 2,950 Standard Tuition
Tuition with a Savings Plan
$ 2,075 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
 

 

SQL Server 2005 Server-Side Programming: Hands-On
SQL Server 2005 Server-Side Programming: Hands-On
Participants writing a stored procedure in SQL Server 2005.

SQL Server 2005 for the Enterprise


Certification Core Course CPE 29 Credits Vendor Cert - Microsoft 2 Hour(s) College Credit
Customer Service or Enroll: 1-800-843-8733