SQL++ for JSON in Couchbase Masterclass Hands-On

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!