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.
Author Name: Andrew McSwiggan
Author Description:
Passionate about Business Intelligence and delivering knowledge and insight to support better decisions. An advocate of Self-Service Reporting and Analytics and a Data Visualisation evangelist. Andi has delivered face to face Business Intelligence training to many industries, covering topics such as Report Design, Semantic Layer, Dimensional modeling and Data Visualisation. Andi has led many Data Warehouse and Business Intelligence development projects and is well versed in taking complex an… more

Table of Contents

• 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