Description
Course info
Level
Advanced
Updated
Mar 2, 2020
Duration
2h 22m
Description

Are you looking for different ways to alter document data in Couchbase? In this course, Modify Data in Couchbase Using N1QL, we look at different ways in which document data can be added to Couchbase, modified, and also removed using the N1QL query language. First, you will cover the different kinds of statements which N1QL provides in order to perform data modifications. You then delve into the use of INSERT statements to add one or more documents to Couchbase buckets and examine the role-based access control feature of Couchbase, specifically, the assignment of permissions to users to run N1QL queries performing INSERT operations. Next, with the addition of entire documents, you will discover how individual attributes can be added to, modified or removed from existing documents using the UPDATE statement. You will also cover the use of UPSERT statements which are a combination of INSERT and UPDATE statements. You will also explore the use of DELETE statements in order to remove documents which are no longer required. Finally, once you are familiar familiar with different ways to modify data, you will cover the use of MERGE statements to define which data needs to be added, modified or removed based on the results of a join operation. Once you are done with this course, you will have the skills required to perform any kind of data modification on your Couchbase document data using the N1QL query language.

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
More courses by Kishan Iyer
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
Hi, and welcome to this course, Modify Data in 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. In this course, we look at different ways in which document data can be added to Couchbase, modified, and also removed using the N1QL query language. We begin by covering the different kinds of statements which N1QL provides in order to perform data modifications. We then delve into the use of insert statements to add one or more documents to Couchbase buckets. We also examine the role‑based access control feature of Couchbase, specifically the assignment of permissions to users so that they can run data modification queries. From the addition of entire documents, we then move on to how individual attributes can be added to, modified, or removed from existing documents using the UPDATE statement. We also cover the use of UPSERT statements, which are a combination of insert and updates. We also explore the use of DELETE statements in order to remove documents which are no longer required. Finally, once we are familiar with the different ways to modify data, we cover the use of MERGE statement to define which data needs to be added, modified, or removed based on the results of a JOIN operation. Once you are done with this course, you will have the skills required to perform any kind of modification on your Couchbase document data using the N1QL query language.