|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/json-in-snowflake/
课程评论：没有评论
课程名称：Snowflake中的JSON大师班 - 实践课程 课程概述：随着市场对于混合关系数据库和JSON扩展的需求日益增长，学习如何有效上传、查询和设计关系-层次数据库变得更加重要。本课程将帮助学员掌握在Snowflake中使用JSON的技巧，尤其是如何将JSON与表格数据结合使用。 学习内容： 1. 了解JSON作为数据存储格式的基本知识。 2. 学会在Snowflake中设计混合数据库，结合使用表格数据和JSON层次结构。 3. 掌握JSON中两个复杂结构的创建与操作：OBJECT字典和ARRAY列表。 4. 使用LATERAL FLATTEN，将数组元素和键值对展开为表格行。 5. 聚合键值或行元素为单一OBJECT或ARRAY值。 6. 创建各种简单到复杂的JSON数据查询。 7. 手动输入JSON数据到Snowflake表中。 8. 使用STRIP_OUTER_ARRAY选项将JSON文件上传到表中。 9. 将Snowflake表数据导出为JSON格式。 10. 在表格和层次结构之间切换以提取数据。 11. 使用JSON点表示法精确定位层次结构中的特定元素。 12. 解读系统函数返回的JSON数据或ACCOUNT_USAGE元数据。 13. 创建自定义JSON数据分析器和按需提取架构。 14. 以图形方式表示JSON层次结构。 15. 利用高阶函数、UDF或Snowpark DataFrame进行JSON转换。 16. 在Snowflake中查找JSONPath等效查询。 17. 在关系与层次表示之间转置数据。 18. 将JSON转换为JSON或其他层次格式，如YAML和XML。 讲师介绍：讲师是2021年唯一被选为Snowflake数据超级英雄计划的加拿大世界级专家。拥有SnowPro认证专家（SME）资质，并参与多个SnowPro考试题目的创建。至今已通过五次SnowPro认证考试，均为首次尝试成功。还是Couchbase开发认证专业人士，专精于使用SQL查询其JSON文档存储。同时拥有自2012年以来与MongoDB等多种NoSQL数据库的专业工作经验。 现在就报名，学习如何在Snowflake中掌握JSON的所有知识！
There is a growing demand on the market today to build and query hybrid relational databases, enhanced with JSON extensions. We used to have separate NoSQL document stores, like MongoDB or Couchbase. But most relational database systems today - including Snowflake - added powerful data types and built-in functions to store and query JSON along tabular data, from SQL. Learn how to properly upload, query and design relational-hierarchical databases, as you will need them more and more in your professional career or your job! What you will learnAll you need to know about JSON used as a data storage format.How to design hybrid databases in Snowflake, using tabular data extended with JSON hierarchies.How to create and manipulate the two complex structures in JSON: OBJECT dictionaries and ARRAY lists.How to use LATERAL FLATTEN, to explode array elements and key-value pairs into tabular rows.How to aggregate key-values or row elements into single OBJECT or ARRAY values.How to create all sorts of simple to complex queries for JSON data in Snowflake.How to manually enter JSON data into Snowflake tables.How to upload JSON files into tables, using the STRIP_OUTER_ARRAY option.How to unload Snowflake table data into a JSON format.How to switch between tabular and hierarchical topologies, to extract data.How to use the JSON dot notation, to locate specific elements in the hierarchy.How to interpret JSON data returned by system functions or as ACCOUNT_USAGE metadata.How to create custom JSON data profilers and schema on-read extractors.How to represent in a graphical manner JSON hierarchies.How to perform JSON transformations with higher-order functions, UDFs or with Snowpark DataFrame.How to find JSONPath equivalent queries in Snowflake.How to transpose data between relational and hierarchical representations.How to convert JSON to JSON, or other hierarchical formats, like YAML and XML.My credentials for this courseThe only world-class expert from Canada selected for their Snowflake Data Superhero program in 2021.SnowPro Certification SME (Subject Matter Expert) - I helped create many SnowPro exam questions.Passed five SnowPro certification exams to date, all on the first attempt.Certified Professional Couchbase Developer - in querying their JSON document stores using SQL.Expert in many NoSQL databases, including MongoDB and Couchbase JSON document stores.Professional workplace experience with MongoDB NoSQL JSON document stores since 2012.Enroll today, and learn how to master everything JSON in Snowflake!
