Skip to Main Content
Exploring Operational Property Graphs in Oracle Database 23ai Free

About This Workshop

Youtube Video

About This Workshop
This workshop focuses on working with Property Graphs in Oracle Database 23ai Free. You will create a graph from two tables, one containing bank account information, and another containing bank transactions information. You will then run graph pattern queries in SQL on this graph. You will find circular payment chains, multi-hop paths between accounts, and more.

In Oracle Database 23ai Free - Developer Release the GRAPH_TABLE function and MATCH clause of the new SQL:2023 standard enable you to write simple SQL queries to follow connections in data. This workshop illustrates how you can model your data as a graph and run graph queries in SQL to quickly see relationships in your data that are difficult to identify otherwise.

Workshop Info

45 minutes
  • Create a Property Graph from relational tables
  • Run graph pattern queries in SQL, using the new syntax from the SQL:2023 standard implemented in Oracle Database 23ai 
  • Familiarity with Database is desirable, but not required
  • Familiarity with SQL is helpful
  • Some understanding of cloud and database terms is helpful
  • Familiarity with Oracle Cloud Infrastructure (OCI) is helpful

Other Workshops you might like