{"id":4005,"date":"2026-08-10T09:09:28","date_gmt":"2026-08-10T09:09:28","guid":{"rendered":"https:\/\/nokobox.com\/index.php\/item\/pluralsight-working-with-hierarchies-in-sql-server-2023-8\/"},"modified":"2026-08-10T09:09:28","modified_gmt":"2026-08-10T09:09:28","slug":"pluralsight-working-with-hierarchies-in-sql-server-2023-8","status":"publish","type":"digital_item","link":"https:\/\/nokobox.com\/index.php\/item\/pluralsight-working-with-hierarchies-in-sql-server-2023-8\/","title":{"rendered":"Pluralsight \u2013 Working with Hierarchies in SQL Server 2023-8"},"content":{"rendered":"<div class=\"w-post-elm post_content\">\n<h2 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Description<\/span><\/h2>\n<div class=\"markdown markdown-main-panel\" dir=\"ltr\" style=\"text-align: left\">\n<p data-sourcepos=\"5:1-5:210\"><span style=\"vertical-align: inherit\">Working with Hierarchies in SQL Server course. Understanding the HierarchyID data type in SQL Server is important for managing hierarchical or nested data structures, and improving the efficiency and performance of database queries. This course will help you gain an in-depth understanding of working with hierarchical data in SQL Server. You will learn the key concepts of hierarchy, the HierarchyID data type, and how to use it to store and manage hierarchical data. You will also learn how to query and manipulate hierarchical data using Transact-SQL queries. At the end of this course, you will have the theoretical understanding and practical experience of working with hierarchical data in SQL Server. You will be prepared to efficiently manage complex data relationships and apply these skills in real-world scenarios.<\/span><\/p>\n<h3 data-sourcepos=\"19:1-19:25\"><strong><span style=\"vertical-align: inherit\">What you will learn:<\/span><\/strong><\/h3>\n<ul>\n<li data-sourcepos=\"7:1-7:68\"><span style=\"vertical-align: inherit\">The importance, structure and representation of hierarchies with a focus on the HierarchyID data type<\/span><\/li>\n<li data-sourcepos=\"8:1-8:67\"><span style=\"vertical-align: inherit\">Create, query and compare hierarchies with other hierarchical models<\/span><\/li>\n<li data-sourcepos=\"9:1-9:48\"><span style=\"vertical-align: inherit\">Explore node properties such as depth, extent and position<\/span><\/li>\n<li data-sourcepos=\"10:1-10:49\"><span style=\"vertical-align: inherit\">Finding children, modifying nodes and calculating depth and breadth<\/span><\/li>\n<li data-sourcepos=\"11:1-12:0\"><span style=\"vertical-align: inherit\">Improving performance with indexes, implementing integration with triggers, and discussing best practices in SQL Server hierarchies<\/span><\/li>\n<\/ul>\n<h3 data-sourcepos=\"26:1-26:31\"><strong><span style=\"vertical-align: inherit\">This course is suitable for people who:<\/span><\/strong><\/h3>\n<ul>\n<li data-sourcepos=\"15:1-15:59\"><span style=\"vertical-align: inherit\">Want to work with hierarchical data in SQL Server<\/span><\/li>\n<li data-sourcepos=\"16:1-16:80\"><span style=\"vertical-align: inherit\">Looking to improve their skills in querying and managing hierarchical data<\/span><\/li>\n<li data-sourcepos=\"17:1-17:60\"><span style=\"vertical-align: inherit\">Need to learn how to use the HierarchyID data type<\/span><\/li>\n<li data-sourcepos=\"18:1-19:0\"><span style=\"vertical-align: inherit\">They want to improve the performance of queries related to hierarchical data<\/span><\/li>\n<\/ul>\n<\/div>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Course details<\/span><\/h3>\n<ul dir=\"ltr\" style=\"text-align: left\">\n<li><span style=\"vertical-align: inherit\">Publisher: <\/span><a href=\"https:\/\/href.li\/?https:\/\/www.pluralsight.com\/courses\/sql-server-hierarchies-working\" target=\"_blank\"><span style=\"vertical-align: inherit\">Pluralsight<\/span><\/a><\/li>\n<li><span style=\"vertical-align: inherit\">Instructor: <\/span><a href=\"https:\/\/downloadlynet.ir\/tag\/pinal-dave\/\"><span style=\"vertical-align: inherit\">Pinal Dave<\/span><\/a><\/li>\n<li><span style=\"vertical-align: inherit\">Training level: beginner<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Training duration: 49 minutes<\/span><\/li>\n<\/ul>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Course headings<\/span><\/h3>\n<p dir=\"ltr\" style=\"text-align: left\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-909274 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2024\/06\/Working-with-Hierarchies-in-SQL-Server.jpg\" alt=\"Working with hierarchies in SQL Server\" width=\"1043\" height=\"467\"><\/p>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Images of the Working with Hierarchies in SQL Server course<\/span><\/h3>\n<p dir=\"ltr\" style=\"text-align: left\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-909273 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2024\/06\/Working-with-Hierarchies-in-SQL-Server-1.jpg\" alt=\"Working with hierarchies in SQL Server\" width=\"775\" height=\"103\"><\/p>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Sample video of the course<\/span><\/h3>\n<div style=\"width: 640px;\" class=\"wp-video\"><span class=\"mejs-offscreen\">Video Player<\/span><\/p>\n<div id=\"mep_0\" class=\"mejs-container mejs-container-keyboard-inactive wp-video-shortcode mejs-video\" tabindex=\"0\" role=\"application\" aria-label=\"Video Player\" style=\"width: 640px; height: 360px; min-width: 217px;\">\n<div class=\"mejs-inner\">\n<div class=\"mejs-mediaelement\"><mediaelementwrapper id=\"video-129963-1\"><video class=\"wp-video-shortcode\" id=\"video-129963-1_html5\" width=\"640\" height=\"360\" preload=\"metadata\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Working_with_Hierarchies_in_SQL_Server_Downloadly.ir.mp4?_=1\" style=\"width: 640px; height: 360px;\"><source type=\"video\/mp4\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Working_with_Hierarchies_in_SQL_Server_Downloadly.ir.mp4?_=1\"><a href=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Working_with_Hierarchies_in_SQL_Server_Downloadly.ir.mp4?nocache=1786100065263\">https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Working_with_Hierarchies_in_SQL_Server_Downloadly.ir.mp4<\/a><\/video><\/mediaelementwrapper><\/div>\n<div class=\"mejs-layers\">\n<div class=\"mejs-poster mejs-layer\" style=\"display: none; width: 100%; height: 100%;\"><\/div>\n<div class=\"mejs-overlay mejs-layer\" style=\"display: none; width: 100%; height: 100%;\">\n<div class=\"mejs-overlay-loading\"><span class=\"mejs-overlay-loading-bg-img\"><\/span><\/div>\n<\/div>\n<div class=\"mejs-overlay mejs-layer\" style=\"display: none; width: 100%; height: 100%;\">\n<div class=\"mejs-overlay-error\"><\/div>\n<\/div>\n<div class=\"mejs-overlay mejs-layer mejs-overlay-play\" style=\"width: 100%; height: 100%;\">\n<div class=\"mejs-overlay-button\" role=\"button\" tabindex=\"0\" aria-label=\"Play\" aria-pressed=\"false\"><\/div>\n<\/div>\n<\/div>\n<div class=\"mejs-controls\">\n<div class=\"mejs-button mejs-playpause-button mejs-play\"><button type=\"button\" aria-controls=\"mep_0\" title=\"Play\" aria-label=\"Play\" tabindex=\"0\"><\/button><\/div>\n<div class=\"mejs-time mejs-currenttime-container\" role=\"timer\" aria-live=\"off\"><span class=\"mejs-currenttime\">00:00<\/span><\/div>\n<div class=\"mejs-time-rail\"><span class=\"mejs-time-total mejs-time-slider\" role=\"slider\" tabindex=\"0\" aria-label=\"Time Slider\" aria-valuemin=\"0\" aria-valuemax=\"0\" aria-valuenow=\"0\" aria-valuetext=\"00:00\"><span class=\"mejs-time-buffering\" style=\"display: none;\"><\/span><span class=\"mejs-time-loaded\"><\/span><span class=\"mejs-time-current\"><\/span><span class=\"mejs-time-hovered no-hover\"><\/span><span class=\"mejs-time-handle\"><span class=\"mejs-time-handle-content\"><\/span><\/span><span class=\"mejs-time-float\"><span class=\"mejs-time-float-current\">00:00<\/span><span class=\"mejs-time-float-corner\"><\/span><\/span><\/span><\/div>\n<div class=\"mejs-time mejs-duration-container\"><span class=\"mejs-duration\">00:00<\/span><\/div>\n<div class=\"mejs-button mejs-volume-button mejs-mute\"><button type=\"button\" aria-controls=\"mep_0\" title=\"Mute\" aria-label=\"Mute\" tabindex=\"0\"><\/button><a href=\"javascript:void(0);\" class=\"mejs-volume-slider\" aria-label=\"Volume Slider\" aria-valuemin=\"0\" aria-valuemax=\"100\" role=\"slider\" aria-orientation=\"vertical\"><span class=\"mejs-offscreen\">Use Up\/Down Arrow keys to increase or decrease volume.<\/span><\/p>\n<div class=\"mejs-volume-total\">\n<div class=\"mejs-volume-current\" style=\"bottom: 0px; height: 100%;\"><\/div>\n<div class=\"mejs-volume-handle\" style=\"bottom: 100%; margin-bottom: -3px;\"><\/div>\n<\/div>\n<p><\/a><\/div>\n<div class=\"mejs-button mejs-fullscreen-button\"><button type=\"button\" aria-controls=\"mep_0\" title=\"Fullscreen\" aria-label=\"Fullscreen\" tabindex=\"0\"><\/button><\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<div dir=\"ltr\" style=\"text-align: left\">\n<h3><span style=\"vertical-align: inherit\">Installation guide<\/span><\/h3>\n<p><span style=\"vertical-align: inherit\">After Extract, view with your favorite Player.<\/span><\/p>\n<p><span style=\"vertical-align: inherit\">English subtitle<\/span><\/p>\n<p><span style=\"vertical-align: inherit\">Quality: 720p<\/span><\/p>\n<\/div>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">download link<\/span><\/h3>\n<p dir=\"ltr\" style=\"text-align: left\"><a href=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Pluralsight_Working_with_Hierarchies_in_SQL_Server_2023-8_Downloadly.ir.rar?nocache=1786100063\"><span style=\"vertical-align: inherit\">Download file \u2013 120 MB<\/span><\/a><\/p>\n<p dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">File(s) password: www.downloadly.ir<\/span><\/p>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Size<\/span><\/h3>\n<p dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">120 MB<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Description Working with Hierarchies in SQL Server course. Understanding the HierarchyID data type in SQL Server is important for managing hierarchical or neste<\/p>\n","protected":false},"author":1,"template":"","dgi_category":[10458],"dgi_tag":[44070,44071,44072,44073,44074,21300],"class_list":["post-4005","digital_item","type-digital_item","status-publish","has-post-thumbnail","hentry","dgi_category-video-tutorials","dgi_tag-course-working-with-hierarchies-in-sql-server","dgi_tag-download-course-working-with-hierarchies-in-sql-server","dgi_tag-download-working-with-hierarchies-in-sql-server","dgi_tag-free-download-working-with-hierarchies-in-sql-server","dgi_tag-free-working-with-hierarchies-in-sql-server","dgi_tag-pinal-dave"],"_links":{"self":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item\/4005","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item"}],"about":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/types\/digital_item"}],"author":[{"embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"version-history":[{"count":0,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item\/4005\/revisions"}],"wp:attachment":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/media?parent=4005"}],"wp:term":[{"taxonomy":"dgi_category","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_category?post=4005"},{"taxonomy":"dgi_tag","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_tag?post=4005"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}