MDX Fundamentals [2013, ENG]

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

MDX Fundamentals

Год выпуска: 2013
Производитель: Pluralsight
Автор: Stacia Misner
Продолжительность: 3h 37m
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Описание:
Курс объясняет ключевые концепции MDX, частые в применении ф-ции и демонстрирует MDX запросы.

This course provides an introduction to MDX by explaining key concepts, introducing commonly used functions, and demonstrating working examples of MDX queries.
This course explains how to use MDX to query an Analysis Services multidimensional database.
It begins with an introduction to the language, showing how it can be used beyond developing a cube, as well as an introduction to important concepts such as tuples and sets.
The course then focuses on how to structure queries and how to create sets to use on a query axis.
The course then continues with an exploration of the multiple navigation functions used to traverse hierarchical data.
Last, it explains how to build more complex queries by adding calculations in the form of calculated measures, calculated members, and named sets.
This course was written for SQL Server 2012 Analysis Services, but most principles apply to SQL Server 2005 and later.
[spoiler="Содержание"]
FileName Size Length Bit rate Data rate Resolution Frame Rate Parent Folder
01.Introduction 926 KB 0:00:40 ‎128kbps 872.00 1024x768 ‎15 frames/second 01.Introduction to MDX
02.Introduction to MDX 1.57 MB 0:01:06 ‎128kbps 997.00 1024x768 ‎15 frames/second 01.Introduction to MDX
03.Demo - Comparing MDX to SQL Part 1 10.8 MB 0:06:11 ‎128kbps 237.00 1024x768 ‎15 frames/second 01.Introduction to MDX
04.Demo - Comparing MDX to SQL Part 2 12.3 MB 0:06:18 ‎128kbps 260.00 1024x768 ‎15 frames/second 01.Introduction to MDX
05.Demo - Comparing MDX to SQL Part 3 10.5 MB 0:05:26 ‎128kbps 275.00 1024x768 ‎15 frames/second 01.Introduction to MDX
06.MDX Usage 6.24 MB 0:04:15 ‎128kbps 1452.00 1024x768 ‎15 frames/second 01.Introduction to MDX
07.Multidimensional Model Terms and Concepts 4.43 MB 0:03:14 ‎128kbps 1103.00 1024x768 ‎15 frames/second 01.Introduction to MDX
08.Tuples and Sets 9.17 MB 0:06:22 ‎128kbps 1581.00 1024x768 ‎15 frames/second 01.Introduction to MDX
09.Summary 2.05 MB 0:01:30 ‎128kbps 883.00 1024x768 ‎15 frames/second 01.Introduction to MDX
01.Introduction 1.80 MB 0:01:22 ‎128kbps 843.00 1024x768 ‎15 frames/second 02.Basic MDX Queries
02.Identifiers 6.27 MB 0:04:21 ‎128kbps 1211.00 1024x768 ‎15 frames/second 02.Basic MDX Queries
03.Tuple Request 3.89 MB 0:02:23 ‎128kbps 109.00 1024x768 ‎15 frames/second 02.Basic MDX Queries
04.Axes 1.93 MB 0:01:22 ‎128kbps 785.00 1024x768 ‎15 frames/second 02.Basic MDX Queries
05.Sets 1.40 MB 0:01:01 ‎128kbps 750.00 1024x768 ‎15 frames/second 02.Basic MDX Queries
06.Demo - Axes 10.2 MB 0:06:14 ‎128kbps 1995.00 1024x768 ‎15 frames/second 02.Basic MDX Queries
07.Demo - Sets on Axes 5.54 MB 0:02:59 ‎128kbps 2014.00 1024x768 ‎15 frames/second 02.Basic MDX Queries
08.Empty Rows or Columns 1.05 MB 0:00:41 ‎128kbps 99.00 1024x768 ‎15 frames/second 02.Basic MDX Queries
09.Demo - NON EMPTY keyword 3.56 MB 0:02:05 ‎128kbps 1990.00 1024x768 ‎15 frames/second 02.Basic MDX Queries
10.Query Resolution 3.85 MB 0:02:43 ‎128kbps 1371.00 1024x768 ‎15 frames/second 02.Basic MDX Queries
11.Cell Properties 1.12 MB 0:00:43 ‎128kbps 1248.00 1024x768 ‎15 frames/second 02.Basic MDX Queries
12.Demo - Cell Properties 8.26 MB 0:04:07 ‎128kbps 2254.00 1024x768 ‎15 frames/second 02.Basic MDX Queries
13.Dimension Properties 1.48 MB 0:00:58 ‎128kbps 1364.00 1024x768 ‎15 frames/second 02.Basic MDX Queries
14.Demo - Dimension Properties 7.19 MB 0:03:27 ‎128kbps 375.00 1024x768 ‎15 frames/second 02.Basic MDX Queries
15.Summary 3.83 MB 0:02:41 ‎128kbps 155.00 1024x768 ‎15 frames/second 02.Basic MDX Queries
01.Introduction 1.55 MB 0:01:12 ‎128kbps 702.00 1024x768 ‎15 frames/second 03.Sets
02.Introduction to Set Functions 2.97 MB 0:02:03 ‎128kbps 1290.00 1024x768 ‎15 frames/second 03.Sets
03.Set Usage in A Query 1.48 MB 0:01:03 ‎128kbps 998.00 1024x768 ‎15 frames/second 03.Sets
04.Demo - Set Functions-Members and AllMembers 19.3 MB 0:10:49 ‎128kbps 2599.00 1024x768 ‎15 frames/second 03.Sets
05.Set Order 1.98 MB 0:01:25 ‎128kbps 1182.00 1024x768 ‎15 frames/second 03.Sets
06.Demo - Order Function 12.0 MB 0:07:06 ‎128kbps 2110.00 1024x768 ‎15 frames/second 03.Sets
07.Subsets 1.09 MB 0:00:41 ‎128kbps 1119.00 1024x768 ‎15 frames/second 03.Sets
08.Demo - Head and Tail Functions 6.63 MB 0:03:53 ‎128kbps 2187.00 1024x768 ‎15 frames/second 03.Sets
09.Sort and Create A Subset in One Step 1.75 MB 0:01:05 ‎128kbps 1518.00 1024x768 ‎15 frames/second 03.Sets
10.Demo - TopCount Function and Variations 12.0 MB 0:06:47 ‎128kbps 2303.00 1024x768 ‎15 frames/second 03.Sets
11.Filtered Set 1.28 MB 0:00:58 ‎128kbps 565.00 1024x768 ‎15 frames/second 03.Sets
12.Demo - Filter Function 7.33 MB 0:04:32 ‎128kbps 2321.00 1024x768 ‎15 frames/second 03.Sets
13.Multidimensional Set 1.26 MB 0:00:52 ‎128kbps 955.00 1024x768 ‎15 frames/second 03.Sets
14.Demo - CrossJoin function 6.12 MB 0:03:36 ‎128kbps 2310.00 1024x768 ‎15 frames/second 03.Sets
15.Polymorphic Operators 1.81 MB 0:01:09 ‎128kbps 1056.00 1024x768 ‎15 frames/second 03.Sets
16.Demo - (asterisk), +, and - Operators 5.16 MB 0:03:00 ‎128kbps 2195.00 1024x768 ‎15 frames/second 03.Sets
17.Set Creation Through Iteration 1.70 MB 0:01:11 ‎128kbps 1215.00 1024x768 ‎15 frames/second 03.Sets
18.Demo - Generate Function 5.03 MB 0:02:59 ‎128kbps 2070.00 1024x768 ‎15 frames/second 03.Sets
19.Tuple Elimination 1.47 MB 0:01:04 ‎128kbps 880.00 1024x768 ‎15 frames/second 03.Sets
20.Demo - Nonempty Function 6.94 MB 0:03:55 ‎128kbps 2199.00 1024x768 ‎15 frames/second 03.Sets
21.Tuple Extraction 1.34 MB 0:00:57 ‎128kbps 996.00 1024x768 ‎15 frames/second 03.Sets
22.Demo - Extract Function 7.48 MB 0:04:01 ‎128kbps 2606.00 1024x768 ‎15 frames/second 03.Sets
23.Asymmetrical Set 1.21 MB 0:00:47 ‎128kbps 1323.00 1024x768 ‎15 frames/second 03.Sets
24.Demo - Asymmetrical Set 3.94 MB 0:02:08 ‎128kbps 2075.00 1024x768 ‎15 frames/second 03.Sets
25.Demo - Summary 4.86 MB 0:03:33 ‎128kbps 128.00 1024x768 ‎15 frames/second 03.Sets
01.Introduction 1.02 MB 0:00:44 ‎128kbps 878.00 1024x768 ‎15 frames/second 04.Hierarchies in MDX
02.Hierarchy Navigation 2.36 MB 0:01:39 ‎128kbps 117.00 1024x768 ‎15 frames/second 04.Hierarchies in MDX
03.Upward Navigation 4.51 MB 0:02:49 ‎128kbps 198.00 1024x768 ‎15 frames/second 04.Hierarchies in MDX
04.Demo - Parent, Ancestor, and Ascendants Functions 6.76 MB 0:03:53 ‎128kbps 1911.00 1024x768 ‎15 frames/second 04.Hierarchies in MDX
05.Downward Navigation 3.93 MB 0:02:05 ‎128kbps 435.00 1024x768 ‎15 frames/second 04.Hierarchies in MDX
06.Demo - Children, Descendants, FirstChild, LastChild Functions 9.11 MB 0:05:15 ‎128kbps 2172.00 1024x768 ‎15 frames/second 04.Hierarchies in MDX
07.Horizontal Navigation 8.99 MB 0:05:07 ‎128kbps 217.00 1024x768 ‎15 frames/second 04.Hierarchies in MDX
08.Demo - Horizontal Navigation Functions 4.96 MB 0:03:00 ‎128kbps 1950.00 1024x768 ‎15 frames/second 04.Hierarchies in MDX
09.Summary 2.15 MB 0:01:35 ‎128kbps 843.00 1024x768 ‎15 frames/second 04.Hierarchies in MDX
01.Introduction 2.41 MB 0:01:56 ‎128kbps 824.00 1024x768 ‎15 frames/second 05.Calculations
02.Introduction to Calculations 2.98 MB 0:02:19 ‎128kbps 884.00 1024x768 ‎15 frames/second 05.Calculations
03.Tuple-Based Calculations 6.57 MB 0:04:07 ‎128kbps 283.00 1024x768 ‎15 frames/second 05.Calculations
04.Demo - Tuple-Based Calculations 13.0 MB 0:07:16 ‎128kbps 2224.00 1024x768 ‎15 frames/second 05.Calculations
05.Set-Based Calculations 3.65 MB 0:02:16 ‎128kbps 130.00 1024x768 ‎15 frames/second 05.Calculations
06.Demo - Set-Based Calculations 22.2 MB 0:12:01 ‎128kbps 2701.00 1024x768 ‎15 frames/second 05.Calculations
07.Time-Series Calculations 3.22 MB 0:02:15 ‎128kbps 202.00 1024x768 ‎15 frames/second 05.Calculations
08.Demo - Time-Series Calculations 14.4 MB 0:07:50 ‎128kbps 371.00 1024x768 ‎15 frames/second 05.Calculations
09.Miscellaneous Functions 1.58 MB 0:01:13 ‎128kbps 79.00 1024x768 ‎15 frames/second 05.Calculations
10.Demo - Miscellaneous Functions 8.67 MB 0:03:44 ‎128kbps 359.00 1024x768 ‎15 frames/second 05.Calculations
11.Summary 3.41 MB 0:02:38 ‎128kbps 151.00 1024x768 ‎15 frames/second 05.Calculations
[/spoiler]
Файлы примеров: присутствуют
Формат видео: WMV
Видео: wmv3, 1024x768, 15 fps, 79~2701kbps
Аудио: wma2, 128kbps, Stereo, 44.1kHz
[spoiler="Скриншоты"]

[/spoiler]
Доп. информация: Exercise include slides, code files and Transcripts