Combine and Aggregate Data from Couchbase Using N1QL

This course is about combining and aggregating data from multiple related documents using the N1QL query language. You will explore JOIN, NEST, as well as set operations such as UNION and INTERSECT, and aggregate similar documents using GROUP BY.
Course info
Level
Intermediate
Updated
Feb 8, 2020
Duration
3h 5m
Table of contents
Description
Course info
Level
Intermediate
Updated
Feb 8, 2020
Duration
3h 5m
Description

Want to 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 aggregate the contents of related documents. These queries will be written in the N1QL query language which has a SQL-like syntax but is meant to work with JSON data. 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. 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. 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. Finally, you will perform a few set operations in N1QL such as UNION, INTERSECT, and EXCEPT. 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.

About the author
About the author

An engineer at heart, I am drawn to any interesting technical topic. Big Data, ML and Cloud are presently my topics of interest.

More from the author
Design Data Models for Couchbase
Beginner
2h 7m
Sep 29, 2020
Recognize the Need for Document Databases
Beginner
1h 40m
Sep 18, 2020
Integrate Couchbase into Your Data Environment
Intermediate
2h 48m
Sep 15, 2020
More courses by Kishan Iyer
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] Hi and welcome to this course combine and aggregate data from Couch based Using Nickel. My name is Keisha Year, and I will be your instructor for the course just a little about myself First, I have a master's degree in computer science from Columbia University. On have previously worked in companies such as Deutsche Bank on Web MD. In New York. I presently work for Loony Gone, a studio for high quality video content. In Difficult, you will get some hands on experience in right enquiries, which combined and aggregate the contents off related documents. Thief queries will be written in the end one key well or nickel query language, which has a sequel like Finn ducks. But if meant to work with a phone like data first, you will explore how data from different related documents can be combined by performing a joint operation, and a variety of joints will be covered in this course, including left and right joints. You will also get to combine a collection off matching documents into an ari using the nest operation on will also learn toe unpack a nested away from a document you think a nest beyond duck, you will explore some aggregate operations, which can be performed in nickel. Using the proof by and having closes on, we'll use the letting key word to declare variables, which can be referenced in a having clothes. Finally, you will perform a few set operations in nickel that every union in effect and accept. By the end of the scores, you will have the skills required to run off variety of queries, which can combine, as well as aggregate data stored in couch based documents.