Learn about Oracle and Couchbase aggregation, filtering, and join capabilities. Explore how to implement an ANSI join for JSON, and how to join JSON documents using N1QL.
- [Instructor] Unlike some NoSQL systems, … which provide, maybe, some pieces of SQL-like functionality … alongside a variety of vendor-specific query APIs, … our goal is to fully embrace the power of SQL. … Let's look a bit further into how we're doing. … Couchbase aggregation works just like SQL, … group by selected fields, and use relevant functions … and expressions to count, sum, et cetera. … Ordering also works just like SQL, … remembering that instead of like-type documents … can be thought of like a table, … select an order by any desired field, or fields, … in ascending or descending order. … Couchbase paging works analogously to Oracle, … assign offsets and limits to select desired result pages. … And we support NC-compliant joins … for data models, where it makes more sense to reference data … in remote documents rather than embedded. … Couchbase 6.x and beyond, support inner, left outer … and right outer joins, we do not however, … support full outer or lateral joins, yet. …
This course was created by Couchbase Learning Services. We are honored to host this training in our library.