Mastering T-SQL
Total Running Time: 193 minutes This one-day online training course will introduce you to a number of intermediate-level concepts that will improve the T-SQL code you write. You will learn about windowing functions, error handling, aggregates, pivoting data, and CTEs along with a few tips and tricks for coding faster.
May 6, 2014
![Mastering T-SQL Mastering T-SQL](https://eu-images.contentstack.com/v3/assets/blt07f68461ccd75245/bltba8287ad2a5161a4/661945a1fda0943cf1435a54/codepen_0_3.jpg?width=1280&auto=webp&quality=95&format=jpg&disable=upscale)
Running Time: 193 minutes
This one-day online training course will introduce you to a number of intermediate-level concepts that will improve the T-SQL code you write. You will learn about windowing functions, error handling, aggregates, pivoting data, and CTEs along with a few tips and tricks for coding faster.
By the end of this course, you will learn how to:
Implement error handling using TRY..CATCH as well as THROW
Write basic window queries with as LEAD/LAG and partitions
Write CTEs and use them to simplify code
Write PIVOT queries for move row data to columns
Session 1: Writing Cleaner Code
About the Author
You May Also Like