See a comparison of basic SQL to N1QL operations the survey tools available for N1QL query execution. View how to create, read, update, and delete a document using N1QL in Couchbase Query Builder.
that N1QL is SQL for JSON. … In this lesson, you'll see just how true this is. … A N1QL query looks very much like a SQL query. … The difference is you are querying document fields … within a bucket instead of columns in a table. … You have all the filtering power you expect from SQL, … along with aggregations, functions, subqueries, and more, … as well as new behaviors specific to JSON, … Give me three specific fields for my customer documents, … where year to date sales are filtered within a range, … then order the results by name. … Of course, while ad-hoc querying is supported, … as with any database, … you'll want to create appropriate indexes … to optimize the speed of commonly used queries. … As you can see, the way you do so is easy and familiar, … at least to anybody used to working with SQL. … The resulting indexes are maintained, … lock-free and in-memory if you choose, by the index service. … You can easily review the state and definition … of all current indexes from the indexes view …
This course was created by Couchbase Learning Services. We are honored to host this training in our library.