From the course: Introduction to Couchbase

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

SQL and SQL++ and Indexing In Capella

SQL and SQL++ and Indexing In Capella - Couchbase Tutorial

From the course: Introduction to Couchbase

Start my 1-month free trial Buy for my team

SQL and SQL++ and Indexing In Capella

“

- [Instructor] If you are familiar with SQL, then you're familiar with Couchbase's SQL++, which you may have seen referred to as N1QL or nickel. So what is SQL++? Well, it used to have a different name. SQL++ is still the Couchbase query language that harnesses the power of SQL and the flexibility of JSON. SQL++ manipulates JSN documents in the same way that SQL manipulates data in relational databases. SQL++ extends SQL to handle nested data that is both schemaless and non-uniform and SQL++ handles data containing arrays and objects. Here you can see the side-by-side comparison, where the syntax and standards are nearly identical. There's only a small change in your from statement, so if you know SQL, then you know SQL++. Now we'll return to the Capella UI to see how easy it is to work with these statements in our query workbench. From our database dashboard, I'll click on my Cluster or Database name. Remember those two words are interchangeable, and then I'll click on Data Tools…

Contents