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

SQL Server Transact-SQL Programming: Hands-On

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

Quick Enroll    

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 organizations. This course provides extensive experience creating stored procedures and triggers, and developing T-SQL that utilizes 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

Course 532 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
  • Minimizing 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
  • Combining tabular results with UNION, INTERSECT and EXCEPT
  • Executing remote procedures
  • 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 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
Related Courses
Transact-SQL 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 Up to 45% per course with this limited offer!

SQL Server Transact-SQL Programming: Hands-On
Classroom Dates
Aug 11-14: Washington, DC
     (Rockville, MD) enroll
Aug 25-28: New York enroll
Aug 25-28: Toronto enroll
Sep 8-11: Washington, DC
     (Reston, VA) enroll
Oct 13-16: Washington, DC
     (Rockville, MD) enroll
Nov 10-13: New York enroll
Jan 12-15: Toronto enroll
Jan 19-22: Washington, DC
     (Reston, VA) enroll
Feb 23-26: New York enroll
Feb 23-26: Ottawa enroll
See the complete schedule of classroom sessions scheduled in our training locations.
 
On-Site Training
Bring this or any Learning Tree course to your location.
 
Course Tuition
$ 2,790 Standard Tuition
Tuition with a Savings Plan
$ 1,667 Training Passport
$ 1,700 Premium-Pass
$ 2,170 Triple-Pack
$ 2,200 Voucher 10-Pack
$ 2,515 Alumni Gold Discount
$ 2,484 Government Discount
 

 

SQL Server Transact-SQL Programming: Hands-On
SQL Server Transact-SQL Programming: Hands-On
Participants debugging a Transact-SQL stored procedure.


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