{"id":3273,"date":"2026-08-10T09:03:28","date_gmt":"2026-08-10T09:03:28","guid":{"rendered":"https:\/\/nokobox.com\/index.php\/item\/linkedin-top-five-things-to-know-in-advanced-sql-2023-8\/"},"modified":"2026-08-10T09:03:28","modified_gmt":"2026-08-10T09:03:28","slug":"linkedin-top-five-things-to-know-in-advanced-sql-2023-8","status":"publish","type":"digital_item","link":"https:\/\/nokobox.com\/index.php\/item\/linkedin-top-five-things-to-know-in-advanced-sql-2023-8\/","title":{"rendered":"LinkedIn \u2013 Top Five Things to Know in Advanced SQL 2023-8"},"content":{"rendered":"<div class=\"w-post-elm post_content\">\n<h2><span style=\"vertical-align: inherit\">Description<\/span><\/h2>\n<p data-sourcepos=\"5:1-5:328\"><span style=\"vertical-align: inherit\">Top Five Things to Know in Advanced SQL course. This course is presented by Kendall Ruber and is designed to improve your knowledge of advanced SQL commands. The course begins with a review of basic SQL concepts and then gradually enters more advanced topics. During the course, practical exercises are included to better understand these concepts and their application in solving real business problems. By completing this course, students will be able to:<\/span><\/p>\n<ul data-sourcepos=\"9:1-11:0\">\n<li data-sourcepos=\"9:1-9:55\"><span style=\"vertical-align: inherit\">Understand the uses and limitations of various advanced functions in SQL<\/span><\/li>\n<li data-sourcepos=\"10:1-11:0\"><span style=\"vertical-align: inherit\">Appropriate application of these functions to solve business problems<\/span><\/li>\n<\/ul>\n<p data-sourcepos=\"12:1-12:28\"><span style=\"vertical-align: inherit\">The main topics of the course are:<\/span><\/p>\n<ul data-sourcepos=\"14:1-17:0\">\n<li data-sourcepos=\"14:1-14:27\"><span style=\"vertical-align: inherit\">Subqueries<\/span><\/li>\n<li data-sourcepos=\"15:1-15:53\"><span style=\"vertical-align: inherit\">Common table expressions (Common Table Expressions \u2013 CTE)<\/span><\/li>\n<li data-sourcepos=\"16:1-17:0\"><span style=\"vertical-align: inherit\">Window Functions<\/span><\/li>\n<\/ul>\n<p data-sourcepos=\"18:1-18:226\"><span style=\"vertical-align: inherit\">This course includes various sections, including training videos, practical exercises, course tests and training files on the GitHub platform. Note that some sections are locked and you need to purchase a course to access them.<\/span><\/p>\n<h3 data-sourcepos=\"20:1-20:26\"><span style=\"vertical-align: inherit\">What you will learn:<\/span><\/h3>\n<ul data-sourcepos=\"22:1-39:0\">\n<li data-sourcepos=\"22:1-22:39\"><span style=\"vertical-align: inherit\">Understanding the concept of subquery in SQL<\/span><\/li>\n<li data-sourcepos=\"23:1-23:101\"><span style=\"vertical-align: inherit\">Getting to know how to write Scalar Subqueries and Multiple-Row Subqueries<\/span><\/li>\n<li data-sourcepos=\"24:1-24:94\"><span style=\"vertical-align: inherit\">Distinguishing between Correlated Subqueries and Uncorrelated Subqueries<\/span><\/li>\n<li data-sourcepos=\"25:1-25:49\"><span style=\"vertical-align: inherit\">Practice and learn to make subsets to solve problems<\/span><\/li>\n<li data-sourcepos=\"26:1-26:55\"><span style=\"vertical-align: inherit\">Familiarity with common table expressions (CTE) and how to write them<\/span><\/li>\n<li data-sourcepos=\"27:1-27:44\"><span style=\"vertical-align: inherit\">Understanding the concept of recursive CTEs<\/span><\/li>\n<li data-sourcepos=\"28:1-28:42\"><span style=\"vertical-align: inherit\">Compare and differentiate between CTE and subcategory<\/span><\/li>\n<li data-sourcepos=\"29:1-29:40\"><span style=\"vertical-align: inherit\">Practice and learn to construct CTE to solve problems<\/span><\/li>\n<li data-sourcepos=\"30:1-30:60\"><span style=\"vertical-align: inherit\">Familiarity with window functions and their use<\/span><\/li>\n<li data-sourcepos=\"31:1-31:47\"><span style=\"vertical-align: inherit\">Understanding the concept and how to use the ROW_NUMBER() function<\/span><\/li>\n<li data-sourcepos=\"32:1-32:56\"><span style=\"vertical-align: inherit\">Practice and learn row calculation using ROW_NUMBER()<\/span><\/li>\n<li data-sourcepos=\"33:1-33:47\"><span style=\"vertical-align: inherit\">Familiarity with LAG() and LEAD() functions and their use<\/span><\/li>\n<li data-sourcepos=\"34:1-34:95\"><span style=\"vertical-align: inherit\">Practice and learn to use LAG() and LEAD() functions to solve problems (such as determining the last order value)<\/span><\/li>\n<li data-sourcepos=\"35:1-35:68\"><span style=\"vertical-align: inherit\">Familiarity with window functions for ranking (Ranking Window Functions)<\/span><\/li>\n<li data-sourcepos=\"36:1-36:43\"><span style=\"vertical-align: inherit\">Understanding the difference between the RANK() and DENSE_RANK() functions<\/span><\/li>\n<li data-sourcepos=\"37:1-39:0\"><span style=\"vertical-align: inherit\">Practice and learn to use RANK() and DENSE_RANK() functions to rank data<\/span><\/li>\n<\/ul>\n<h3 data-sourcepos=\"40:1-40:31\"><span style=\"vertical-align: inherit\">This course is suitable for people who:<\/span><\/h3>\n<ul data-sourcepos=\"42:1-44:67\">\n<li data-sourcepos=\"42:1-42:44\"><span style=\"vertical-align: inherit\">They have basic knowledge of basic SQL commands.<\/span><\/li>\n<li data-sourcepos=\"43:1-43:79\"><span style=\"vertical-align: inherit\">Looking to improve their skills in data analysis using SQL.<\/span><\/li>\n<li data-sourcepos=\"44:1-44:67\"><span style=\"vertical-align: inherit\">Interested in solving real business problems using SQL.<\/span><\/li>\n<\/ul>\n<h3><span style=\"vertical-align: inherit\">Details of the Top Five Things to Know in Advanced SQL course<\/span><\/h3>\n<ul>\n<li><span style=\"vertical-align: inherit\">Publisher: <\/span><a href=\"https:\/\/href.li\/?https:\/\/www.linkedin.com\/learning\/top-10-skills-for-machine-learning-cloud-architects\" 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\/kendall-ruber\/\"><span style=\"vertical-align: inherit\">Kendall Ruber<\/span><\/a><\/li>\n<li><span style=\"vertical-align: inherit\">Education level: Intermediate<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Training duration: 1 hour and 35 minutes<\/span><\/li>\n<\/ul>\n<h3><span style=\"vertical-align: inherit\">Course headings<\/span><\/h3>\n<h2>&nbsp;<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-901915 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2024\/05\/Top-Five-Things-to-Know-in-Advanced-SQL1.jpg\" alt=\"Top Five Things to Know in Advanced SQL\" width=\"406\" height=\"491\"><\/h2>\n<h3><span style=\"vertical-align: inherit\">Course images<\/span><\/h3>\n<h2><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-901913 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2024\/05\/Top-Five-Things-to-Know-in-Advanced-SQL.jpg\" alt=\"Top Five Things to Know in Advanced SQL\" width=\"681\" height=\"226\"><\/h2>\n<h3><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-126144-1\"><video class=\"wp-video-shortcode\" id=\"video-126144-1_html5\" width=\"640\" height=\"360\" preload=\"metadata\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Top_Five_Things_to_Know_in_Advanced_SQL_Downloadly.ir.mp4?_=1\" style=\"width: 640px; height: 360px;\"><source type=\"video\/mp4\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Top_Five_Things_to_Know_in_Advanced_SQL_Downloadly.ir.mp4?_=1\"><a href=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Top_Five_Things_to_Know_in_Advanced_SQL_Downloadly.ir.mp4?nocache=1786097936375\">https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Top_Five_Things_to_Know_in_Advanced_SQL_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>\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><span style=\"vertical-align: inherit\">download link<\/span><\/h3>\n<p><a href=\"https:\/\/dl3.downloadly.ir\/Files\/Elearning\/LinkedIn_Top_Five_Things_to_Know_in_Advanced_SQL_2023-8_Downloadly.ir.rar?nocache=1786097934\"><span style=\"vertical-align: inherit\">Download file \u2013 191 MB<\/span><\/a><\/p>\n<p><span style=\"vertical-align: inherit\">File(s) password: www.downloadly.ir<\/span><\/p>\n<h3><span style=\"vertical-align: inherit\">Size<\/span><\/h3>\n<p><span style=\"vertical-align: inherit\">191 MB<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Description Top Five Things to Know in Advanced SQL course. This course is presented by Kendall Ruber and is designed to improve your knowledge of advanced SQL <\/p>\n","protected":false},"author":1,"template":"","dgi_category":[10458],"dgi_tag":[36595,36596,36597,36598,36599,36600,36601,36602,36603,36604,36605,36606,36607,36608,36609,36610,36611,36612,36613,36614,36615,36616,36617,36618],"class_list":["post-3273","digital_item","type-digital_item","status-publish","has-post-thumbnail","hentry","dgi_category-video-tutorials","dgi_tag-course-top-five-things-to-know-in-advanced-sql","dgi_tag-download-course-top-five-things-to-know-in-advanced-sql","dgi_tag-download-link-top-five-things-to-know-in-advanced-sql","dgi_tag-download-links-top-five-things-to-know-in-advanced-sql","dgi_tag-download-paid-course-top-five-things-to-know-in-advanced-sql","dgi_tag-download-top-five-things-to-know-in-advanced-sql","dgi_tag-download-top-five-things-to-know-in-advanced-sql-course","dgi_tag-download-top-five-things-to-know-in-advanced-sql-course-for-free","dgi_tag-free-download-course-top-five-things-to-know-in-advanced-sql","dgi_tag-free-download-link-top-five-things-to-know-in-advanced-sql","dgi_tag-free-download-links-top-five-things-to-know-in-advanced-sql","dgi_tag-free-download-paid-course-top-five-things-to-know-in-advanced-sql","dgi_tag-free-download-top-five-things-to-know-in-advanced-sql","dgi_tag-free-links-download-top-five-things-to-know-in-advanced-sql","dgi_tag-free-paid-course-download-links-top-five-things-to-know-in-advanced-sql","dgi_tag-free-top-five-things-to-know-in-advanced-sql","dgi_tag-free-top-five-things-to-know-in-advanced-sql-download-course","dgi_tag-kendall-ruber","dgi_tag-paid-course-top-five-things-to-know-in-advanced-sql","dgi_tag-top-five-things-to-know-in-advanced-sql-download-course","dgi_tag-top-five-things-to-know-in-advanced-sql-download-links","dgi_tag-top-five-things-to-know-in-advanced-sql-for-free","dgi_tag-top-five-things-to-know-in-advanced-sql-free-course","dgi_tag-top-five-things-to-know-in-advanced-sql-free-download"],"_links":{"self":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item\/3273","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\/3273\/revisions"}],"wp:attachment":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/media?parent=3273"}],"wp:term":[{"taxonomy":"dgi_category","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_category?post=3273"},{"taxonomy":"dgi_tag","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_tag?post=3273"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}