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 0m
- Prerequisites and Course Outline 3m
- Introduction to Document-oriented Databases 4m
- The Couchbase Architecture 9m
- Demo: Couchbase Installation 5m
- Demo: Setting up a Couchbase Cluster 2m
- Demo: Exploring the Web UI 4m
- Demo: The Couchbase Documents Interface 7m
- Demo: The Document Types 4m
- Demo: Searching for Documents 4m
- Demo: Creating a Bucket 4m
- The SELECT, FROM, and WHERE Clauses 6m
- Demo: An Introduction to N1QL 8m
- Demo: The ALL, DISTINCT, and RAW Operators 3m
- Demo: The SELECT Clause 4m
- Demo: The WHERE Clause 7m
- Demo: The Query Plan 4m
- Demo: The CBQ Shell 7m
- Demo: Inserting Documents 7m
- Demo: Accessing Nested Properties 3m
- Demo: Updating and Deleting Documents 5m