{"id":5996,"date":"2026-08-10T09:28:45","date_gmt":"2026-08-10T09:28:45","guid":{"rendered":"https:\/\/nokobox.com\/index.php\/item\/udemy-postgresql-jsonb-learn-this-powerful-tool-by-examples-2024-8\/"},"modified":"2026-08-10T09:28:45","modified_gmt":"2026-08-10T09:28:45","slug":"udemy-postgresql-jsonb-learn-this-powerful-tool-by-examples-2024-8","status":"publish","type":"digital_item","link":"https:\/\/nokobox.com\/index.php\/item\/udemy-postgresql-jsonb-learn-this-powerful-tool-by-examples-2024-8\/","title":{"rendered":"Udemy \u2013 Postgresql Jsonb : Learn this powerful tool by examples 2024-8"},"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=\"5:1-5:147\"><span style=\"vertical-align: inherit\">Postgresql Jsonb course: Learn this powerful tool by examples. This course is designed as a reference for learning PostgreSQL JSONB and is suitable for people who want to improve their work in database development. We will thoroughly explore this powerful and often overlooked tool, the JSONB data type, using practical examples. When dealing with complex tables and columns that contain complex data types, the real use of the JSONB data type becomes apparent. In such cases, the traditional structure of columns is not effective and using JSONB is the best solution. In this course, we will learn the following:<\/span><\/p>\n<ol dir=\"ltr\" style=\"text-align: left\" data-sourcepos=\"13:1-18:0\">\n<li data-sourcepos=\"13:1-13:52\"><span style=\"vertical-align: inherit\">JSONB structure and how to populate a JSONB column with data<\/span><\/li>\n<li data-sourcepos=\"14:1-14:104\"><span style=\"vertical-align: inherit\">Types of operators, their uses, differences in their use in different queries and their specific uses.<\/span><\/li>\n<li data-sourcepos=\"15:1-15:69\"><span style=\"vertical-align: inherit\">How to run complex queries on columns with composite data types<\/span><\/li>\n<li data-sourcepos=\"16:1-16:106\"><span style=\"vertical-align: inherit\">How to implement different types of predefined PostgreSQL functions on JSONB columns (creating, testing and processing functions)<\/span><\/li>\n<li data-sourcepos=\"17:1-18:0\"><span style=\"vertical-align: inherit\">Learn powerful JSONB indexing that makes complex queries on complex data as simple as possible.<\/span><\/li>\n<\/ol>\n<p dir=\"ltr\" style=\"text-align: left\" data-sourcepos=\"19:1-19:185\"><span style=\"vertical-align: inherit\">By completing this course, you will realize the power of the JSONB data type in simplifying queries, query syntax, and reducing the number and size of columns that must be used in other tables.<\/span><\/p>\n<h3 class=\"\" dir=\"ltr\" style=\"text-align: left\" data-sourcepos=\"21:1-21:36\"><span style=\"vertical-align: inherit\">What you will learn in this course<\/span><\/h3>\n<ul dir=\"ltr\" style=\"text-align: left\" data-sourcepos=\"23:1-27:0\">\n<li data-sourcepos=\"23:1-23:56\"><span style=\"vertical-align: inherit\">Learn the actual use of the JSONB data type in complex tables<\/span><\/li>\n<li data-sourcepos=\"24:1-24:64\"><span style=\"vertical-align: inherit\">Query complex columns that contain complex data types<\/span><\/li>\n<li data-sourcepos=\"25:1-25:42\"><span style=\"vertical-align: inherit\">Easier query than traditional query<\/span><\/li>\n<li data-sourcepos=\"26:1-27:0\"><span style=\"vertical-align: inherit\">Minimizing the number of table columns<\/span><\/li>\n<\/ul>\n<h3 class=\"\" dir=\"ltr\" style=\"text-align: left\" data-sourcepos=\"28:1-28:37\"><span style=\"vertical-align: inherit\">Who is this course suitable for?<\/span><\/h3>\n<ul dir=\"ltr\" style=\"text-align: left\" data-sourcepos=\"30:1-31:0\">\n<li data-sourcepos=\"30:1-31:0\"><span style=\"vertical-align: inherit\">All PostgreSQL database developers<\/span><\/li>\n<\/ul>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Postgresql Jsonb course specifications: Learn this powerful tool by examples<\/span><\/h3>\n<ul dir=\"ltr\" style=\"text-align: left\">\n<li><span style=\"vertical-align: inherit\">Publisher:&nbsp; <\/span><a href=\"https:\/\/href.li\/?https:\/\/www.udemy.com\/course\/postgresql-jsonb-learn-this-powerful-tool-by-examples\/?couponCode=OF83024C\" target=\"_blank\" rel=\"noopener\"><span style=\"vertical-align: inherit\">Udemy<\/span><\/a><\/li>\n<li><span style=\"vertical-align: inherit\">Lecturer:&nbsp; <\/span><a class=\"ud-btn ud-btn-large ud-btn-link ud-heading-md ud-text-sm ud-instructor-links\" href=\"https:\/\/downloadlynet.ir\/tag\/mohammed-n-s-al-saadi\/\" data-position=\"1\"><span class=\"ud-btn-label\"><span style=\"vertical-align: inherit\">Mohammed NS Al Saadi<\/span><\/span><\/a><\/li>\n<li><span style=\"vertical-align: inherit\">Training level: beginner to advanced<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Training duration: 2 hours and 3 minutes<\/span><\/li>\n<li><span style=\"vertical-align: inherit\">Number of courses: 11<\/span><\/li>\n<\/ul>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Course headings<\/span><\/h3>\n<h3 dir=\"ltr\" style=\"text-align: left\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-931656 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2024\/09\/Postgresql-Jsonb-Learn-this-powerful-tool-by-examples-1.png\" alt=\"Postgresql Jsonb: Learn this powerful tool by examples\" width=\"884\" height=\"128\"><\/h3>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Postgresql Jsonb course prerequisites: Learn this powerful tool by examples<\/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\">\n<ul>\n<li class=\"ud-block-list-item-content\" dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Basic knowledge of Postgresql database<\/span><\/li>\n<\/ul>\n<\/div>\n<h3 dir=\"ltr\" style=\"text-align: left\"><span style=\"vertical-align: inherit\">Course images<\/span><\/h3>\n<h3 dir=\"ltr\" style=\"text-align: left\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-931657 size-full\" src=\"https:\/\/downloadly.ir\/wp-content\/uploads\/2024\/09\/Postgresql-Jsonb-Learn-this-powerful-tool-by-examples.png\" alt=\"Postgresql Jsonb: Learn this powerful tool by examples\" width=\"904\" height=\"390\"><\/h3>\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-140444-1\"><video class=\"wp-video-shortcode\" id=\"video-140444-1_html5\" width=\"640\" height=\"360\" preload=\"metadata\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Postgresql_Jsonb_Learn_this_powerful_tool_by_examples_Downloadly.ir.mp4?_=1\" style=\"width: 640px; height: 360px;\"><source type=\"video\/mp4\" src=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Postgresql_Jsonb_Learn_this_powerful_tool_by_examples_Downloadly.ir.mp4?_=1\"><a href=\"https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Postgresql_Jsonb_Learn_this_powerful_tool_by_examples_Downloadly.ir.mp4?nocache=1786105937481\">https:\/\/dl.downloadly.ir\/Files\/Elearning\/Sample\/Postgresql_Jsonb_Learn_this_powerful_tool_by_examples_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\">Subtitle: None<\/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:\/\/dl2.downloadly.ir\/Files\/Elearning\/Udemy_Postgresql_Jsonb_Learn_this_powerful_tool_by_examples_2024-8.part1_Downloadly.ir.rar?nocache=1786105936\"><span style=\"vertical-align: inherit\">Download part 1 \u2013 1 GB<\/span><\/a><\/p>\n<p dir=\"ltr\" style=\"text-align: left\"><a href=\"https:\/\/dl2.downloadly.ir\/Files\/Elearning\/Udemy_Postgresql_Jsonb_Learn_this_powerful_tool_by_examples_2024-8.part2_Downloadly.ir.rar?nocache=1786105936\"><span style=\"vertical-align: inherit\">Download part 2 \u2013 73 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\">1.07 GB<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Description Postgresql Jsonb course: Learn this powerful tool by examples. This course is designed as a reference for learning PostgreSQL JSONB and is suitable <\/p>\n","protected":false},"author":1,"template":"","dgi_category":[10458],"dgi_tag":[58064,58065,58066,58067,58068,58069],"class_list":["post-5996","digital_item","type-digital_item","status-publish","has-post-thumbnail","hentry","dgi_category-video-tutorials","dgi_tag-course-postgresql-jsonb-learn-this-powerful-tool-by-examples","dgi_tag-download-course-postgresql-jsonb-learn-this-powerful-tool-by-examples","dgi_tag-download-postgresql-jsonb-learn-this-powerful-tool-by-examples","dgi_tag-free-download-postgresql-jsonb-learn-this-powerful-tool-by-examples","dgi_tag-free-postgresql-jsonb-learn-this-powerful-tool-by-examples","dgi_tag-mohammed-n-s-al-saadi"],"_links":{"self":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/digital_item\/5996","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\/5996\/revisions"}],"wp:attachment":[{"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/media?parent=5996"}],"wp:term":[{"taxonomy":"dgi_category","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_category?post=5996"},{"taxonomy":"dgi_tag","embeddable":true,"href":"https:\/\/nokobox.com\/index.php\/wp-json\/wp\/v2\/dgi_tag?post=5996"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}