{"id":10929,"date":"2026-08-10T10:25:30","date_gmt":"2026-08-10T10:25:30","guid":{"rendered":"https:\/\/nokobox.com\/index.php\/item\/udemy-t-sql-execution-plans-indexes-transactions-in-memory-oltp-2026-1\/"},"modified":"2026-08-10T10:25:30","modified_gmt":"2026-08-10T10:25:30","slug":"udemy-t-sql-execution-plans-indexes-transactions-in-memory-oltp-2026-1","status":"publish","type":"digital_item","link":"https:\/\/nokobox.com\/index.php\/item\/udemy-t-sql-execution-plans-indexes-transactions-in-memory-oltp-2026-1\/","title":{"rendered":"Udemy \u2013 T-SQL Execution Plans, Indexes, Transactions, In-Memory OLTP 2026-1"},"content":{"rendered":"<div class=\"w-post-elm post_content\">\n<p>&nbsp;<\/p>\n<h2 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Description<\/span><\/h2>\n<p dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Understanding Execution Plans and Indexes in SQL Server course. This course helps participants improve the performance of Transact-SQL queries by analyzing Execution Plans and Indexes in SQL Server. This course is not designed for beginners and requires a basic knowledge of T-SQL commands. Key topics include index concepts such as Clustered and Non-Clustered Index, data structures such as Page and Heap, and index management techniques such as Rebuild and Reorganize. It also covers various Execution Plan operators such as Table Scan, Index Seek, and various Joins. Participants learn how to analyze Actual and Estimated Execution Plans, identify common problems such as Parameter Sniffing, and use optimization techniques in SQL Server 2022. This course teaches the skills needed to tune queries and improve database performance by providing practical examples and application patterns.<\/span><\/p>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">What you will learn<\/span><\/h3>\n<ul dir=\"ltr\" style=\"text-align: left\">\n<li><span style=\"vertical-align: inherit\">They gain deeper knowledge about Clustered, Non-Clustered indexes, and Fragmentation concepts.<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">They learn common execution plans.<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">They learn to find patterns that may degrade query performance.<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">This course helps participants fine-tune pre-written queries or write T-SQL in a better way.<\/span><\/li>\n<\/ul>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">This course is suitable for people who:<\/span><\/h3>\n<ul dir=\"ltr\" style=\"text-align: left\">\n<li><span style=\"vertical-align: inherit\">Participants who have prior knowledge of T-SQL commands.<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">This course is suitable for SQL Server developers, SQL Server DBAs, .NET developers who write T-SQL statements, data analysts, etc.<\/span><\/li>\n<\/ul>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Course Description: Understanding Execution Plans and Indexes in SQL Server<\/span><\/h3>\n<ul>\n<li>Publisher : <a href=\"https:\/\/href.li\/?https:\/\/www.udemy.com\/course\/understanding-execution-plans-indexes-sql-server\" target=\"_blank\" rel=\"noopener\">Udemy<\/a><\/li>\n<li>Teacher : <a href=\"https:\/\/downloadlynet.ir\/tag\/vikas-munjal\">Vikas Munjal<\/a><\/li>\n<li>Language: English<\/li>\n<li>Level : All Levels<\/li>\n<li>Lectures : 79<\/li>\n<li>Duration : 9 hours and 0 minutes<\/li>\n<\/ul>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Course syllabus in 2024\/12<\/span><\/h3>\n<h3><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1032549\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2026\/02\/T-SQL-Execution-Plans-Indexes-Transactions-In-Memory-OLTP.c.jpeg\" alt=\"T-SQL Execution Plans, Indexes, Transactions, In-Memory OLTP\" width=\"825\" height=\"587\"><\/h3>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Prerequisites for the Understanding Execution Plans and Indexes in SQL Server course<\/span><\/h3>\n<ul dir=\"ltr\" style=\"text-align: left\">\n<li dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">RDBMS concepts should be known &amp; should have good hands-on on T-SQL Commands<\/span><\/li>\n<li dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">SQL Server 2022 (lower version can work also) and SQL Server Management Studio should be installed already<\/span><\/li>\n<\/ul>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Course images<\/span><\/h3>\n<h3><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-1032550\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2026\/02\/T-SQL-Execution-Plans-Indexes-Transactions-In-Memory-OLTP.d.jpeg\" alt=\"T-SQL Execution Plans, Indexes, Transactions, In-Memory OLTP\" width=\"825\" height=\"418\"><\/h3>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Sample course video<\/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-168779-1\"><video class=\"wp-video-shortcode\" id=\"video-168779-1_html5\" width=\"640\" height=\"360\" preload=\"metadata\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Understanding_Execution_Plans_and_Indexes_in_SQL_Server_Downloadly.ir.mp4?_=1\" style=\"width: 640px; height: 360px;\"><source type=\"video\/mp4\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Understanding_Execution_Plans_and_Indexes_in_SQL_Server_Downloadly.ir.mp4?_=1\"><a href=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Understanding_Execution_Plans_and_Indexes_in_SQL_Server_Downloadly.ir.mp4?nocache=1786139466308\">https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Understanding_Execution_Plans_and_Indexes_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\">Subtitles: Englsih<\/span><\/p>\n<p><span style=\"vertical-align: inherit\">Quality: 1080p<\/span><\/p>\n<\/div>\n<p>The 2026\/1 version has increased the number of lessons by 30 and the duration increased by 3 hours 59 minutes compared to 2023\/12.<\/p>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Download link<\/span><\/h3>\n<p><a href=\"https:\/\/dl2.downloadly.ir\/Files\/Elearning\/Udemy_T-SQL_Execution_Plans_Indexes_Transactions_In-Memory_OLTP_1080_2026-1_Downloadly.ir.part1.rar?nocache=1786139465\" target=\"_blank\" rel=\"noopener\">Download Part 1 \u2013 1 GB<\/a><\/p>\n<p><a href=\"https:\/\/dl2.downloadly.ir\/Files\/Elearning\/Udemy_T-SQL_Execution_Plans_Indexes_Transactions_In-Memory_OLTP_1080_2026-1_Downloadly.ir.part2.rar?nocache=1786139465\" target=\"_blank\" rel=\"noopener\">Download Part 2 \u2013 1 GB<\/a><\/p>\n<p><a href=\"https:\/\/dl2.downloadly.ir\/Files\/Elearning\/Udemy_T-SQL_Execution_Plans_Indexes_Transactions_In-Memory_OLTP_1080_2026-1_Downloadly.ir.part3.rar?nocache=1786139465\" target=\"_blank\" rel=\"noopener\">Download Part 3 \u2013 786 MB<\/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\">File size<\/span><\/h3>\n<p>2.76 GB<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; Description Understanding Execution Plans and Indexes in SQL Server course. This course helps participants improve the performance of Transact-SQL querie<\/p>\n","protected":false},"author":1,"template":"","dgi_category":[10458],"dgi_tag":[91713,91714,91715,91716,91717,91696],"class_list":["post-10929","digital_item","type-digital_item","status-publish","has-post-thumbnail","hentry","dgi_category-video-tutorials","dgi_tag-course-understanding-execution-plans-and-indexes-in-sql-server","dgi_tag-download-course-understanding-execution-plans-and-indexes-in-sql-server","dgi_tag-download-understanding-execution-plans-and-indexes-in-sql-server","dgi_tag-free-download-understanding-execution-plans-and-indexes-in-sql-server","dgi_tag-free-understanding-execution-plans-and-indexes-in-sql-server","dgi_tag-vikas-munjal"],"_links":{"self":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item\/10929","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\/10929\/revisions"}],"wp:attachment":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/media?parent=10929"}],"wp:term":[{"taxonomy":"dgi_category","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_category?post=10929"},{"taxonomy":"dgi_tag","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_tag?post=10929"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}