Working with Hierarchies in SQL Server [2023, ENG] torrent

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

Working with Hierarchies in SQL Server

Год выпуска: 2023
Производитель: Pluralsight
Сайт производителя: Pluralsight.com
Автор: Pinal Dave
Продолжительность: 0h 49m
Тип раздаваемого материала: Видеоклипы
Язык: Английский
Субтитры: Английские
Описание: Understanding the HierarchyID data type in SQL Server is crucial for managing hierarchical or nested data structures, enhancing the efficiency and performance of database queries. In this course, Working with Hierarchies in SQL Server, you'll gain the ability to work with hierarchical data in SQL Server effectively. First, you'll understand hierarchies' importance, structure, and representation, focusing on the hierarchyid data type. By creating hierarchies, querying them, and comparing hierarchyid with other hierarchy models, you'll gain a robust foundation. Next, you'll explore node properties like depth, breadth, and position and learn to find descendants, modify nodes, and calculate depth and breadth through practical exercises. Finally, you'll learn to improve performance with indexes, enforce integrity with triggers, and discuss best practices in SQL Server hierarchies. By the end of this course, you'll have both theoretical understanding and hands-on experience with hierarchical data in SQL Server. You'll be prepared to handle complex data relationships efficiently, applying these skills in real-world scenarios.
[spoiler="Содержание"]
Course Overview 1m 28s
Overview of Hierarchies in SQL Server 19m 10s
Working with Nodes in a Hierarchy 17m 40s
Optimizing Performance and Maintaining Integrity 10m 59s
[/spoiler]
Файлы примеров: присутствуют
Формат видео: MP4
Видео: MPEG4 Video (H264) 1024x768 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 Beginner