Postgresql Jsonb : Learn this powerful tool by examples

Name: Postgresql Jsonb : Learn this powerful tool by examples
Rating: 4.7 (4 reviews)

Learn the Postgresql Jsonb in-depth

Created byMohammed N.S. Al Saadi

Last updated 8/2024

English

What you'll learn

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

Course content

1 section • 11 lectures • 2h 3m total length

Introduction7:21
An introduction to the Jsonb structure
2 Jsonb populate data structure6:09
How to understand the structure of the Jsonb column and how to populate the Jsonb column with data.
3 Jsonb Operators part-112:25
An important subject to learn is the operators before you can use the SQL queries on a Jsonb column.
The operators comes on different types and can be used in deferent ways.
4 Jsonb Operators part_23:40
An important subject to learn is the operators before you can use the SQL queries on a Jsonb column.

The operators comes on different types and can be used in deferent ways.
5 Jsonb SELECT query23:19
Types and how to use the SQL SELECT query on a Jsonb column, different results with different syntaxes applied on the query.
6 Jsonb SELECT query with JOIN9:54
When we have multiple tables that have Jsonb columns , we can use the SQL SELECT query on both columns using the JOIN .
7 Jsonb UPDATE query12:19
Types and how to use the SQL UPDATE query on a Jsonb column, different results with different syntaxes applied on the query.
8 Jsonb Functions14:15
How to apply pre-prepared Postgresql functions on a Jsonb column.
9 Jsonb add ROW function5:31
Adding a full ROW that contains a Jsonb column to a table using a pre-prepared function
10 Jsonb with Indexes19:33
We learn which types of Postgresql indexes can be applied on a Jsonb column and which indexe's operators can be used to improve the query performance of a table.
11 Jsonb SUBSCRIPTING8:54
the easiest syntax to perform SELECT or UPDATE queries on a Jsonb column

Requirements

Basic knowledge of Postgresql database

Description

A reference course to learn the powerful Postgresql Jsonb ..for those who wish to improve their work in database development.

An in-depth, by examples ,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.

In this course we will get to know the:

1- Build of a jsonb structure and the way to populate the Jsonb column with data. .

2- The operators types , their uses, differences of their use on different queries, and their uses.

3- How to run complex queries on columns with composite types.

4- How to run different types of Postgresql pre-prepared functions on jsonb columns(creation, testing and processing functions).

5- Then we learn the powerful jsonb subscripting , 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.

Thank you.

Who this course is for:

all Postgresql database developers