Transact-SQL Programming Techniques and Error Handling

This course begins by teaching you how to use subqueries within your queries. You will learn that most subqueries are self-contained and have no connection with the outer query other than passing its results. You will study the APPLY operator, the Temporary table, the common table expressions(CTEs) in SQL queries, and the pivoting data and unpivoting data. You will also learn how to group data using GROUPING SET sub-clause of GROUP BY clause.

You will then learn how to add data to a database using the INSERT function. With this course, you will also learn how to update and delete data from a database as well as identify programming constructs such as IF statements and loops in SQL queries. You will study how to create variables for use within SQL queries as well as the importance of comments to describe SQL code. You will also cover pivoting data and unpivoting data using the PIVOT and UNPIVOT operators.

T-SQL or Transact-SQL is a set of programming extensions from Sybase and Microsoft that add several features to the Structured Query Language (SQL). With this course, you will gain better insight into its programming techniques and error handling features including how to apply operators within your queries and presenting data with views and temporary table, create conditional branching and looping within your queries, and more! Start this course today to enhance your T-SQL abilities!