Poatgresql Jsonb Learn this powerful tool
postgresql jsonb
Updated on Jun, 2025
Language - English
Development ,Web Development,JavaScript
Lectures -11
Duration -2 hours
Lifetime Access
Lifetime Access
30-days Money-Back Guarantee
Get your team access to 10000+ top Tutorials Point courses anytime, anywhere.
Course Description
In this course chapters you will get to know the:
1- Build of a JSONB.
2- The operators used in queries, and their uses.
3- How to run complex queries on columns with composite types.
4- How to run different types of functions on JSONB columns(creation, testing and processing functions).
5- Then we learn the powerful JSONB subscribing, that will makes complex data queries of composite types columns.. as easy as possible.
Through this course you will notice the power of the Jsonb type both in simplifying the queries, the syntax of the queries and also to minimize the number and size of columns that should be used in other table.
Goals
An in-depth, by example, look to the forgotten powerful tool. The JSONB type,
We will learn 'Jsonb' type true usefulness when we have complex tables with complex columns that contains composite data types, where conventional build of columns is of no use , and use of 'Jsonb' is the solution.
learn 'Jsonb' type true usefulness when we have complex tables
Query complex columns that contains composite data types,
Easy querying than conventional querying
Minimizin the tables number of columns
Prerequisites
Basic knowledge of the Postgreqsl database.
Curriculum
Check out the detailed breakdown of what’s inside the course
Jsonb in depth
11 Lectures
-
1 Jsonb Introduction
07:21
07:21
-
2 Jsonb populate data structure
06:09
06:09
-
3 Jsonb Operators part-1
12:25
12:25
-
4 Jsonb Operators part_2
03:40
03:40
-
5 Jsonb SELECT query
23:19
23:19
-
6 Jsonb SELECT query with JOIN
09:54
09:54
-
7 Jsonb UPDATE query
12:19
12:19
-
8 Jsonb Functions
14:15
14:15
-
9 Jsonb add ROW function
05:31
05:31
-
10 Jsonb with Indexes
19:33
19:33
-
11 Jsonb SUBSCRIPTING
08:54
08:54
Instructor Details
Mohammed Al Saadi
1- My main field of expertise is the Postgresql Database , with 12 years of work .
2- Flutter apps development both U.I and back end.
3- Cloud Postgresql database with Supabase platform.
Course Certificate
Use your certificate to make a career change or to advance in your current career.
Our students work
with the Best
Related Video Courses
View MoreAnnual Membership
Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses
Subscribe now
Online Certifications
Master prominent technologies at full length and become a valued certified professional.
Explore Now