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
Hi, and welcome to this course, Query Data from Couchbase using N1QL. My name is Kishan Iyer, and I will be your instructor for this course. A little about myself first. I have a Master's Degree in computer science from Columbia University and have previously worked in companies such as Deutsche Bank and WebMD in New York. I presently work for Loonycorn, a studio for high‑quality video content. Couchbase is a document‑oriented database, which has its own query language called N‑1‑Q‑L or N1QL. And this can be used to view and manipulate data. In this course, you will get some hands‑on experience in writing N1QL queries. The 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 language, such as SELECT, FROM, and WHERE clauses, and we'll also take a brief look at adding and updating documents using insert and update queries. Beyond working with data at the document level, we also performed aggregate operations using the GROUP BY and HAVING clauses. We then explore the use of built‑in functions in N1QL, the building of indexes, and the use of conditional operators such as a 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.