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.

1. Course Overview

1. Course Overview

2. Creating Measures with Aggregation Functions

1. Creating Measures with Aggregation Functions

2. A Tour of the Data

3. Creating an Aggregation Query

4. Querying Unique Lists of Values

5. Querying Aggregations in Lists

3. Ranking Data with RANK and PARTITION

1. Ranking Data with Rank and Partition

2. The Rank Function

3. The Dense Rank Function

4. The NTILE Function

4. Aggregating and Summarizing Data with Functions

1. Aggregating and Summarizing Data with Functions

2. The Percent Rank Function

3. First and Last Value

5. Substituting a Table Reference with a ROWSET Function

1. Substituting a Table Reference with a ROWSET Function

2. OPENROWSET Queries

6. Query Data with Inline Queries and Scalar Functions

1. Query Data with Inline Queries and Scalar Functions

2. Searching for Strings with the LIKE Function

3. LIKE Function Demo

4. Creating Statements with Simple Scalar Functions

5. Formatting Functions

6. Inline View Queries and Subqueries

7. The Subquery

7. Query Data with Static Value Functions

1. Query Data with Static Value Functions

2. Monthly Rolling Sales with GETDATE

8. Implementing IF Then Logic

1. Implementing IF Then Logic

2. Product Groups

3. Product Gender

4. Intelligent Measures

9. Combining Queries with COALESCE

1. Combining Queries with COALESCE

2. Adding the COALESCE Function to a Query

3. Joining Multiple Queries with COALESCE

10. Calculating Values Using String Functions

1. Calculating Values Using String Functions

2. Formatting Strings with Stuff and Replace

3. Cutting out the Product Attributes

4. Pivoting the Attributes

5. Analysing Sales Using Product Attributes

11. Calculating Values Using Numeric Scalar Functions

1. Calculating Values Using Numeric Scalar Functions

2. The Round Function

3. Creating A B Customer Tags with Modulus

4. Creating Alternating Customer A B Tags

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: PluralSight