Postgresql Jsonb : Learn This Powerful Tool By Examples
Postgresql Jsonb : Learn This Powerful Tool By Examples
Published 8/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.25 GB | Duration: 2h 3m
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.
Overview
Section 1: Introduction
Lecture 1 Introduction
Lecture 2 2 Jsonb populate data structure
Lecture 3 3 Jsonb Operators part-1
Lecture 4 4 Jsonb Operators part_2
Lecture 5 5 Jsonb SELECT query
Lecture 6 6 Jsonb SELECT query with JOIN
Lecture 7 7 Jsonb UPDATE query
Lecture 8 8 Jsonb Functions
Lecture 9 9 Jsonb add ROW function
Lecture 10 10 Jsonb with Indexes
Lecture 11 11 Jsonb SUBSCRIPTING
all Postgresql database developers
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.
Overview
Section 1: Introduction
Lecture 1 Introduction
Lecture 2 2 Jsonb populate data structure
Lecture 3 3 Jsonb Operators part-1
Lecture 4 4 Jsonb Operators part_2
Lecture 5 5 Jsonb SELECT query
Lecture 6 6 Jsonb SELECT query with JOIN
Lecture 7 7 Jsonb UPDATE query
Lecture 8 8 Jsonb Functions
Lecture 9 9 Jsonb add ROW function
Lecture 10 10 Jsonb with Indexes
Lecture 11 11 Jsonb SUBSCRIPTING
all Postgresql database developers
