SQL++ for JSON in Couchbase Masterclass Hands-On

Couchbase is a popular JSON document store used by powerful clients like PayPal, Walmart, Verizon, Cisco, UPS, Equifax etc. Unlike other similar NoSQL products - like MongoDB or CouchDB - in Couchbase you can query the stored or on-the-fly JSON data through an exciting SQL extension called SQL++ (former N1QL). What you will learnEverything about their SQL++ language, rebranded after the former N1QL.

Join hierarchical data with SQL++ in all sorts of ways, including nesting and unnesting. Aggregate directly data from nested arrays, without "flattening" their elements first. Filter and transform directly data from nested arrays, without "flattening".

Create, modify and delete top JSON documents, from Couchbase collections. Update directly internal JSON properties, objects and arrays, without unnesting their structure first. Properly use the tricky UPSERT and MERGE operations.

Use recursive Common Table Expressions, with the RECURSIVE WITH clause. All individual object and array built-in functions. Create and use indexes, to optimize the query performance.