0800 282 353 or +44 1372 364610
Productivity through Education®
 
 

SQL Server Transact-SQL® Programming: Hands-On

 
Course: 532   Duration: 4 Days
 
 

You Will Learn How To

  • Develop database applications for SQL Server databases with Transact-SQL
  • Create modular code using stored procedures
  • Develop reusable code with scalar- and table-valued functions
  • Handle Transact-SQL runtime errors to create robust software
  • Audit data changes using AFTER triggers
  • Manage concurrency using transactions and locking options

Course Benefits

Transact-SQL is integral to the power of SQL Server. Transact-SQL features allow developers to create scalable, distributed applications to meet the demanding requirements of modern organisations. This course provides extensive experience creating stored procedures and triggers, and developing T-SQL that utilises SQL Server to the fullest.

Who Should Attend

Database developers, administrators and analysts who want to expand their knowledge of SQL Server 2005 or 2008. Experience with SQL Server at the level of Course 131, "SQL Server 2005 Comprehensive Introduction", or Course 137, "SQL Server 2008 Comprehensive Introduction", is assumed.

Hands-On Training

A series of hands-on exercises provides immediate experience in Transact-SQL development, including:
  • Adding a column to a database table using ALTER TABLE
  • Passing data into a stored procedure using parameters
  • Modifying data in a transaction
  • Intercepting errors with TRY...CATCH
  • Calling a user-defined function in a SQL statement
  • Writing triggers to carry out advanced validation
  • Tracing metadata changes with DDL triggers

Related Courses

  • 534 SQL Queries for SQL Server
  • 535 High-Performance SQL Server Databases
  • 134 SQL Server Integration Services
  • 139 SQL Server Analysis Services
  • 138 SQL Server 2008 Database Administration
  • 141 SQL Server High Availability
  • 146 Microsoft Tools for Business Intelligence
  • 382 Relational Database Design
  • 140 SQL Server 2008 Reporting Services

 
Transact-SQL is a registered trademark of Sybase, Inc.
   SQL Server Transact-SQL Programming

Upcoming Dates

Live online classroom training.Attend highlighted events in person or live, online via Learning Tree AnyWareTM.

UK Dates

2-5 AprLondon
26-29 JunLondon
18-21 SepLondon
11-14 DecLondon

US East Coast Dates

1-4 MayWashington, DC*

*New York and Washington, DC Courses – Available online with a run time of 2pm to 9pm BST.

For AnyWare enrolments, please register at least 10 days prior to the start of the course.


For complete schedule, please visit www.learningtree.co.uk
 
http://www.learningtree.co.uk/courses/uk532.htm
 
 
0800 282 353 or +44 1372 364610
Productivity through Education®
 
 

SQL Server Transact-SQL® Programming: Hands-On

 
Course: 532   Duration: 4 Days
 
 
Course Content
 

SQL Server Architecture

  • SQL Server edition overview
  • Introducing the tools
  • SQL Server Management Studio

Managing Tables with DDL

Creating schemas

  • Managing schemas
  • Referencing schemas versus using the default schema
  • Hiding schemas with synonyms

Building 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

Batch and stored procedure processing

  • Minimising network traffic using batches and procedures
  • Stored procedure compilation and execution
  • Using scalar functions

Selecting data

  • Developing stored procedures that extract data from multiple servers
  • Executing dynamic queries using OPENROWSET and OPENQUERY
  • Executing remote procedures
  • Combining results from multiple databases
  • Capturing RETURN values from stored procedures

Declaring variables and parameters

  • Creating and utilising 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 and distributed transactions
  • Managing concurrency with isolation levels
  • SQL Server locking fundamentals
  • Avoiding blocking problems with read-committed snapshot isolation
  • Managing locks using hints

Programming procedural statements

  • Implementing conditions with IF...ELSE
  • Looping with WHILE and GOTO
  • Creating code blocks with BEGIN...END
  • Debugging with PRINT
  • Returning data using RETURN
  • Debugging T-SQL in Management Studio

Handling errors

  • Communicating problems to the client with RAISERROR
  • Intercepting errors with TRY...CATCH
  • Dealing with open transactions when an exception occurs

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

Storing queries on the server

  • Concealing complexity with views
  • Solving business problems using multistatement table-valued functions

Creating user-defined functions

  • Calculating values with scalar functions
  • Processing multiple rows returned from a table-valued function
  • Taking advantage of schema binding

Formulating triggers

  • INSTEAD OF vs. AFTER triggers
  • Detecting row changes using the inserted and deleted tables
  • Tracking metadata changes with DDL triggers
  • Auditing user access using a LOGON trigger
  • Tracking data changes with the OUTPUT clause
 
http://www.learningtree.co.uk/courses/uk532.htm
 
 
0800 282 353 or +44 1372 364610
Productivity through Education®
 
 

SQL Server Transact-SQL® Programming: Hands-On

 
Course: 532   Duration: 4 Days
 
 
Course Fees
£ 1,925Standard Fee
Fee with a Savings Plan
£ 1,2252-Course Passport
£ 1,0853-Course Passport
£ 1,0004-Course Passport
£ 1,600Voucher 10-Pack

Your Course Fee Entitles You To...

  • Class participation
  • Team workshops
  • Use of in-class hands-on equipment
  • Comprehensive course materials
  • Morning and afternoon refreshments
  • Course Completion Certificate
  • FREE participation in the Learning Tree Professional Certification Programmes (including related exams)
  
 

Savings Plans

2-Course Passport
  • 2 Courses in 12 months for £2,450
  • As little as £1,225 per course
  • Savings up to 45% per course
3-Course Passport
  • 3 Courses in 24 months for £3,250
  • As little as £1,085 per course
  • Savings up to 50% per course
4-Course Passport
  • 4 Courses in 24 months for £4,000
  • As little as £1,000 per course
  • Savings up to 55% per course
Training Vouchers
  • Save as much as £675 per course
  • Fully transferable
  • As low as £1,600 per course
* Exact savings may vary depending on courses selected.

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

Enrolling is Easy and Flexible!

Enrol 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 enrolment. Pay after you've taken the course, and then only if you are 100% satisfied.
 
http://www.learningtree.co.uk/courses/uk532.htm