{"id":4142,"date":"2026-08-10T09:10:42","date_gmt":"2026-08-10T09:10:42","guid":{"rendered":"https:\/\/nokobox.com\/index.php\/item\/linkedin-advanced-sql-for-query-tuning-and-performance-optimization-2023-10\/"},"modified":"2026-08-10T09:10:42","modified_gmt":"2026-08-10T09:10:42","slug":"linkedin-advanced-sql-for-query-tuning-and-performance-optimization-2023-10","status":"publish","type":"digital_item","link":"https:\/\/nokobox.com\/index.php\/item\/linkedin-advanced-sql-for-query-tuning-and-performance-optimization-2023-10\/","title":{"rendered":"LinkedIn \u2013 Advanced SQL for Query Tuning and Performance Optimization 2023-10"},"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<p dir=\"ltr\" style=\"text-align: left\" data-sourcepos=\"5:1-5:38\"><span style=\"vertical-align: inherit\">Advanced SQL for Query Tuning and Performance Optimization course. SQL queries can be fast and very efficient, but they can also be slow and require too much CPU and memory resources. For many SQL programmers, occasional encounters with long-running queries and poor performance are commonplace. But by better understanding how databases translate SQL queries into executables, you can take steps to avoid these problems. In this course, Dan Sullivan shows you how to analyze query execution plans and use data modeling strategies to increase query performance. Dan describes how to execute SQL queries, highlights the different types of indexes and how they play a role in query tuning, covers several methods for performing joins, and how to use partitioning and materialized views to improve Discusses performance. Additionally, Dan shows you how to implement PostgreSQL on GitHub Codespaces so you can start learning faster.<\/span><\/p>\n<h3 class=\"\" dir=\"ltr\" style=\"text-align: left\" data-sourcepos=\"15:1-15:24\"><span style=\"vertical-align: inherit\">What you will learn<\/span><\/h3>\n<ul dir=\"ltr\" style=\"text-align: left\" data-sourcepos=\"17:1-19:17\">\n<li data-sourcepos=\"17:1-17:72\"><span style=\"vertical-align: inherit\">How to analyze query execution plans to identify performance issues<\/span><\/li>\n<li data-sourcepos=\"18:1-18:49\"><span style=\"vertical-align: inherit\">How to use indexes to improve query speed<\/span><\/li>\n<li data-sourcepos=\"19:1-19:17\"><span style=\"vertical-align: inherit\">How to choose the right attachment method for your queries<\/span><\/li>\n<li data-sourcepos=\"20:1-20:75\"><span style=\"vertical-align: inherit\">How to use partitioning and materialized views to scale your queries<\/span><\/li>\n<li data-sourcepos=\"21:1-22:0\"><span style=\"vertical-align: inherit\">How to run PostgreSQL on GitHub Codespaces for query development and testing<\/span><\/li>\n<\/ul>\n<h3 class=\"\" dir=\"ltr\" style=\"text-align: left\" data-sourcepos=\"23:1-23:30\"><span style=\"vertical-align: inherit\">This course is suitable for people who<\/span><\/h3>\n<ul dir=\"ltr\" style=\"text-align: left\" data-sourcepos=\"25:1-28:0\">\n<li data-sourcepos=\"25:1-25:66\"><span style=\"vertical-align: inherit\">SQL programmers who want to optimize their queries<\/span><\/li>\n<li data-sourcepos=\"26:1-26:54\"><span style=\"vertical-align: inherit\">Database administrators who are responsible for the operation of the database<\/span><\/li>\n<li data-sourcepos=\"27:1-28:0\"><span style=\"vertical-align: inherit\">Data analysts who use SQL to extract information from databases<\/span><\/li>\n<\/ul>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Advanced SQL for Query Tuning and Performance Optimization course specifications<\/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.linkedin.com\/learning\/advanced-sql-for-query-tuning-and-performance-optimization-22894038?trk=learning-serp_learning-search-card_search-card&amp;upsellOrderOrigin=default_guest_learning\" target=\"_blank\"><span style=\"vertical-align: inherit\">LinkedIn<\/span><\/a><\/li>\n<li><span style=\"vertical-align: inherit\">Instructor: <\/span><a href=\"https:\/\/downloadlynet.ir\/tag\/dan-sullivan\/\"><span style=\"vertical-align: inherit\">Dan Sullivan<\/span><\/a><\/li>\n<li><span style=\"vertical-align: inherit\">Training level: advanced<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Training duration: 2 hours and 9 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-910726 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2024\/07\/Advanced-SQL-for-Query-Tuning-and-Performance-Optimization.jpg\" alt=\"Advanced SQL for Query Tuning and Performance Optimization\" width=\"350\" height=\"645\"> <img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-910724 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2024\/07\/Advanced-SQL-for-Query-Tuning-and-Performance-Optimization-1.jpg\" alt=\"Advanced SQL for Query Tuning and Performance Optimization\" width=\"343\" height=\"305\"><\/p>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Course images<\/span><\/h3>\n<p dir=\"ltr\" style=\"text-align: left\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-910725 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2024\/07\/Advanced-SQL-for-Query-Tuning-and-Performance-Optimization-2.jpg\" alt=\"Advanced SQL for Query Tuning and Performance Optimization\" width=\"970\" height=\"179\"><\/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-130640-1\"><video class=\"wp-video-shortcode\" id=\"video-130640-1_html5\" width=\"640\" height=\"360\" preload=\"metadata\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Advanced_SQL_for_Query_Tuning_and_Performance_Optimization_Downloadly.ir.mp4?_=1\" style=\"width: 640px; height: 360px;\"><source type=\"video\/mp4\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Advanced_SQL_for_Query_Tuning_and_Performance_Optimization_Downloadly.ir.mp4?_=1\"><a href=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Advanced_SQL_for_Query_Tuning_and_Performance_Optimization_Downloadly.ir.mp4?nocache=1786100464621\">https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Advanced_SQL_for_Query_Tuning_and_Performance_Optimization_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\/LinkedIn_Advanced_SQL_for_Query_Tuning_and_Performance_Optimization_2023-10_Downloadly.ir.rar?nocache=1786100463\"><span style=\"vertical-align: inherit\">Download file \u2013 196 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\">196 MB<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Description Advanced SQL for Query Tuning and Performance Optimization course. SQL queries can be fast and very efficient, but they can also be slow and require<\/p>\n","protected":false},"author":1,"template":"","dgi_category":[10458],"dgi_tag":[45025,28295,45026,45027,45028,45029],"class_list":["post-4142","digital_item","type-digital_item","status-publish","has-post-thumbnail","hentry","dgi_category-video-tutorials","dgi_tag-course-advanced-sql-for-query-tuning-and-performance-optimization","dgi_tag-dan-sullivan","dgi_tag-download-advanced-sql-for-query-tuning-and-performance-optimization","dgi_tag-download-course-advanced-sql-for-query-tuning-and-performance-optimization","dgi_tag-free-advanced-sql-for-query-tuning-and-performance-optimization","dgi_tag-free-download-advanced-sql-for-query-tuning-and-performance-optimization"],"_links":{"self":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item\/4142","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\/4142\/revisions"}],"wp:attachment":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/media?parent=4142"}],"wp:term":[{"taxonomy":"dgi_category","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_category?post=4142"},{"taxonomy":"dgi_tag","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_tag?post=4142"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}