|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/postgresql-jsonb-learn-this-powerful-tool-by-examples/
课程评论：没有评论
Coursera 课程《PostgreSQL JSONB：通过示例学习这一强大工具》课程总结 本课程是一门旨在深入介绍 PostgreSQL 中 JSONB 数据类型的参考课程，特别适合希望提升数据库开发技能的学习者。课程通过大量示例，重点讲解了在处理包含复杂复合数据类型的复杂表时，JSONB 类型如何成为传统列构建方式的有力替代方案。 通过本课程，您将学习到： 1. **JSONB 结构构建与数据填充**：理解 JSONB 的基本结构，并掌握如何向 JSONB 列中填充数据。 2. **JSONB 操作符详解**：学习各种 JSONB 操作符的类型、用途，及其在不同查询中的差异和应用。 3. **复合类型列的复杂查询**：掌握如何在具有复合数据类型的列上执行复杂查询。 4. **PostgreSQL 内置函数在 JSONB 上的应用**：学习如何创建、测试和使用 PostgreSQL 预先准备好的函数处理 JSONB 列。 5. **JSONB 下标操作**：了解强大的 JSONB 下标功能，如何简化对复合类型列的复杂数据查询。 学完本课程后，您将深刻体会到 JSONB 类型在简化查询、优化查询语法以及减少数据库表中的列数量和大小方面的巨大优势。
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.
