Query Data from Couchbase Using N1QL

This course is an introduction to the N1QL query language, and covers several ways in which it can be used to retrieve and manipulate data stored in the form of JSON documents in a Couchbase database.
Course info
Level
Beginner
Updated
Jan 30, 2020
Duration
3h 44m
Table of contents
Course Overview
Getting Started with Queries
Selecting and Filtering Query Results
Indexing and Shaping Query Results
Invoking Functions in Queries
Performing Conditional Operations in Queries
Description
Course info
Level
Beginner
Updated
Jan 30, 2020
Duration
3h 44m
Description

Couchbase is a document-oriented database which has its own query language, called N1QL to view and manipulate data. In this course, Query Data from Couchbase Using N1QL, you will get some hand-on experience in writing N1QL queries whose syntax is similar to SQL but is meant to work with JSON documents. First, you will explore how documents can be searched using the Couchbase web UI and how this interface allows you to define filters based on 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. Finally, you will discover how to work with data at a document level, and also perform aggregate operations using the GROUP BY and HAVING clauses. You will then gain an understanding on the use of built-in functions in N1QL, the building of indexes and the use of conditional operators such as the CASE statement. Once you finish this course, you will have a broad understanding of the capabilities of Couchbase and N1QL and can run a variety of queries on your document data.

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 who every data from Couch base using nickel. My name is fish in iron and I will be your instructor for the scores. 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 Deutsche Bank on Web MD. In New York. I presently work for Loony Gone, a studio for high quality video content. Vouch with is a document oriented database, which has its own query, language fall and one jewel or nickel, and this can be used to view and manipulate data. In this course, you will get some hands on experience in writing. Nickel queries for syntax is similar to sequel. What is meant to work with Jason documents. First, you will explore how documents can be searched using the power based Web you I and how this interface allows you to define filters based on a document key and also on the values off its attributes. Next, you would cover some of the basics of wedding in the nickel language, such a select from and where clauses. And we'll also take a brief look at adding an updating documents using insert and update queries beyond working with data at a document level. The also perform aggregate operations using the group by on having closes. We then explore the use off built in functions and nickel building off indexes on the use of conditional operators such as the statement. Once you're finished, of course, you will have a broad understanding off the capabilities off couch based on nickel and can run a variety of query on your document data.