This daylong workshop will feature a combination of lectures and hands-on lab trainings on N1QL from Couchbase. The N1QL query language supports the JSON data model with the familiar select-join-project operations of traditional SQL as well as array and object operations required for JSON. This workshop takes developers and architects under the hood of Couchbase Server to learn how to develop and deploy high-performance and scalable applications with N1QL. We will cover:
o Introduction to N1QL – motivation for SQL for JSON; N1QL language definition
o Architecture matters – N1QL execution and deployment
o Deep dive into data modeling – exploiting arrays and objects
o All about SELECT in N1QL – language and best practices
o Query optimization – access path selection in N1QL
– Indexing options in N1QL
– Query tuning – understanding the plan and query tuning
o Query monitoring, profiling, and troubleshooting
– N1QL Role-Based Access Control (RBAC)
– Accessing external data sources through the N1QL curl functions
Attendees should have basic knowledge of SQL.
Requirements: Please bring your laptop. If possible, set up Couchbase Server 5.0.0 Enterprise Edition in advance on your laptop.