Overview
Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!
Explore the integration of property graphs with SQL in this 31-minute conference talk from CloudWorld 2022. Discover how the new SQL/PGQ extension enables developers to create and query property graphs using familiar SQL tools, making it easier to leverage relationship-based information in data. Learn to solve problems involving reachability and connectivity without specialized tools through code examples demonstrating graph creation from relational tables and querying in Oracle Autonomous Database. Gain insights into the advantages of property graphs over relational models, explore new use cases across multiple domains, and understand Oracle's graph support. Follow along as the speaker demonstrates the syntax for creating property graphs, using graph table operators, and executing graph queries. Witness a real-life example of utilizing graphs on top of relational data and building an Apex application with graph functionality. Enhance your understanding of how graphs function as SQL objects and expand your database development skills with this informative presentation.
Syllabus
Introduction
Connections are everywhere
Graph is an important trend
What are property graphs
Property graphs vs relational models
New use cases
Multiple domains
Why graph
Oracle graph support
What are SQL property graphs
Create property graph syntax
Explicit property graph syntax
Graph table operator
Graph query example
Real life example
Using graphs on top of relational data
Querying with graphs
Graphs are SQL objects
How to build an Apex application
Summary
Taught by
Oracle