Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.
Mastering T-SQLMastering 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.
Steve Jones
May 6, 2014
1 Min Read
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
Session 2: Intermediate Queries
Session 3: Windowing Functions in SQL Server
About the Author
You May Also Like
.jpg?width=700&auto=webp&quality=80&disable=upscale)
