Udemy – Postgresql Jsonb : Learn this powerful tool by examples 2024-8

Description

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:

1. JSONB structure and how to populate a JSONB column with data
2. Types of operators, their uses, differences in their use in different queries and their specific uses.
3. How to run complex queries on columns with composite data types
4. How to implement different types of predefined PostgreSQL functions on JSONB columns (creating, testing and processing functions)
5. Learn powerful JSONB indexing that makes complex queries on complex data as simple as possible.

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.

What you will learn in this course

• Learn the actual use of the JSONB data type in complex tables
• Query complex columns that contain complex data types
• Easier query than traditional query
• Minimizing the number of table columns

Who is this course suitable for?

• All PostgreSQL database developers

Postgresql Jsonb course specifications: Learn this powerful tool by examples

• Publisher:  Udemy
• Lecturer:  Mohammed NS Al Saadi
• Training level: beginner to advanced
• Training duration: 2 hours and 3 minutes
• Number of courses: 11

Course headings

Postgresql Jsonb course prerequisites: Learn this powerful tool by examples

Course images

Sample video of the course

download link

Download part 1 – 1 GB

Download part 2 – 73 MB

File(s) password: www.downloadly.ir

File size

1.07 GB