{"id":10399,"date":"2026-08-10T10:18:41","date_gmt":"2026-08-10T10:18:41","guid":{"rendered":"https:\/\/nokobox.com\/index.php\/item\/linkedin-sql-hands-on-practice-solve-business-problems-2023-9\/"},"modified":"2026-08-10T10:18:41","modified_gmt":"2026-08-10T10:18:41","slug":"linkedin-sql-hands-on-practice-solve-business-problems-2023-9","status":"publish","type":"digital_item","link":"https:\/\/nokobox.com\/index.php\/item\/linkedin-sql-hands-on-practice-solve-business-problems-2023-9\/","title":{"rendered":"LinkedIn \u2013 SQL Hands-On Practice: Solve Business Problems 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\" data-sourcepos=\"9:1-9:824\"><span style=\"vertical-align: inherit\">SQL Hands-On Practice: Solve Business Problems. This course is designed for people with an intermediate level of SQL knowledge who want to improve their ability to solve real-world business problems using the language. Through hands-on projects led by instructor Jess Ramos, participants will tackle a variety of challenges based on real-world scenarios from a technology company. Topics covered include analyzing product data using CTEs, manipulating values \u200b\u200bwith CASE statements, merging multiple data sources with UNION, working with hierarchical data using self joins, and solving complex problems with window functions. The course also includes interactive coding challenges using the CoderPad platform, which provides hands-on practice and immediate feedback to effectively develop participants\u2019 skills.<\/span><\/p>\n<h3 dir=\"ltr\" style=\"text-align: left\" data-sourcepos=\"11:1-11:25\"><span style=\"vertical-align: inherit\">What you will learn:<\/span><\/h3>\n<ul dir=\"ltr\" style=\"text-align: left\" data-sourcepos=\"13:1-33:0\">\n<li data-sourcepos=\"13:1-13:76\"><span style=\"vertical-align: inherit\">Analyzing products using Common Table Expressions (CTEs) in SQL<\/span><\/li>\n<li data-sourcepos=\"14:1-14:52\"><span style=\"vertical-align: inherit\">Transforming and reshaping data using the CASE statement<\/span><\/li>\n<li data-sourcepos=\"15:1-15:53\"><span style=\"vertical-align: inherit\">Combining multiple data sources using the UNION operator<\/span><\/li>\n<li data-sourcepos=\"16:1-16:55\"><span style=\"vertical-align: inherit\">Working with hierarchical data using Self Joins<\/span><\/li>\n<li data-sourcepos=\"17:1-17:66\"><span style=\"vertical-align: inherit\">Solve advanced problems using Window Functions<\/span><\/li>\n<li data-sourcepos=\"18:1-18:48\"><span style=\"vertical-align: inherit\">Summarizing customer data for presentation to management<\/span><\/li>\n<li data-sourcepos=\"19:1-19:56\"><span style=\"vertical-align: inherit\">Combine Aggregate functions with CTEs for more complex analyses<\/span><\/li>\n<li data-sourcepos=\"20:1-20:40\"><span style=\"vertical-align: inherit\">Investigating the distribution of variables using CTEs<\/span><\/li>\n<li data-sourcepos=\"21:1-21:37\"><span style=\"vertical-align: inherit\">Checkout Funnel Analysis Using CTEs<\/span><\/li>\n<li data-sourcepos=\"22:1-22:42\"><span style=\"vertical-align: inherit\">Creating binary columns using CASE<\/span><\/li>\n<li data-sourcepos=\"23:1-23:45\"><span style=\"vertical-align: inherit\">Creating aggregated columns using CASE<\/span><\/li>\n<li data-sourcepos=\"24:1-24:39\"><span style=\"vertical-align: inherit\">Combining product tables using UNION<\/span><\/li>\n<li data-sourcepos=\"25:1-25:56\"><span style=\"vertical-align: inherit\">Converting columns to rows using UNION (Unpivoting)<\/span><\/li>\n<li data-sourcepos=\"26:1-26:53\"><span style=\"vertical-align: inherit\">Communication between users and administrators using Self Join<\/span><\/li>\n<li data-sourcepos=\"27:1-27:57\"><span style=\"vertical-align: inherit\">Compare rows in the same table using Self Join<\/span><\/li>\n<li data-sourcepos=\"28:1-28:60\"><span style=\"vertical-align: inherit\">Extracting the latest sales data using Window Functions<\/span><\/li>\n<li data-sourcepos=\"29:1-29:54\"><span style=\"vertical-align: inherit\">Using the Rank(), row_number(), and dense_rank() functions<\/span><\/li>\n<li data-sourcepos=\"30:1-30:47\"><span style=\"vertical-align: inherit\">Extracting the last sale using row_number()<\/span><\/li>\n<li data-sourcepos=\"31:1-31:61\"><span style=\"vertical-align: inherit\">Calculating Running Totals Using Window Functions<\/span><\/li>\n<li data-sourcepos=\"32:1-33:0\"><span style=\"vertical-align: inherit\">Calculating time differences using the LEAD() function<\/span><\/li>\n<\/ul>\n<h3 dir=\"ltr\" style=\"text-align: left\" data-sourcepos=\"34:1-34:32\"><span style=\"vertical-align: inherit\">Who is this course suitable for?<\/span><\/h3>\n<ul dir=\"ltr\" style=\"text-align: left\" data-sourcepos=\"36:1-40:0\">\n<li data-sourcepos=\"36:1-36:100\"><span style=\"vertical-align: inherit\">People who have intermediate knowledge of SQL and want to improve their practical skills in solving business problems.<\/span><\/li>\n<li data-sourcepos=\"37:1-37:90\"><span style=\"vertical-align: inherit\">SQL programmers looking to learn more advanced SQL techniques for data analysis.<\/span><\/li>\n<li data-sourcepos=\"38:1-38:85\"><span style=\"vertical-align: inherit\">Data analysts who want to use SQL to solve real business challenges.<\/span><\/li>\n<li data-sourcepos=\"39:1-40:0\"><span style=\"vertical-align: inherit\">Anyone who wants to gain a deeper understanding of the practical applications of SQL in business environments.<\/span><\/li>\n<\/ul>\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-hands-on-practice-solve-business-problems\" target=\"_blank\" rel=\"noopener\"><span style=\"vertical-align: inherit\">LinkedIn<\/span><\/a><\/li>\n<li><span style=\"vertical-align: inherit\">Instructor: <\/span><a href=\"https:\/\/downloadlynet.ir\/tag\/jess-ramos\/\"><span style=\"vertical-align: inherit\">Jess Ramos<\/span><\/a><\/li>\n<li><span style=\"vertical-align: inherit\">Education level: Intermediate<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Training duration: 2 hours and 8 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-984848 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2025\/05\/SQL-Hands-On-Practice-Solve-Business-Problems.png\" alt=\"SQL Hands-On Practice: Solve Business Problems\" width=\"433\" height=\"545\"><\/p>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">SQL Hands-On Practice: Solve Business Problems Course Images<\/span><\/h3>\n<p dir=\"ltr\" style=\"text-align: left\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-984847 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2025\/05\/SQL-Hands-On-Practice-Solve-Business-Problems-1.png\" alt=\"SQL Hands-On Practice: Solve Business Problems\" width=\"915\" height=\"188\"><\/p>\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-165254-1\"><video class=\"wp-video-shortcode\" id=\"video-165254-1_html5\" width=\"640\" height=\"360\" preload=\"metadata\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/SQL_Hands-On_Practice_Solve_Business_Problems_Downloadly.ir.mp4?_=1\" style=\"width: 640px; height: 360px;\"><source type=\"video\/mp4\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/SQL_Hands-On_Practice_Solve_Business_Problems_Downloadly.ir.mp4?_=1\"><a href=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/SQL_Hands-On_Practice_Solve_Business_Problems_Downloadly.ir.mp4?nocache=1786137944345\">https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/SQL_Hands-On_Practice_Solve_Business_Problems_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: English<\/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_Hands-On_Practice_Solve_Business_Problems_2023-9_Downloadly.ir.rar?nocache=1786137943\"><span style=\"vertical-align: inherit\">Download file \u2013 186 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\">File size<\/span><\/h3>\n<p dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">186 MB<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Description SQL Hands-On Practice: Solve Business Problems. This course is designed for people with an intermediate level of SQL knowledge who want to improve t<\/p>\n","protected":false},"author":1,"template":"","dgi_category":[10458],"dgi_tag":[87941,87942,87943,87944,87945,29586],"class_list":["post-10399","digital_item","type-digital_item","status-publish","has-post-thumbnail","hentry","dgi_category-video-tutorials","dgi_tag-course-sql-hands-on-practice-solve-business-problems","dgi_tag-download-course-sql-hands-on-practice-solve-business-problems","dgi_tag-download-sql-hands-on-practice-solve-business-problems","dgi_tag-free-download-sql-hands-on-practice-solve-business-problems","dgi_tag-free-sql-hands-on-practice-solve-business-problems","dgi_tag-jess-ramos"],"_links":{"self":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item\/10399","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\/10399\/revisions"}],"wp:attachment":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/media?parent=10399"}],"wp:term":[{"taxonomy":"dgi_category","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_category?post=10399"},{"taxonomy":"dgi_tag","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_tag?post=10399"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}