SQL++ for JSON in Couchbase Masterclass Hands-On

SQL++ for JSON in Couchbase Masterclass Hands-On, available at $19.99, with 80 lectures, 10 quizzes, and has 100 subscribers.

You will learn about Query JSON Data in Couchbase the Easiest Way Possible The new SQL++ language in Couchbase, successor of N1QL Use SQL to query semi-structured hierarchical JSON data Learn about one of the most popular NoSQL JSON document stores This course is ideal for individuals who are SQL programmers willing to learn about using the same language for NoSQL data or Practitioners willing to learn quickly about Couchbase or Anyone struggling with learning how to query JSON data in Couchbase or Experts in relational databases willing to learn how to use SQL for JSON hierarchical data It is particularly useful for SQL programmers willing to learn about using the same language for NoSQL data or Practitioners willing to learn quickly about Couchbase or Anyone struggling with learning how to query JSON data in Couchbase or Experts in relational databases willing to learn how to use SQL for JSON hierarchical data.

Enroll now: SQL++ for JSON in Couchbase Masterclass Hands-On

Summary

Title: SQL++ for JSON in Couchbase Masterclass Hands-On

Price: $19.99

Number of Lectures: 80

Number of Quizzes: 10

Number of Published Lectures: 80

Number of Published Quizzes: 10

Number of Curriculum Items: 90

Number of Published Curriculum Objects: 90

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Query JSON Data in Couchbase the Easiest Way Possible

The new SQL++ language in Couchbase, successor of N1QL

Use SQL to query semi-structured hierarchical JSON data

Learn about one of the most popular NoSQL JSON document stores

Who Should Attend

SQL programmers willing to learn about using the same language for NoSQL data

Practitioners willing to learn quickly about Couchbase

Anyone struggling with learning how to query JSON data in Couchbase

Experts in relational databases willing to learn how to use SQL for JSON hierarchical data

Target Audiences

SQL programmers willing to learn about using the same language for NoSQL data

Practitioners willing to learn quickly about Couchbase

Anyone struggling with learning how to query JSON data in Couchbase

Experts in relational databases willing to learn how to use SQL for JSON hierarchical data

Couchbaseis 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!

Course Curriculum

Chapter 1: Introduction

Lecture 1: Welcome to this Course

Lecture 2: What is Couchbase

Lecture 3: Create a Free Couchbase Trial Account

Lecture 4: Install VSCode with the Couchbase Extension

Lecture 5: How to Benefit Most from this Course

Lecture 6: Frequently Asked Questions

Chapter 2: SQL++ Fundamentals

Lecture 1: Introduction to SQL++ Fundamentals

Lecture 2: Scalar Types

Lecture 3: Object Type

Lecture 4: Array Type

Lecture 5: Object-Array Combinations

Lecture 6: JSON Path Expressions

Lecture 7: NULL and MISSING Values

Lecture 8: Conditional Operators

Lecture 9: JSON Validation

Chapter 3: SQL++ Scalar Functions

Lecture 1: Introduction to SQL++ Scalar Functions

Lecture 2: Numeric Functions

Lecture 3: String Functions

Lecture 4: Date Functions

Lecture 5: Bitwise Functions

Chapter 4: SQL++ JSON Functions

Lecture 1: Introduction to SQL++ JSON Functions

Lecture 2: Object Accessors

Lecture 3: Object Mutators

Lecture 4: Array Accessors

Lecture 5: Array Aggregates

Lecture 6: Array Utilities

Lecture 7: Array Combinations

Lecture 8: Array Mutators

Chapter 5: Filtering Array Data with SQL++

Lecture 1: Introduction to Filtering Array Data with SQL++

Lecture 2: IN Tests

Lecture 3: EXISTS Tests

Lecture 4: Range Predicates

Lecture 5: Range Transformations

Chapter 6: JSON Documents in Couchbase

Lecture 1: Introduction to JSON Documents in Couchbase

Lecture 2: Collections with UUIDs

Lecture 3: Collections from Scratch

Lecture 4: Replace Documents (with UPSERT)

Lecture 5: Collections with Sequences

Lecture 6: Insert or Update Documents (with UPSERT)

Lecture 7: DELETE Documents

Lecture 8: JSON Schema Inference (with INFER)

Chapter 7: Updating JSON Content in Couchbase

Lecture 1: Introduction to Updating JSON Content in Couchbase

Lecture 2: SET Object Properties

Lecture 3: UPDATE Objects

Lecture 4: SET Array Elements

Lecture 5: UPDATE Arrays

Lecture 6: UPDATE Nested Arrays

Lecture 7: UNSET Data

Lecture 8: MERGE Data

Chapter 8: Grouping Data with SQL++

Lecture 1: Introduction to Grouping Data with SQL++

Lecture 2: Aggregate Rows

Lecture 3: Window Functions

Lecture 4: Aggregate Unnested Arrays

Lecture 5: Aggregate Nested Arrays

Lecture 6: GROUP AS Clause

Lecture 7: HAVING Clause

Chapter 9: Joining Data with SQL++

Lecture 1: Introduction to Joining Data with SQL++

Lecture 2: Key Joins (ON KEYS/ON KEY-FOR)

Lecture 3: Inner Joins (INNER JOIN)

Lecture 4: Outer Joins (LEFT/RIGHT OUTER JOIN)

Lecture 5: Lateral Joins (LATERAL)

Lecture 6: Nest Joins (NEST)

Lecture 7: Set Operations

Chapter 10: Reused Functionality

Lecture 1: Introduction to Reused Functionality

Lecture 2: LET Clause

Lecture 3: LETTING Clause

Lecture 4: Subqueries

Lecture 5: CTEs (Common Table Expressions)

Lecture 6: Recursive CTEs

Lecture 7: Prepared Queries

Lecture 8: User-Defined Functions

Chapter 11: Query Optimizations

Lecture 1: Introduction to Query Optimizations

Lecture 2: EXPLAIN and ADVISE

Lecture 3: Primary Indexes

Lecture 4: Secondary Indexes

Lecture 5: Query Metadata

Lecture 6: Transactions

Chapter 12: Wrapping Up

Lecture 1: Couchbase Certifications

Instructors

Cristian Scutaru
Snowflake Guru, AWS/Azure/GCP Solutions Architect

Rating Distribution

1 stars: 0 votes

2 stars: 0 votes

3 stars: 0 votes

4 stars: 0 votes

5 stars: 0 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!