Filter Data from Couchbase Using N1QL

By Kishan Iyer
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.
Play course overview
Course info
Level
Beginner
Updated
Dec 31, 2019
Duration
3h 15m
Table of contents
Course Overview
Course Overview 2m
Performing Filter Queries Using the Web Interface
Prerequisites and Course Outline 3m Introducing Document-oriented Databases 5m Introducing Couchbase 7m Installing Couchbase 3m Setting up a Couchbase Cluster 5m Searching for Documents in a Bucket 6m Filtering Documents from the Documents Interface 6m Editing Documents 7m
Getting Started with N1QL Filter Queries
Basic N1QL Queries 8m The CBQ Shell 3m Creating a Bucket 2m Inserting Documents Into a Bucket 7m Updating and Deleting Documents 3m The USE KEYS Clause 5m Modifying the SELECT Clause with DISTINCT and RAW 7m The ORDER BY Clause 4m An Overview of Query Plans 4m The WHERE Clause 5m An Introduction to Subqueries 5m
Filtering Documents with N1QL
Demo: Null, Missing, and Valued Fields 7m Demo: Equality Operators 3m Demo: Greater Than and Less Than Operators 8m Demo: The BETWEEN Operator 4m Demo: Multiple WHERE Clauses 5m Demo: The NOT Operator 7m Demo: The LET Clause 6m
Filtering Nested Structures and Collections with N1QL
Data Types in Couchbase 3m Demo: An Introduction to Arrays 5m Demo: Working with Objects 6m Demo: Arrays of Objects in N1QL 6m Demo: The ANY Operator 6m Demo: The EVERY Operator 6m Demo: The ARRAY Operator 6m Demo: The FIRST Operator 4m Demo: The WITHIN Operator 5m Demo: Array Slicing 5m Demo: Array Funtions 6m
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
Kishan Iyer
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 on. Welcome to this course IFilter data from Couchbase using nickel. My name is Kishan Ire and I will be your instructor for the course a little about myself First, I have a masters degree in computer science from Columbia University and have previously worked in companies such as Deutsche Bank on WebMD in New York. I presently work for Looney Con, a studio for high quality video content. In this course, you will get some hands on experience in writing queries to retreat document from a Couchbase database using filters which you have defined. These queries will be written in the n one QL or nickel query language, which has a SQL like syntax in order 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, Azure going to document key and also on the values off its attributes. Next, you will cover some of the basics off squaring in the nickel query language such as the select from and where clauses and will also take a brief look at adding and updating documents using insert and update queries. You will then move on to the filtering off documents based on the values off the attributes using a variety of comparison operators. Finally, you will delve into filtering documents based on the contents off nested structures such as a race on objects. This includes the use off collection operators in working building array functions and also generating slices off a raise. By the end of this coast, you will have the skills required to run a variety of filter queries on the data you have stored in a Couchbase database.

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT