{"id":2828,"date":"2026-08-10T08:59:34","date_gmt":"2026-08-10T08:59:34","guid":{"rendered":"https:\/\/nokobox.com\/index.php\/item\/linkedin-sql-practice-window-functions-2023-9\/"},"modified":"2026-08-10T08:59:34","modified_gmt":"2026-08-10T08:59:34","slug":"linkedin-sql-practice-window-functions-2023-9","status":"publish","type":"digital_item","link":"https:\/\/nokobox.com\/index.php\/item\/linkedin-sql-practice-window-functions-2023-9\/","title":{"rendered":"LinkedIn \u2013 SQL Practice: Window Functions 2023-9"},"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\"><span style=\"vertical-align: inherit\">SQL Practice Course: Window Functions. Test your knowledge of window functions in SQL in this edition of Code Challenges. Instructor Scott Simpson presents five challenges and their solutions that reflect real-world data analytics use cases, including calculating running totals, ranking a company\u2019s employees by pay, and comparing order totals over time. It\u2019s a data-driven world, and SQL is the language most often used to work with that data. Try Scott\u2019s Challenges to see how your skills match up, learn new techniques, and work with the various data analysis and reporting tools that many SQL-compatible relational database management systems offer. Gain confidence. This course includes code challenges designed by CoderPad. Code Challenges are interactive coding exercises with real-time feedback, so you can practice coding alongside the course content to improve your coding skills.<\/span><\/p>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">What you will learn in the SQL Practice: Window Functions 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\" data-purpose=\"objective\">\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\" data-purpose=\"objective\">\n<div class=\"ud-block-list-item-content\">\n<div class=\"table-of-contents__item-details\">\n<div class=\"table-of-contents__item-title\">\n<ul>\n<li><span style=\"vertical-align: inherit\">Solution: Calculate the running total<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Solution: Summary of weekly payment by department<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Solution: Rank the employees of the department based on salary<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Solution: Compare total orders over time<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Solution: Moving average<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">And\u2026<\/span><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\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.linkedin.com\/learning\/sql-practice-window-functions\" 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\/scott-simpson\/\"><span style=\"vertical-align: inherit\">Scott Simpson<\/span><\/a><\/li>\n<li><span style=\"vertical-align: inherit\">Training level: advanced<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Training duration: 12 minutes<\/span><\/li>\n<\/ul>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Course headings<\/span><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-895979 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2024\/04\/SQL-Practice-Window-Functions.jpg\" alt=\"SQL Practice: Window Functions\" width=\"376\" height=\"249\"><\/h3>\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-895978 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2024\/04\/SQL-Practice-Window-Functions-1.jpg\" alt=\"SQL Practice: Window Functions\" width=\"495\" height=\"131\"><\/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-123031-1\"><video class=\"wp-video-shortcode\" id=\"video-123031-1_html5\" width=\"640\" height=\"360\" preload=\"metadata\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/SQL_Practice_Window_Functions_Downloadly.ir.mp4?_=1\" style=\"width: 640px; height: 360px;\"><source type=\"video\/mp4\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/SQL_Practice_Window_Functions_Downloadly.ir.mp4?_=1\"><a href=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/SQL_Practice_Window_Functions_Downloadly.ir.mp4?nocache=1786096475128\">https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/SQL_Practice_Window_Functions_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:\/\/dl3.downloadly.ir\/Files\/Elearning\/LinkedIn_SQL_Practice_Window_Functions_2023-9_Downloadly.ir.rar?nocache=1786096474\"><span style=\"vertical-align: inherit\">Download file \u2013 20.2 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\">20.2 MB<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Description SQL Practice Course: Window Functions. Test your knowledge of window functions in SQL in this edition of Code Challenges. Instructor Scott Simpson p<\/p>\n","protected":false},"author":1,"template":"","dgi_category":[10458],"dgi_tag":[29934,29935,29936,29937,29938,29939,29940,29941,29942,29943,29944,29945,29946,29947,29948,29949,29950,29951,28846,29952,29953,29954,29955,29956],"class_list":["post-2828","digital_item","type-digital_item","status-publish","has-post-thumbnail","hentry","dgi_category-video-tutorials","dgi_tag-course-sql-practice-window-functions","dgi_tag-download-course-sql-practice-window-functions","dgi_tag-download-link-sql-practice-window-functions","dgi_tag-download-links-sql-practice-window-functions","dgi_tag-download-paid-course-sql-practice-window-functions","dgi_tag-download-sql-practice-window-functions","dgi_tag-download-sql-practice-window-functions-course","dgi_tag-download-sql-practice-window-functions-course-for-free","dgi_tag-free-download-course-sql-practice-window-functions","dgi_tag-free-download-link-sql-practice-window-functions","dgi_tag-free-download-links-sql-practice-window-functions","dgi_tag-free-download-paid-course-sql-practice-window-functions","dgi_tag-free-download-sql-practice-window-functions","dgi_tag-free-links-download-sql-practice-window-functions","dgi_tag-free-paid-course-download-links-sql-practice-window-functions","dgi_tag-free-sql-practice-window-functions","dgi_tag-free-sql-practice-window-functions-download-course","dgi_tag-paid-course-sql-practice-window-functions","dgi_tag-scott-simpson","dgi_tag-sql-practice-window-functions-download-course","dgi_tag-sql-practice-window-functions-download-links","dgi_tag-sql-practice-window-functions-for-free","dgi_tag-sql-practice-window-functions-free-course","dgi_tag-sql-practice-window-functions-free-download"],"_links":{"self":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item\/2828","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\/2828\/revisions"}],"wp:attachment":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/media?parent=2828"}],"wp:term":[{"taxonomy":"dgi_category","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_category?post=2828"},{"taxonomy":"dgi_tag","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_tag?post=2828"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}