From the course: Introduction to Couchbase
Join today to access over 25,500 courses taught by industry experts.
Identifying similarities between SQL and N1QL/SQL++. - Couchbase Tutorial
From the course: Introduction to Couchbase
Identifying similarities between SQL and N1QL/SQL++.
- [Instructor] If you're familiar with SQL or Sequel, you're familiar with Couchbase's SQL++, which you may have seen referred to as N1QL or Nickel. So what is SQL++? First and foremost, it's a query language that used to be called N1QL at Couchbase or non-first normal form query language and it was started in 2015. And now, N1QL is being rebranded to SQL++. SQL++ manipulates JSON documents the way SQL manipulates data in relational databases. SQL++ extends SQL to handle nested data that is schemeless and non-uniform and it also handles data containing arrays and objects. Looking here, you can see the syntax and standards are nearly identical. For example, your select, where and group by, as well as the other statements here are identical. There's only a small change in your from statement. So you can clearly see, if you know SQL, then you know SQL++. We'll now return to the Capella UI to work with these statements in…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.