Postgresql Jsonb : Learn this powerful tool by examples

[BaDshaH]

Published 8/2024
Created by Mohammed N.S. Al Saadi
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 11 Lectures ( 2h 3m ) | Size: 1.1 GB

Learn the Postgresql Jsonb in-depth

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

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

Homepage

[To see links please register or login]

[To see links please register or login]