Home About Courses Schedule Services Webinars Contact Search

Transact-SQL Programming

SEE SCHEDULE

Duration: 3.0 days

Method: Instructor led with hands-on.

Price: $1920.00

Course Code: SS1020



Audience

SQL Server Developers looking to extend the functionality of the database.

Description

Transact-SQL allows you to use the SQL language to write procedural scripts for use with your databases. This language is used to write Stored Procedures, User-defined Functions and Triggers. This course will get you ready to do all of the above.

Objectives

Upon successful completion of this course, the student will be able to:

  • Work with SQL Server Management Studio
  • Code and test scripts
  • Implement Stored Procedures
  • Implement User-defined Functions
  • Write Triggers

Prerequisites

A working knowledge of SQL.

Topics

  1. Working with SQL Server Management Studio
    • Connecting to SQL Server
    • Navigating Databases
    • Writing SQL in Management Studio
  2. Coding Scripts
    • Transact-SQL statements for script processing
    • Scalar variables
    • Table variables
    • Temporary tables
    • Comparison of types of Transact-SQL table objects
    • Debugging Scripts
  3. Controlling the Execution of Scripts
    • Conditional processing
    • Testing for the existence of database objects
    • Repetitive processing
    • Using cursors
    • Handling errors
  4. Advanced Scripting Techniques
    • Using system functions
    • Changing session settings
    • Using dynamic SQL
  5. Stored Procedures
    • Creating a stored procedure
    • Declaring and working with parameters
    • Calling a stored procedure with parameters
    • Returning data from a stored procedure
    • Validation and raising errors
    • Passing a table as a parameter
    • System supplied stored procedures
  6. User-defined Functions (UDFs)
    • Creating a UDF
    • Scalar UDFs
    • Table-valued Functions
  7. Triggers
    • Creating and using an AFTER Trigger
    • Creating and using INSTEAD OF Triggers
    • Enforcing business rules with Triggers
  8. Transactions and Locking
    • Working with transactions
      • COMMIT
      • ROLLBACK
    • Concurrency and locking