-
Course
- Data
Query Data from Couchbase 6 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.
What you'll learn
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.
Table of contents
- Version Check | 15s
- Prerequisites and Course Outline | 2m 53s
- Introduction to Document-oriented Databases | 4m 25s
- The Couchbase Architecture | 8m 31s
- Demo: Couchbase Installation | 5m 4s
- Demo: Setting up a Couchbase Cluster | 2m 3s
- Demo: Exploring the Web UI | 3m 52s
- Demo: The Couchbase Documents Interface | 7m 16s
- Demo: The Document Types | 3m 33s
- Demo: Searching for Documents | 3m 43s
- Demo: Creating a Bucket | 4m 28s
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 Courses by Kishan