T-SQL Window Functions [2015, ENG] torrent

Обучающие видео » Компьютерные видеоуроки и обучающие интерактивные DVD » Программирование (видеоуроки)

T-SQL Window Functions

Год выпуска: 2015
Производитель: Pluralsight
Сайт производителя: pliuralsight.com
Автор: Kathi Kellenberger
Степень сложности: средняя
Продолжительность: 2:31
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание: With the 2005 and 2012 releases of SQL Server, Microsoft gave us several new functions with amazing capabilities. These functions are part of the ANSI standards, and have nothing to do with the Windows OS. Some of these functions are well known, for example ROW_NUMBER is used by many people. In addition to ROW_NUMBER, we now have the ability to calculate summaries without changing a query to an aggregate query, calculate running totals, pull values from other rows, and perform statistical calculations. This course covers all of the available window functions including syntax, real world examples, and performance considerations.
[spoiler="Содержание"]
Getting Started
Introduction to Window Functions
Demo 1: The Stock Market Problem
Tools to Measure Performance
Demo 2: Measuring Performance
Course Overview

Understanding the OVER Clause
The Parts of the OVER Clause
Demonstration: OVER Clause
Module Overview

Using Ranking Functions
The Ranking Functions
Demo 1: Ranking Functions
Real World Examples
Demo 2: Real World Examples
Special Cases: Top and Distinct
Demo 3: Top and Distinct
Ranking Function Performance
Demo 4: Performance
What's Next?

Using Window Aggregate Functions
Introduction
Demo 1: Window Aggregates
Real World Examples
Demo 2: Real World Examples
Special Cases: Aggregate Queries and Distinct
Demo 3: Aggregate Queries and Distinct
Custom Aggregates
Demo 4: Custom Aggregates
Performance
Demo 5: Performance
What's Next?

Understanding Framing
Introduction
Framing Example
Framing Syntax
ROWS vs. RANGE
Syntax Review
What's Next?

Using Accumulating Window Aggregates
Introduction
Demo 1: Add the ORDER BY
Framing
Demo 2: Framing
The Subscription Puzzle
Demo 3: The Subscription Puzzle
Performance
Demo 4: Performance
What's Next?

Retrieving Data from Other Rows
Introduction
Demo 1: Using LAG and LEAD
Using FIRST_VALUE and LAST_VALUE
Demo 2: Using FIRST_VALUE and LAST_VALUE
Real World Examples
Demo 3: Real World Examples
Performance
Demo 4: Performance
What's Next?

Using Statistical Functions
Introduction
Demo 1: Using PERCENT_RANK and CUME_DIST
Using PERCENTILE_CONT and PERCENTILE_DISC
Demo 2: Using PERCENTILE_CONT and PERCENTILE_DISC
Real World Examples
Demo 3: Real World Examples
Performance
Demo 4: Performance
Course Summary
[/spoiler]
Файлы примеров: присутствуют
Формат видео: MP4
Видео: AVC, 1024x768, 4:3, 15fps, 329kbps
Аудио: AAC, 44.1kHz, 128kbps, stereo
[spoiler="Скриншоты"]

[/spoiler]