Database Programming Using T-SQL

collapse

Course Details

This course can only be taken as part of the Certificate in SQL Server & Database Development.

Get Program Details

About this Course


This course builds on the fundamental concepts introduced in Course 1 and provides a strong foundation in the basics of Transact-SQL (T-SQL) programming extensions. You'll learn how to employ scalar and table-valued functions, branching and conditional logic, transactions and concurrency, and more advanced data structures.  

What You'll Learn

  • How to query and manipulate data using Transact-SQL 
  • Ways to understand transactions and error handling 
  • Methods for reading graphical execution plans and look for performance bottlenecks 
  • How to execute advanced SQL Server programming objects such as triggers, table variables, common table expressions, windowing functions and some tuning techniques 

Get Hands-On Experience

  • Build efficient data access solutions with SQL Server
  • Create modular and reusable code in functions and stored procedures

Program Overview

This course is part of the Certificate in SQL Server & Database Development.

  Get our email newsletter with career tips, event invites and upcoming program info.       Sign Up Now