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.
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.
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.