CA flag CA
CA 888-843-8733 US 888-843-8733

SQL Server Transact-SQL Programming

Course 532

  • Duration: 4 days
  • Labs: Yes
  • Language: English
  • Level: Intermediate

Transact-SQL is integral to the power of SQL Server as its features allow developers to create scalable, distributed applications for meeting the demanding requirements of modern organizations. In addition to comprehensive coverage of Microsoft SQL Server, this training course provides you with the skills to create stored procedures and triggers and develop T-SQL that utilizes SQL Server to the fullest.

SQL Server Transact-SQL Programming Delivery Methods

  • In-Person

  • Online

SQL Server Transact-SQL Programming Course Benefits

Develop scalable, distributed applications with Transact-SQL to meet organizational requirements

Create modular code with stored procedures and formulate triggers

Develop reusable code with scalar- and table-valued functions

Handle Transact-SQL runtime errors to create robust software

Audit data changes using AFTER triggers

Leverage continued support with after-course one-on-one instructor coaching and computing sandbox

SQL Server Transact-SQL Programming Instructor-Led Course Outline

Prerequisites

Who Should Attend?

This course benefits database developers, administrators, and analysts who want to expand their knowledge of SQL Server. Attendees should have experience with SQL Server at the level of Learning Tree Course 2107: Microsoft SQL Server Training Course

Exam Information

Learning Tree Exam provided at the end of class

  • SQL Server edition overview
  • SQL Server Management Studio

Creating 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

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
  • Executing remote procedures
  • Capturing RETURN values from stored procedures

Declaring variables and parameters

  • Creating and utilizing local variables
  • Passing input and output parameters

Calling built-in scalar functions

  • Converting data using CAST and CONVERT
  • Ordering data with ranking functions

Modifying 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

Programming procedural statements

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

Handling errors

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

Producing server-side result sets

  • Building and using temporary tables
  • Processing rows on the server with a cursor
  • Taking advantage of table variables

Storing queries on the server

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

Creating user-defined functions

  • Calculating values with scalar functions
  • Taking advantage of schema binding

Formulating triggers

  • INSTEAD OF vs. AFTER triggers
  • Detecting row changes using the inserted/deleted tables
  • Tracing metadata changes with DDL triggers
  • Auditing user access using a LOGON trigger
  • Tracking data changes with the OUTPUT clause
Get This Course $3,285 $2,890 For Team Prices Call: 888-843-8733

  • 4-day instructor-led training course

  • Hands-on labs included

  • Learning Tree end-of-course exam included

  • After-course instructor coaching benefit

  • After-course computing sandbox included

#532
  • Jun 26 - 29 9:00 AM - 4:30 PM EDT
    Virtual
  • Aug 1 - 4 9:00 AM - 4:30 PM EDT
    Herndon, VA or Virtual
  • Aug 29 - Sep 1 9:00 AM - 4:30 PM EDT
    New York or Virtual
  • Sep 25 - 28 9:00 AM - 4:30 PM EDT
    Ottawa or Virtual
  • Oct 31 - Nov 3 9:00 AM - 4:30 PM EDT
    Herndon, VA or Virtual
  • Nov 28 - Dec 1 9:00 AM - 4:30 PM EST
    New York or Virtual
  • Dec 19 - 22 9:00 AM - 4:30 PM EST
    Ottawa or Virtual
  • Jan 30 - Feb 2 9:00 AM - 4:30 PM EST
    Herndon, VA or Virtual
  • Feb 27 - Mar 1 9:00 AM - 4:30 PM EST
    New York or Virtual
  • Mar 25 - 28 9:00 AM - 4:30 PM EDT
    Ottawa or Virtual
  • Apr 23 - 26 9:00 AM - 4:30 PM EDT
    Virtual
  • May 28 - 31 9:00 AM - 4:30 PM EDT
    New York or Virtual

Scroll to view additional course dates

  • 4-day instructor-led training course

  • Hands-on labs included

  • Learning Tree end-of-course exam included

  • After-course instructor coaching benefit

  • After-course computing sandbox included

#532
  • Jun 26 - 29 9:00 AM - 4:30 PM EDT
    Virtual
  • Aug 1 - 4 9:00 AM - 4:30 PM EDT
    Herndon, VA or Virtual
  • Aug 29 - Sep 1 9:00 AM - 4:30 PM EDT
    New York or Virtual
  • Sep 25 - 28 9:00 AM - 4:30 PM EDT
    Ottawa or Virtual
  • Oct 31 - Nov 3 9:00 AM - 4:30 PM EDT
    Herndon, VA or Virtual
  • Nov 28 - Dec 1 9:00 AM - 4:30 PM EST
    New York or Virtual
  • Dec 19 - 22 9:00 AM - 4:30 PM EST
    Ottawa or Virtual
  • Jan 30 - Feb 2 9:00 AM - 4:30 PM EST
    Herndon, VA or Virtual
  • Feb 27 - Mar 1 9:00 AM - 4:30 PM EST
    New York or Virtual
  • Mar 25 - 28 9:00 AM - 4:30 PM EDT
    Ottawa or Virtual
  • Apr 23 - 26 9:00 AM - 4:30 PM EDT
    Virtual
  • May 28 - 31 9:00 AM - 4:30 PM EDT
    New York or Virtual

Scroll to view additional course dates

  • Bring this or any training to your organization

  • Full-scale program development

  • Delivered when, where, and how you want it

  • Blended learning models

  • Tailored content

  • Expert team coaching

#532
Questions about this course?
* Required Fields
Customize Your Team Training Experience

Fill out the form below or call 888-843-8733

* Required Fields
Preferred method of contact:

Need Help Finding The Right Training Solution?

Our training advisors are here for you.

Contact Us

SQL Server Transact-SQL Programming FAQs

Yes! This course benefits database developers, administrators, and analysts who want to expand their knowledge of SQL Server. This is a great follow-on for those who just came out of the introduction course!

Yes! Learning Tree introduced this course as a replacement course for the Microsoft legacy course retirement; Querying Data with Transact-SQL (20761).  

Yes, this course benefits database developers, administrators, and analysts who want to expand their knowledge of SQL Server. Attendees should have experience with SQL Server at the level of Learning Tree Course 2107: Microsoft SQL Server Training Course

Related Courses

  • Microsoft
    Microsoft SQL Server Training Course

    Learning Tree's SQL programming course covers SQL Server basics: database management, table creation, and query writing for beginners.

    Foundation
    4 days
    Online or In-class
    Starts from $3,285
Chat With Us