SQL++ for JSON in Couchbase Masterclass Hands-On
About this course
Couchbase is a popular JSON document store used by powerful clients like PayPal, Walmart, Verizon, Cisco, UPS, Equifax etc. Unlike other similar NoSQL products - like MongoDB or CouchDB - in Couchbase you can query the stored or on-the-fly JSON data through an exciting SQL extension called SQL++ (former N1QL).What you will learnEverything about their SQL++ language, rebranded after the former N1QL.Join hierarchical data with SQL++ in all sorts of ways, including nesting and unnesting.Aggregate directly data from nested arrays, without "flattening" their elements first.Filter and transform directly data from nested arrays, without "flattening".Create, modify and delete top JSON documents, from Couchbase collections.Update directly internal JSON properties, objects and arrays, without unnesting their structure first.Properly use the tricky UPSERT and MERGE operations.Use recursive Common Table Expressions, with the RECURSIVE WITH clause.All individual object and array built-in functions.Create and use indexes, to optimize the query performance.Short presentation of the available Couchbase professional certifications.Why my course is better to learn CouchbaseUsing practical focused hands-on experiments, with short well-structured slides.Most exercises use a small amount of data, to help you better understand the operations on data.Many exercises use on-the-fly JSON data, to keep it simple and focused on joining and aggregating the data.Usage of the Jupyter Notebook-based Couchbase plugin, in Visual Studio Code.Avoiding the formal but heavy Backus-Naur notation from the Couchbase documentation.Fast-paced, with small but practical use ca
62/100
CourseAsk score
- What the provider tells you
- 38/45
- Who stands behind it
- 8/35
- How complete the listing is
- 16/20
Scores how much the provider publishes and who stands behind it — not how well it is taught.
What you'll learn
- Understand the SQL++ language and its operations
- Join and aggregate data from nested arrays without flattening
- Create, modify, and delete top-level JSON documents
- Perform UPSERT and MERGE operations correctly
- Use recursive Common Table Expressions with SQL++
- Create and manage indexes for query optimization
Price shown by Udemy — confirm on their site.
Enroll on UdemyYou'll be redirected to Udemy to complete enrollment.
- Listed & compared by CourseAsk
- English · 0
Udemy
Coursera
![[마이크임팩트 GMC] 결핍 없이 욕망할 수 있는가](https://i.udemycdn.com/course/480x270/4490290_0e54_3.jpg)
Compared on these lists
Where this course ranks against the alternatives.