T-SQL Functions Playbook

Focused View

Andrew McSwiggan

3:03:47

17 View

1-Course Overview

01-Course Overview.mp4

01:56

2-Creating Measures with Aggregation Functions

02-Creating Measures with Aggregation Functions.mp4

04:26

03-A Tour of the Data.mp4

03:28

04-Creating an Aggregation Query.mp4

03:53

05-Querying Unique Lists of Values.mp4

03:58

06-Querying Aggregations in Lists.mp4

07:24

3-Ranking Data with RANK and PARTITION

07-Ranking Data with Rank and Partition.mp4

06:45

08-The Rank Function.mp4

04:32

09-The Dense Rank Function.mp4

06:59

10-The NTILE Function.mp4

03:30

4-Aggregating and Summarizing Data with Functions#

11-Aggregating and Summarizing Data with Functions.mp4

05:11

12-The Percent Rank Function.mp4

04:17

13-First and Last Value.mp4

06:16

5-Substituting a Table Reference with a ROWSET Function#

14-Substituting a Table Reference with a ROWSET Function.mp4

06:22

15-OPENROWSET Queries.mp4

04:53

6-Query Data with Inline Queries and Scalar Functions

16-Query Data with Inline Queries and Scalar Functions.mp4

03:55

17-Searching for Strings with the LIKE Function.mp4

03:20

18-LIKE Function Demo.mp4

04:45

19-Creating Statements with Simple Scalar Functions.mp4

04:38

20-Formatting Functions.mp4

03:54

21-Inline View Queries and Subqueries.mp4

06:35

22-The Subquery.mp4

02:47

7-Query Data with Static Value Functions

23-Query Data with Static Value Functions.mp4

05:02

24-Monthly Rolling Sales with GETDATE.mp4

05:08

8- Implementing IF Then Logic

25-Implementing IF Then Logic.mp4

02:37

26-Product Groups.mp4

05:44

27-Product Gender.mp4

06:46

28-Intelligent Measures.mp4

03:06

9- Combining Queries with COALESCE

29-Combining Queries with COALESCE.mp4

06:14

30-Adding the COALESCE Function to a Query.mp4

03:11

31-Joining Multiple Queries with COALESCE.mp4

02:23

10-Calculating Values Using String Functions#

32-Calculating Values Using String Functions.mp4

05:19

33-Formatting Strings with Stuff and Replace.mp4

05:01

34-Cutting out the Product Attributes.mp4

04:32

35-Pivoting the Attributes.mp4

03:24

36-Analysing Sales Using Product Attributes.mp4

05:03

11-Calculating Values Using Numeric Scalar Functions#

37-Calculating Values Using Numeric Scalar Functions.mp4

04:54

38-The Round Function.mp4

04:18

39-Creating A B Customer Tags with Modulus.mp4

05:39

40-Creating Alternating Customer A B Tags.mp4

01:42

Description

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.

What You'll Learn?

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.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

SQL

Andrew McSwiggan

Instructor's Courses

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 and chaotic data and turning it into something simple and easy to understand. Andi is a keen cyclist and amateur cook and lives with his wife in Southern Spain.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.