Advanced Querying Techniques in SQL Server [2023, ENG] torrent

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

Advanced Querying Techniques in SQL Server

Год выпуска: 2023
Производитель: Pluralsight
Сайт производителя: Pluralsight.com
Автор: Gerald Britton
Продолжительность: 1h 13m
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Субтитры: Английские
Описание: SQL Server’s Transact-SQL language has the ability to transform relational data in a wide variety of ways. In this course, Advanced Querying Techniques in SQL Server, you’ll gain the ability to solve four important problems using SQL Server. First, you’ll learn how to navigate hierarchical data using recursive common table expressions (CTEs). Second, you’ll explore how to rotate tabular data while aggregating desired metrics using PIVOT. Next, you’ll discover how to transform cross tabulated data into relational data using UNPIVOT. Then, you’ll see how to use semantic data modeling and Entry, Attribute, and Value data structures when a purely relational model limits flexibility and attributes can change frequently. Finally, you'll learn how to sample SQL Server data for analysis and testing. When you’re finished with this course, you’ll have the skills and knowledge of advanced SQL Server querying techniques needed to quickly address the problems presented here.
[spoiler="Содержание"]
Course Overview 1m 27s
Navigating Data Hierarchies Using Recursive Queries 22m 6s
Aggregating Data Using the PIVOT and UNPIVOT Clauses 20m 1s
Storing Data as Entities, Attributes, and Values (EAV) 20m 35s
Sampling Data in SQL Server 9m 41s
[/spoiler]
Файлы примеров: присутствуют
Формат видео: MP4
Видео: MPEG4 Video (H264) 1281x720 30fps 293kbps [V: English [eng] (h264 high L4.0, yuv420p, 1281x720, 293 kb/s)]
Аудио: AAC 44100Hz stereo 95kbps [A: SoundHandler [eng] (aac lc, 44100 Hz, stereo, 95 kb/s)]
[spoiler="Скриншоты"]

[/spoiler]
Доп. информация: Level Advanced