{"id":13340,"date":"2026-08-10T10:58:00","date_gmt":"2026-08-10T10:58:00","guid":{"rendered":"https:\/\/nokobox.com\/index.php\/item\/udemy-introduction-to-tuning-sql-for-higher-performance-2025-5\/"},"modified":"2026-08-10T10:58:00","modified_gmt":"2026-08-10T10:58:00","slug":"udemy-introduction-to-tuning-sql-for-higher-performance-2025-5","status":"publish","type":"digital_item","link":"https:\/\/nokobox.com\/index.php\/item\/udemy-introduction-to-tuning-sql-for-higher-performance-2025-5\/","title":{"rendered":"Udemy \u2013 Introduction to Tuning SQL for Higher Performance 2025-5"},"content":{"rendered":"<div class=\"w-post-elm post_content\">\n<h2 dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Description<\/span><\/h2>\n<p dir=\"ltr\" style=\"text-align: left\" data-path-to-node=\"12\"><span dir=\"auto\" style=\"vertical-align: inherit\">Introduction to Tuning SQL for Higher Performance. This course teaches the principles of optimizing and tuning SQL queries to increase execution speed and improve database performance. This course is designed for those who are familiar with writing SQL but want to make their queries more efficient. This course explains the principles of SQL performance and optimization techniques, building on participants\u2019 existing knowledge, and addresses SQL query planning and performance evaluation. Understanding the database planning is essential for analyzing and tuning queries; therefore, this course teaches how query plan builders work, including how to implement basic operations such as retrieving data, joining tables, and filtering results using various plan nodes. Participants learn how to read execution plans, compare cost calculations, and evaluate alternative implementations for their queries. Through hands-on exercises, various query patterns are analyzed and the impact of their rewriting on performance is observed. Advanced optimization techniques include indexing strategies such as covering, full-text, and phrase indexes, examining join algorithms with real-world scenarios, optimizing related subqueries and complex window functions, as well as using materialized views and common table expressions for query performance. Additionally, pattern matching techniques including regular expressions and full-text search are taught, and the performance implications of GiST, GIN, and SP-GiST index types are covered. For enterprise-level scenarios, implementing partitioning strategies for large tables, time-series optimization techniques for IoT data, and full-text search in large-scale applications are explored. Tools and techniques for monitoring and tuning ongoing performance are also provided, such as advanced use of pg_stat views, tuning autovacuum, and maintaining statistics on tables. During the course, work will be done with sales database datasets and an IoT vehicle sensor system with millions of daily records, and practical exercises will enable the application of theoretical knowledge to practical scenarios. By the end, participants will have the skills to analyze complex queries and the knowledge to make informed decisions about database performance trade-offs in production systems.<\/span><\/p>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">What you will learn<\/span><\/h3>\n<ul dir=\"ltr\" style=\"text-align: left\">\n<li data-path-to-node=\"15,0,0\"><span dir=\"auto\" style=\"vertical-align: inherit\">Generate and understand query execution plans.<\/span><\/li>\n<li data-path-to-node=\"15,1,0\"><span dir=\"auto\" style=\"vertical-align: inherit\">Define indexes and partitioning strategies to improve query performance.<\/span><\/li>\n<li data-path-to-node=\"15,2,0\"><span dir=\"auto\" style=\"vertical-align: inherit\">Choose optimal methods for implementing business logic using joins, subqueries, and common table expressions (CTEs).<\/span><\/li>\n<li data-path-to-node=\"15,3,0\"><span dir=\"auto\" style=\"vertical-align: inherit\">Monitor database statistics to improve query performance.<\/span><\/li>\n<\/ul>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">This course is suitable for people who:<\/span><\/h3>\n<ul dir=\"ltr\" style=\"text-align: left\">\n<li data-path-to-node=\"18,0,0\"><span dir=\"auto\" style=\"vertical-align: inherit\">Data analysts.<\/span><\/li>\n<li data-path-to-node=\"18,1,0\"><span dir=\"auto\" style=\"vertical-align: inherit\">Reporters.<\/span><\/li>\n<li data-path-to-node=\"18,2,0\"><span dir=\"auto\" style=\"vertical-align: inherit\">Developers who work with relational databases.<\/span><\/li>\n<li data-path-to-node=\"18,3,0\"><span dir=\"auto\" style=\"vertical-align: inherit\">Database administrators.<\/span><\/li>\n<li data-path-to-node=\"18,4,0\"><span dir=\"auto\" style=\"vertical-align: inherit\">Data engineers.<\/span><\/li>\n<li data-path-to-node=\"18,5,0\"><span dir=\"auto\" style=\"vertical-align: inherit\">ETL developers.<\/span><\/li>\n<li data-path-to-node=\"18,6,0\"><span dir=\"auto\" style=\"vertical-align: inherit\">Data modelers.<\/span><\/li>\n<li data-path-to-node=\"18,7,0\"><span dir=\"auto\" style=\"vertical-align: inherit\">Data architects.<\/span><\/li>\n<li data-path-to-node=\"18,8,0\"><span dir=\"auto\" style=\"vertical-align: inherit\">Business analysts.<\/span><\/li>\n<li data-path-to-node=\"18,9,0\"><span dir=\"auto\" style=\"vertical-align: inherit\">SQL users.<\/span><\/li>\n<li data-path-to-node=\"18,10,0\"><span dir=\"auto\" style=\"vertical-align: inherit\">Database users.<\/span><\/li>\n<\/ul>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Course details<\/span><\/h3>\n<ul dir=\"ltr\" style=\"text-align: left\">\n<li data-path-to-node=\"21,0,0\"><span dir=\"auto\" style=\"vertical-align: inherit\">Publisher: <\/span><a href=\"https:\/\/href.li\/?https:\/\/www.udemy.com\/course\/hands-on-high-performance-sql\/?couponCode=KEEPLEARNING\" target=\"_blank\" rel=\"noopener\"><span dir=\"auto\" style=\"vertical-align: inherit\">Udemy<\/span><\/a><\/li>\n<li data-path-to-node=\"21,1,0\"><span dir=\"auto\" style=\"vertical-align: inherit\">Instructor: <\/span><a href=\"https:\/\/downloadlynet.ir\/tag\/dan-sullivan\/\"><span dir=\"auto\" style=\"vertical-align: inherit\">Dan Sullivan<\/span><\/a><\/li>\n<li data-path-to-node=\"21,2,0\"><span dir=\"auto\" style=\"vertical-align: inherit\">Training level: Beginner to advanced<\/span><\/li>\n<li data-path-to-node=\"21,3,0\"><span dir=\"auto\" style=\"vertical-align: inherit\">Training duration: 4 hours and 35 minutes<\/span><\/li>\n<li data-path-to-node=\"21,4,0\"><span dir=\"auto\" style=\"vertical-align: inherit\">Number of lessons: 60<\/span><\/li>\n<\/ul>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Course headings<\/span><\/h3>\n<h3 dir=\"ltr\" style=\"text-align: left\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1020276 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2025\/11\/Introduction-to-Tuning-SQL-for-Higher-Performance-1.png\" alt=\"Introduction to Tuning SQL for Higher Performance\" width=\"885\" height=\"747\"><\/h3>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Prerequisites for the Introduction to Tuning SQL for Higher Performance course<\/span><\/h3>\n<div class=\"ud-block-list-item ud-block-list-item-small ud-block-list-item-tight ud-block-list-item-neutral ud-text-sm\" dir=\"ltr\" style=\"text-align: left\">\n<ul>\n<li class=\"ud-block-list-item-content\" dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Some experience with SQL SELECT statements<\/span><\/li>\n<\/ul>\n<\/div>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Course images<\/span><\/h3>\n<h3 dir=\"ltr\" style=\"text-align: left\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1020277 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2025\/11\/Introduction-to-Tuning-SQL-for-Higher-Performance.png\" alt=\"Introduction to Tuning SQL for Higher Performance\" width=\"795\" height=\"366\"><\/h3>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" 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-185080-1\"><video class=\"wp-video-shortcode\" id=\"video-185080-1_html5\" width=\"640\" height=\"360\" preload=\"metadata\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Introduction_to_Tuning_SQL_for_Higher_Performance_Downloadly.ir.mp4?_=1\" style=\"width: 640px; height: 360px;\"><source type=\"video\/mp4\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Introduction_to_Tuning_SQL_for_Higher_Performance_Downloadly.ir.mp4?_=1\"><a href=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Introduction_to_Tuning_SQL_for_Higher_Performance_Downloadly.ir.mp4?nocache=1786175371179\">https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Introduction_to_Tuning_SQL_for_Higher_Performance_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 dir=\"auto\" style=\"vertical-align: inherit\">Installation Guide<\/span><\/h3>\n<p><span dir=\"auto\" style=\"vertical-align: inherit\">After Extract, view with your favorite player.<\/span><\/p>\n<p><span dir=\"auto\" style=\"vertical-align: inherit\">Subtitles: English<\/span><\/p>\n<p><span dir=\"auto\" style=\"vertical-align: inherit\">Quality: 1080p<\/span><\/p>\n<\/div>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Download link<\/span><\/h3>\n<h4 dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Downloadly<\/span><\/h4>\n<p dir=\"ltr\" style=\"text-align: left\"><a href=\"https:\/\/dl4.downloadly.ir\/Files\/Elearning\/Udemy_Introduction_to_Tuning_SQL_for_Higher_Performance_2025-5.part1_Downloadly.ir.rar?nocache=1786175370\"><span dir=\"auto\" style=\"vertical-align: inherit\">Download Part 1 \u2013 1 GB<\/span><\/a><\/p>\n<p dir=\"ltr\" style=\"text-align: left\"><a href=\"https:\/\/dl4.downloadly.ir\/Files\/Elearning\/Udemy_Introduction_to_Tuning_SQL_for_Higher_Performance_2025-5.part2_Downloadly.ir.rar?nocache=1786175370\"><span dir=\"auto\" style=\"vertical-align: inherit\">Download Part 2 \u2013 141 MB<\/span><\/a><\/p>\n<h4 dir=\"ltr\">Rapidgator link<\/h4>\n<p><a href=\"https:\/\/rapidgator.net\/file\/1b9e18adb32c2c2323f5d06a7108def0\/Udemy_Introduction_to_Tuning_SQL_for_Higher_Performance_2025-5.part1_Downloadly.ir.rar.html\" target=\"_blank\" rel=\"noopener\">Download Part 1 \u2013 1 GB<\/a><\/p>\n<p><a href=\"https:\/\/rapidgator.net\/file\/2c46d24b82ddef55b0ee0b0b53d6d761\/Udemy_Introduction_to_Tuning_SQL_for_Higher_Performance_2025-5.part2_Downloadly.ir.rar.html\" target=\"_blank\" rel=\"noopener\">Download Part 2 \u2013 141 MB<\/a><\/p>\n<p dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">File(s) password: www.downloadly.ir<\/span><\/p>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">File size<\/span><\/h3>\n<p dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">1.1 GB<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Description Introduction to Tuning SQL for Higher Performance. This course teaches the principles of optimizing and tuning SQL queries to increase execution spe<\/p>\n","protected":false},"author":1,"template":"","dgi_category":[10458],"dgi_tag":[109214,28295,109215,109216,109217,109218],"class_list":["post-13340","digital_item","type-digital_item","status-publish","has-post-thumbnail","hentry","dgi_category-video-tutorials","dgi_tag-course-introduction-to-tuning-sql-for-higher-performance","dgi_tag-dan-sullivan","dgi_tag-download-course-introduction-to-tuning-sql-for-higher-performance","dgi_tag-download-introduction-to-tuning-sql-for-higher-performance","dgi_tag-free-download-introduction-to-tuning-sql-for-higher-performance","dgi_tag-free-introduction-to-tuning-sql-for-higher-performance"],"_links":{"self":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item\/13340","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\/13340\/revisions"}],"wp:attachment":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/media?parent=13340"}],"wp:term":[{"taxonomy":"dgi_category","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_category?post=13340"},{"taxonomy":"dgi_tag","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_tag?post=13340"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}