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.
Course Overview [Autogenerated] Hi and welcome to this course who every data from Couch base using nickel. My name is fish in iron and I will be your instructor for the scores. 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 Deutsche Bank on Web MD. In New York. I presently work for Loony Gone, a studio for high quality video content. Vouch with is a document oriented database, which has its own query, language fall and one jewel or nickel, and this can be used to view and manipulate data. In this course, you will get some hands on experience in writing. Nickel queries for syntax is similar to sequel. What is meant to work with Jason documents. First, you will explore how documents can be searched using the power based Web you I and how this interface allows you to define filters based on a document key and also on the values off its attributes. Next, you would cover some of the basics of wedding in the nickel language, such a select from and where clauses. And we'll also take a brief look at adding an updating documents using insert and update queries beyond working with data at a document level. The also perform aggregate operations using the group by on having closes. We then explore the use off built in functions and nickel building off indexes on the use of conditional operators such as the statement. Once you're finished, of course, you will have a broad understanding off the capabilities off couch based on nickel and can run a variety of query on your document data.