Loading

Transact-SQL Programming Techniques and Error Handling

Gain a better understanding of T-SQL with a focus on programming techniques and error handling with this course.

Publisher: Channel 9
This free online Transact-SQL course will teach you Programming Techniques and Error Handling. It will give you a better understanding of the different options for queries and subqueries. You will learn the process of handling, raising, and catching errors as well as how to modify your data and use the program within your queries. You will also learn how to apply operators within your queries, and present data with views and temporary table.
Transact-SQL Programming Techniques and Error Handling
  • Duration

    1.5-3 Hours
  • Students

    2,695
  • Accreditation

    CPD

Description

Modules

Outcome

Certification

View course modules

Description

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!

Start Course Now

Careers