SQL++ for JSON in Couchbase Masterclass Hands-On

Description

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 learn

• Everything 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 Couchbase

• Using 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 cases, to cover all you need to know about SQL++ for JSON.

• Each section ends-up with a short quiz, to test your acquired knowledge.

My credentials for this course

• Certified Professional Couchbase Developer – with popular practice tests on Udemy.

• Expert and heavily certified in many other NoSQL databases.

• Professional workplace experience with MongoDB JSON document stores since 2012.

• Expert in handling semi-structure JSON data from all sorts of databases, relational or NoSQL.

• World-class expert in Snowflake, former Data Superhero, SnowPro Subject Matter Expert

• Wrote in detail about JSON in Snowflake, in another course.

What is NOT included here

• Full preparation for any Couchbase certification exam.

• Couchbase internals and administration.

• Couchbase programming with REST APIs or SDKs.

• Using Couchbase from the command line.

• Data modeling in Couchbase.

• Couchbase programming in any other language but SQL++/N1QL (like Java, Python etc).

• Advanced features of Couchbase, in detail.

• Data import and export operations.

• Couchbase cost estimation and optimization.

• Couchbase features not generally available as a free trial.

• All sorts of deployments for a Couchbase cluster.

• Specialized editions such as Capella Columnar, Couchbase Mobile, or Couchbase for Kubernetes.

• How to use Visual Studio Code (VSCode) or Jupyter Notebooks.

• How to use the Couchbase web UI interfaces.

Enroll today, and learn how to master the SQL++ (former N1QL) language to query JSON in Couchbase!

If the coupon is not opening, disable Adblock, or try another browser.