When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.
T-SQL Functions Playbook
In this course you will explore the functions of the T-SQL language that support data access, manipulation, aggregation, and analysis. Completing this course will provide you with the skills to shape and analyze data in SQL Server.
This Course Includes
pluralsight
4 (71 reviews )
3 hour 4 minutes 
english
Online - Self Paced
core courses
pluralsight
About T-SQL Functions Playbook
As a data professional you often need to write queries to summarize and gain insight from data.
In this course, T-SQL Functions Playbook, you will learn how to use powerful functions inside your T-SQL queries to reshape and interrogate data. First, you will learn how to aggregate data with aggregation functions. Next, you will see how to merge data from multiple queries from within and outside of your local SQL Server environment. Finally, you will discover how to apply logic calculations and formatting to transform data and make it more readable. When you have completed this course, you will have the skills to take control of and analyze your data. Software required: SQL Server Management Studio.
What You Will Learn?
- Course Overview : 1min.
- Creating Measures with Aggregation Functions : 23mins.
- Ranking Data with RANK and PARTITION : 21mins.
- Aggregating and Summarizing Data with Functions : 15mins.
- Substituting a Table Reference with a ROWSET Function : 11mins.
- Query Data with Inline Queries and Scalar Functions : 29mins.
- Query Data with Static Value Functions : 10mins.
- Implementing IF Then Logic : 18mins.
- Combining Queries with COALESCE : 11mins.
- Calculating Values Using String Functions : 23mins.
- Calculating Values Using Numeric Scalar Functions : 16mins.