{"id":12214,"date":"2026-08-10T10:42:37","date_gmt":"2026-08-10T10:42:37","guid":{"rendered":"https:\/\/nokobox.com\/index.php\/item\/bigmachine-io-postgresql-fundamentals-2025-4\/"},"modified":"2026-08-10T10:42:37","modified_gmt":"2026-08-10T10:42:37","slug":"bigmachine-io-postgresql-fundamentals-2025-4","status":"publish","type":"digital_item","link":"https:\/\/nokobox.com\/index.php\/item\/bigmachine-io-postgresql-fundamentals-2025-4\/","title":{"rendered":"Bigmachine.io \u2013 PostgreSQL Fundamentals 2025-4"},"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\">PostgreSQL Fundamentals Course. This two-hour course provides a hands-on, engaging introduction to the fundamentals of SQL and database management systems. Many data scientists consider SQL proficiency to be one of their most valuable professional skills. In this course, you\u2019ll learn this powerful language not by using abstract data, but by working on a real, exciting dataset from NASA\u2019s Cassini mission. You\u2019ll write different queries on scientific data collected from the spacecraft\u2019s flybys of the moon Enceladus, exploring whether there\u2019s any sign of life there. This fully interactive, project-based approach helps you learn, in a tangible and enjoyable way, basic concepts such as extracting, filtering, and sorting data using PostgreSQL, one of the most advanced and popular open source databases, and understand the main reason why SQL is so popular among developers and data analysts.<\/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\">SQL and Database Basics: Participants will learn the basics of the SQL language and how to work with databases.<\/span><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">Working with PostgreSQL: Learn how to use PostgreSQL as a powerful database management system.<\/span><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">Real data analysis: Using real data from the Cassini mission, they execute the necessary queries for data analysis.<\/span><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">Query data to discover new insights: Participants learn how to use queries to search for important information and patterns in data.<\/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\">Data science enthusiasts: People who want to increase their skills in working with data and analyzing it.<\/span><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">Software Developers: Programmers looking to learn SQL as a valuable skill in their career.<\/span><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">Students and beginners: People who have no prior experience with SQL and databases and are looking for a good starting point.<\/span><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">Anyone looking for a short and efficient training course to learn PostgreSQL.<\/span><\/li>\n<\/ul>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">PostgreSQL Fundamentals Course Specifications<\/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:\/\/bigmachine.io\/courses\/sql-orbit\" target=\"_blank\" rel=\"noopener\"><span dir=\"auto\" style=\"vertical-align: inherit\">Bigmachine.io<\/span><\/a><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">Instructor: <\/span><a href=\"https:\/\/downloadlynet.ir\/tag\/bigmachine-io\/\"><span dir=\"auto\" style=\"vertical-align: inherit\">Bigmachine.io<\/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: 2 hours and 5 minutes<\/span><\/li>\n<li><span dir=\"auto\" style=\"vertical-align: inherit\">Number of lessons: 28<\/span><\/li>\n<\/ul>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Course headings<\/span><\/h3>\n<ul dir=\"ltr\" style=\"text-align: left\">\n<li dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Welcome<\/span><\/li>\n<li dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Installing PostgreSQL<\/span><\/li>\n<li dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Creating Our Workspace<\/span><\/li>\n<li dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Importing the Master Plan<\/span><\/li>\n<li dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Inspecting the Master Plan<\/span><\/li>\n<li dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Inspecting the Master Plan<\/span><\/li>\n<li dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Inspecting the Master Plan<\/span><\/li>\n<li dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Creating a Proper Import Script<\/span><\/li>\n<li dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Extraction Summary<\/span><\/li>\n<li dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Flybys Introduction<\/span><\/li>\n<li dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Concept Normalization<\/span><\/li>\n<li dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Narrowing Our Search<\/span><\/li>\n<li dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Isolating the Enceladus Data<\/span><\/li>\n<li dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Creating the Working Set<\/span><\/li>\n<li dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Summary of Flyby Work<\/span><\/li>\n<li dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Introducing the INMS<\/span><\/li>\n<li dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Extracting and Loading the INMS Data<\/span><\/li>\n<li dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Transformation, Part 1<\/span><\/li>\n<li dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Transformation, Part 1<\/span><\/li>\n<li dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Transformation, Part 2<\/span><\/li>\n<li dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Troubleshooting<\/span><\/li>\n<li dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">INMS Loading Summary<\/span><\/li>\n<li dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Understanding What We\u2019re Looking For<\/span><\/li>\n<li dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Understanding What We\u2019re Looking For<\/span><\/li>\n<li dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Spreadsheet Export<\/span><\/li>\n<li dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Ethical Considerations<\/span><\/li>\n<li dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Ship It!<\/span><\/li>\n<li dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Summary, and Farewell!<\/span><\/li>\n<\/ul>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" 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-1007209 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2025\/09\/PostgreSQL-Fundamentals-1.png\" alt=\"PostgreSQL Fundamentals\" width=\"410\" height=\"337\"><\/p>\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-176194-1\"><video class=\"wp-video-shortcode\" id=\"video-176194-1_html5\" width=\"640\" height=\"360\" preload=\"metadata\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/PostgreSQL_Fundamentals_Downloadly.ir.mp4?_=1\" style=\"width: 640px; height: 360px;\"><source type=\"video\/mp4\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/PostgreSQL_Fundamentals_Downloadly.ir.mp4?_=1\"><a href=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/PostgreSQL_Fundamentals_Downloadly.ir.mp4?nocache=1786142855029\">https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/PostgreSQL_Fundamentals_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: None<\/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><strong>Downloadly<\/strong><\/h4>\n<p dir=\"ltr\" style=\"text-align: left\"><a href=\"https:\/\/dl4.downloadly.ir\/Files\/Elearning\/Bigmachine.io_PostgreSQL_Fundamentals_2025-4_Downloadly.ir.rar?nocache=1786142853\"><span dir=\"auto\" style=\"vertical-align: inherit\">Download Course \u2013 178 MB<\/span><\/a><\/p>\n<h4><strong>Rapidgator<\/strong><\/h4>\n<p dir=\"ltr\" style=\"text-align: left\"><a href=\"https:\/\/rapidgator.net\/file\/6d1571c48a3f39dcfcbcde92f5e57c18\/Bigmachine.io_PostgreSQL_Fundamentals_2025-4_Downloadly.ir.rar.html\" target=\"_blank\" rel=\"noopener\"><span dir=\"auto\" style=\"vertical-align: inherit\">Download Course \u2013 178 MB<\/span><\/a><\/p>\n<h5 dir=\"ltr\" style=\"text-align: left\"><span dir=\"auto\" style=\"vertical-align: inherit\">Password File(s): www.downloadly.ir<\/span><\/h5>\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\">178 MB<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Description PostgreSQL Fundamentals Course. This two-hour course provides a hands-on, engaging introduction to the fundamentals of SQL and database management s<\/p>\n","protected":false},"author":1,"template":"","dgi_category":[10458],"dgi_tag":[101052,101053,101054,101055,101056,101057],"class_list":["post-12214","digital_item","type-digital_item","status-publish","has-post-thumbnail","hentry","dgi_category-video-tutorials","dgi_tag-bigmachine-io","dgi_tag-course-postgresql-fundamentals","dgi_tag-download-course-postgresql-fundamentals","dgi_tag-download-postgresql-fundamentals","dgi_tag-free-download-postgresql-fundamentals","dgi_tag-free-postgresql-fundamentals"],"_links":{"self":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item\/12214","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\/12214\/revisions"}],"wp:attachment":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/media?parent=12214"}],"wp:term":[{"taxonomy":"dgi_category","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_category?post=12214"},{"taxonomy":"dgi_tag","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_tag?post=12214"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}