Combine and Aggregate Data from Couchbase 6 Using N1QL

Beyond that, you will discover some aggregate operations which can be performed in N1QL using the GROUP BY and HAVING clauses, and will use the LETTING keyword to declare variables which can be referenced in a HAVING clause

By the end of this course, you will have the skills required to run a variety of queries which can combine and aggregate data stored in documents

Finally, you will perform a few set operations in N1QL such as UNION, INTERSECT, and EXCEPT

First, you will explore how data from different related documents can be combined by performing a JOIN operation, and a variety of joins will be covered in the course including left and right joins

Learn about combining and aggregating data from multiple related documents using the N1QL query language? In this course, Combine and Aggregate Data from Couchbase Using N1QL, you will get some hands-on experience in writing queries which combine and aggr

These queries will be written in the N1QL query language which has a SQL-like syntax but is meant to work with JSON data

You will also get to combine a collection of matching documents into an array using the NEST operation and will also learn to unpack a nested array using UNNEST