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
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 Modified data in Couch Base using nickel. My name is Keisha Year on. I will be your instructor for this course 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 DeutscheBank on Web MD in New York. I presently work for Loony Con, a studio for high quality video content. In this course, you look at different ways in which document data can be added to couch faith modified on also removed. Using the nickel query language, we begin by covering a different kind of statements with nickel provides in order to perform data modifications. We then delve into the youth off insert statement to add one or more documents to cut with buckets. We also examined the rule based access control feature off Coach bass, specifically the assignment of permissions to users so that they can draw on it. A modification queries from the audition off entire document. We then move on to how individual attributes can be added to modify or removed from existing documents. Using the update statement. We also cover the youth off up third statements, which are a combination off insert and updates. We also explore the youth off elite statements in order to remove documents which are no longer required. Finally, once we are familiar with different ways to modify data, we cover the Youth Off Mode statement to define which data needs to be added, modified or removed based on the reverse off a joint operation. Once you are done with this course, you will have the skills required to perform any kind of modification on your couch based document data using the nickel query language.