Filter Data from Couchbase Using N1QL

This course covers the searching of documents in Couchbase using the N1QL query language. There is a focus on defining filters based on the document attributes, whether they are primitive types such as numbers or complex data such as arrays.
Course info
Level
Beginner
Updated
Dec 31, 2019
Duration
3h 15m
Table of contents
Description
Course info
Level
Beginner
Updated
Dec 31, 2019
Duration
3h 15m
Description

There are a variety of ways to filter queries in Couchbase. In this course, Filter Data from Couchbase Using N1QL, you will get some hands on experience in writing queries to retrieve documents from a Couchbase database using filters you have defined. These queries will be written in the N1QL query language which has a SQL-like syntax to work with JSON data.

First, you will explore how documents can be searched using the Couchbase web UI and how this interface allows you to define filters based a document key and also on the values of its attributes.

Next, you will cover some of the basics of querying in the N1QL query language - such as the SELECT, FROM and WHERE clauses of a N1QL query - and will also take a brief look at adding and updating documents using INSERT and UPDATE queries. Then, you will move on to the filtering of documents based on the values of their attributes using a variety of comparison operators.

Finally, you will delve into filtering documents based on the contents of nested structures such as arrays and objects. This includes the use of collection operators, invoking built-in array functions and also generating slices of arrays.

By the end of this course, you will have the skills required to run a variety of filter queries on the data you have stored in a Couchbase database.

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. Filter data from Cloud Base using nickel. My name is Kishan. Iron on. I will be your instructor for the course a little about my fell first. I have a master's degree in computer science from Columbia University. On have previously worked in companies such as _______ Ban on Web MD in New York. I presently work for Louis Kahn, a studio for high quality video content. In discourse, you will get some hands on experience in right enquiries to retrieve documents from a couch Baystate ofhis Using filters, which you have to find thief squares will be returning the end one Q l or Nickel query language, which has a sequel like Syntax in orderto work with Jason Data. First, you will explore how documents can be searched using the couch based Web You I and how this interfaith I love you to define filters aged on a document and also on the values off its attributes. Next, you will cover some of the basics off wearing in the nickel pretty language, such as select from and where clauses. And we'll also take a brief look at adding on updating documents using insert and update Berries. You will then move on to the filtering off documents based on the values of the attributes using a variety of comparative and operators. Finally, you will delve into filtering document based on the content off nested structures such as Paris and objects. This includes the U, the election operator. Invoking building are a function on also generating slices off. By the end of this course, you will have the skills required to run a variety of filter queries on the data you have stored in a couch based database.