{"id":13156,"date":"2026-08-10T10:55:23","date_gmt":"2026-08-10T10:55:23","guid":{"rendered":"https:\/\/nokobox.com\/index.php\/item\/linkedin-intermediate-sql-for-data-scientists-2025-3\/"},"modified":"2026-08-10T10:55:23","modified_gmt":"2026-08-10T10:55:23","slug":"linkedin-intermediate-sql-for-data-scientists-2025-3","status":"publish","type":"digital_item","link":"https:\/\/nokobox.com\/index.php\/item\/linkedin-intermediate-sql-for-data-scientists-2025-3\/","title":{"rendered":"LinkedIn \u2013 Intermediate SQL for Data Scientists 2025-3"},"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\"><span dir=\"auto\" style=\"vertical-align: inherit\">Intermediate SQL for Data Scientists. This course teaches the essential skills for analyzing and extracting data from relational databases. As organizations increasingly move toward digital transformation and generate massive amounts of data, the need for professionals who can work with this data is greater than ever. Instructor Dan Sullivan explains common data science tasks such as searching, exploring, and extracting information. During this course, participants will learn the concepts and applications of aggregate functions, statistical functions, window operations, regular expressions, and subqueries. They will also learn how to work with semi-structured data such as JSON and execute more complex queries using JOIN operations. The course is seamlessly integrated with GitHub Codespaces, providing a ready-made cloud development environment and eliminating the need for on-premises setup and configuration. This environment allows learners to have hands-on, real-world experience from any device, at any time, and introduces them to tools they will encounter in professional work environments. To get started with this environment, a section on how to use GitHub Codespaces is included in the course.<\/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><span dir=\"auto\" style=\"vertical-align: inherit\">Advanced query writing principles:<\/span><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">How to use aggregate functions to summarize data.<\/span><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">Using statistical functions to analyze and draw conclusions from data.<\/span><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">Perform window operations to perform calculations within a defined window of rows.<\/span><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">Use Regular Expressions to search for and match complex patterns in text.<\/span><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">Create and use subqueries for multi-step queries.<\/span><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">Working with complex data and Joins:<\/span><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">How to use the JSON data type, which is a semi-structured data type.<\/span><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">Perform Join operations to combine data from multiple tables and enable more complex queries.<\/span><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">Performing data science tasks with SQL:<\/span><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">Learn how to search, explore, and extract data in relational databases.<\/span><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">Explain how to perform common data science tasks using SQL capabilities.<\/span><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">Development and practical training environment:<\/span><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">Familiarity and work in the GitHub Codespaces environment, which allows for hands-on practice without the need for local settings.<\/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><span dir=\"auto\" style=\"vertical-align: inherit\">Analysts looking to upgrade their SQL skills to manage and analyze increasing volumes of data.<\/span><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">Data scientists who deal with SQL databases on a daily basis and need more advanced queries.<\/span><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">Data professionals who want to enhance their abilities in data mining and exploration in relational databases.<\/span><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">People who want to learn how to work with semi-structured data types like JSON in SQL.<\/span><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">Those looking for hands-on experience using industry tools like GitHub Codespaces in a cloud environment.<\/span><\/li>\n<\/ul>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Intermediate SQL for Data Scientists course details<\/span><\/h3>\n<ul dir=\"ltr\" style=\"text-align: left\">\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">Publisher: <\/span><a href=\"https:\/\/href.li\/?https:\/\/www.linkedin.com\/learning\/intermediate-sql-for-data-scientists-25322592\" target=\"_blank\"><span dir=\"auto\" style=\"vertical-align: inherit\">LinkedIn<\/span><\/a><\/li>\n<li><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><span dir=\"auto\" style=\"vertical-align: inherit\">Education level: Intermediate<\/span><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">Training duration: 3 hours and 50 minutes<\/span><\/li>\n<\/ul>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Course headings<\/span><\/h3>\n<h2 dir=\"ltr\" style=\"text-align: left\">&nbsp;<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1017935 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2025\/11\/Intermediate-SQL-for-Data-Scientists.png\" alt=\"Intermediate SQL for Data Scientists\" width=\"419\" height=\"726\"><\/h2>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Course images<\/span><\/h3>\n<h2 dir=\"ltr\" style=\"text-align: left\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-1017934 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2025\/11\/Intermediate-SQL-for-Data-Scientists-1.png\" alt=\"Intermediate SQL for Data Scientists\" width=\"860\" height=\"194\"><\/h2>\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-183781-1\"><video class=\"wp-video-shortcode\" id=\"video-183781-1_html5\" width=\"640\" height=\"360\" preload=\"metadata\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Intermediate_SQL_for_Data_Scientists_Downloadly.ir.mp4?_=1\" style=\"width: 640px; height: 360px;\"><source type=\"video\/mp4\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Intermediate_SQL_for_Data_Scientists_Downloadly.ir.mp4?_=1\"><a href=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Intermediate_SQL_for_Data_Scientists_Downloadly.ir.mp4?nocache=1786174663714\">https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Intermediate_SQL_for_Data_Scientists_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: 720p<\/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\/LinkedIn_Intermediate_SQL_for_Data_Scientists_2025-3_Downloadly.ir.rar?nocache=1786174662\"><span dir=\"auto\" style=\"vertical-align: inherit\">Download file \u2013 432 MB<\/span><\/a><\/p>\n<h4 dir=\"ltr\">Rapidgator link<\/h4>\n<p><a href=\"https:\/\/rapidgator.net\/file\/4eb68b67210fcd451031df269dbf9bfa\/LinkedIn_Intermediate_SQL_for_Data_Scientists_2025-3_Downloadly.ir.rar.html\" target=\"_blank\" rel=\"noopener\">Download File \u2013 432 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\">432 MB<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Description Intermediate SQL for Data Scientists. This course teaches the essential skills for analyzing and extracting data from relational databases. As organ<\/p>\n","protected":false},"author":1,"template":"","dgi_category":[10458],"dgi_tag":[107923,28295,107924,107925,107926,107927],"class_list":["post-13156","digital_item","type-digital_item","status-publish","has-post-thumbnail","hentry","dgi_category-video-tutorials","dgi_tag-course-intermediate-sql-for-data-scientists","dgi_tag-dan-sullivan","dgi_tag-download-course-intermediate-sql-for-data-scientists","dgi_tag-download-intermediate-sql-for-data-scientists","dgi_tag-free-download-intermediate-sql-for-data-scientists","dgi_tag-free-intermediate-sql-for-data-scientists"],"_links":{"self":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item\/13156","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\/13156\/revisions"}],"wp:attachment":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/media?parent=13156"}],"wp:term":[{"taxonomy":"dgi_category","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_category?post=13156"},{"taxonomy":"dgi_tag","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_tag?post=13156"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}