T-SQL Functions Playbook

By Andrew McSwiggan
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.
Play course overview
Course info
Rating
(40)
Level
Intermediate
Updated
Jan 23, 2020
Duration
3h 3m
Table of contents
Course Overview
Course Overview 2m
Creating Measures with Aggregation Functions
Creating Measures with Aggregation Functions 4m A Tour of the Data 3m Creating an Aggregation Query 4m Querying Unique Lists of Values 4m Querying Aggregations in Lists 7m
Ranking Data with RANK and PARTITION
Ranking Data with Rank and Partition 7m The Rank Function 5m The Dense Rank Function 7m The NTILE Function 4m
Aggregating and Summarizing Data with Functions
Aggregating and Summarizing Data with Functions 5m The Percent Rank Function 4m First and Last Value 6m
Substituting a Table Reference with a ROWSET Function
Substituting a Table Reference with a ROWSET Function 6m OPENROWSET Queries 5m
Query Data with Inline Queries and Scalar Functions
Query Data with Inline Queries and Scalar Functions 4m Searching for Strings with the LIKE Function 3m LIKE Function Demo 5m Creating Statements with Simple Scalar Functions 5m Formatting Functions 4m Inline View Queries and Subqueries 7m The Subquery 3m
Query Data with Static Value Functions
Query Data with Static Value Functions 5m Monthly Rolling Sales with GETDATE 5m
Implementing IF Then Logic
Implementing IF Then Logic 3m Product Groups 6m Product Gender 7m Intelligent Measures 3m
Combining Queries with COALESCE
Combining Queries with COALESCE 6m Adding the COALESCE Function to a Query 3m Joining Multiple Queries with COALESCE 2m
Calculating Values Using String Functions
Calculating Values Using String Functions 5m Formatting Strings with Stuff and Replace 5m Cutting out the Product Attributes 5m Pivoting the Attributes 3m Analysing Sales Using Product Attributes 5m
Calculating Values Using Numeric Scalar Functions
Calculating Values Using Numeric Scalar Functions 5m The Round Function 4m Creating A B Customer Tags with Modulus 6m Creating Alternating Customer A B Tags 2m
Description
Course info
Rating
(40)
Level
Intermediate
Updated
Jan 23, 2020
Duration
3h 3m
Description

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.

About the author
Andrew McSwiggan
About the author

Passionate about Business Intelligence and delivering knowledge and insight to support better decisions. An advocate of Self-Service Reporting, Analytics Data Visualisation. Andi has delivered face to face Business Intelligence training covering topics such as Report Design, Dimensional modeling, and Data Visualisation. Andi is a keen cyclist and amateur cook and lives with his wife in Southern Spain.

More from the author
Human Factors in Data Visualization
Intermediate
3h 16m
Sep 15, 2020
Using Deductive Reasoning in Decision Making
Beginner
2h 8m
May 30, 2020
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] Hi, everyone. My name is Andrew Max Wigan on Welcome to my course T SQL Functions Playbook. I am a data specialist and I use the t SQL language to structure and analyze data. T SQL offers an array of powerful functions that enable the initiated to extract meaning from data stored inside SQL server databases. I introduce you to aggregation and ranking functions that will enable you to elevate the data to something concise and insightful. Every function you learn will provide you with the solution or common analytical problem. Everything you learn along the way will empower you to take control of your data. Some of the key topics that I explore with t SQL are creating measures with aggregation functions, implementing logical expressions that evaluate transformed columns or every row returned by a query embedding one query inside another within line views and correlated sub queries, putting out parts of dates and text fields rounding and formatting numbers, transforming content to add meaning. By the end of the course, you will know how to use the analytical functions provided by the T SQL language. Before beginning the course, you should have a working knowledge of the T SQL language, the rudimentary, the standing of Data Analytics. I hope that you will join me on this journey to learn how to use analytical functions with T SQL functions Playbook course Pluralsight.

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT