SQL++ for JSON in Couchbase Masterclass Hands-On
Do you already have any background in SQL and relational databases? Here is your chance to learn fast how to query semi-structured hierarchical JSON data in a popular NoSQL data store!
Get my brand new high-quality 8-hours long “SQL++ for JSON in Couchbase Masterclass Hands-On” course on Udemy!
Table of contents below, followed by my promo clip (with transcript). Watch more free videos here, from the same course. And check my ongoing promotion for ALL my video courses on Udemy.
(1) SQL++ Fundamentals
- Scalar Types
- Object Type
- Array Type
- Object-Array Combinations
- JSON Path Expressions
- NULL and MISSING Values
- Conditional Operators
- JSON Validation
(2) SQL++ Scalar Functions
- Numeric Functions
- String Functions
- Date Functions
- Bitwise Functions
(3) SQL++ JSON Functions
- Object Accessors
- Object Mutators
- Array Accessors
- Array Aggregates
- Array Utilities
- Array Combinations
- Array Mutators
(4) Filtering Array Data with SQL++
- IN Tests
- EXISTS Tests
- Range Predicates
- Range Transformations
(5) JSON Documents in Couchbase
- Collections with UUIDs
- Collections from Scratch
- Replace Documents (with UPSERT)
- Collections with Sequences
- Insert or Update Documents (with UPSERT)
- DELETE Documents
- JSON Schema Inference (with INFER)
(6) Updating JSON Content in Couchbase
- SET Object Properties
- UPDATE Objects
- SET Array Elements
- UPDATE Arrays
- UPDATE Nested Arrays
- UNSET Data
- MERGE Data
(7) Grouping Data with SQL++
- Aggregate Rows
- Window Functions
- Aggregate Unnested Arrays
- Aggregate Nested Arrays
- GROUP AS Clause
- HAVING Clause
(8) Joining Data with SQL++
- Key Joins (ON KEYS/ON KEY-FOR)
- Inner Joins (INNER JOIN)
- Outer Joins (LEFT/RIGHT OUTER JOIN)
- Lateral Joins (LATERAL)
- Nest Joins (NEST)
- Set Operations
(9) Reused Functionality
- LET Clause
- LETTING Clause
- Subqueries
- CTEs (Common Table Expressions)
- Recursive CTEs
- Prepared Queries
- User-Defined Functions
(10) Query Optimizations
- EXPLAIN and ADVISE
- Primary Indexes
- Secondary Indexes
- Query Metadata
- Transactions
Promo Clip (with Transcript)
Welcome to “SQL++ for JSON in Couchbase”, an original and unique high-quality course about how to query semi-structured data in a popular NoSQL document store.
My name is Cristian Scutaru and I’m an experienced solutions architect and instructor, with strong technical background in many areas: in software development, big data and data science. NoSQL data stores was my passion a few years ago, and I passed many certification exams in Neo4J, Redis, Cassandra, and — of course — Couchbase. I’m still a Certified Developer in Couchbase. And I would like to teach you here, in the easiest way possible , how to use an exciting extension of SQL, to query JSON data in Couchbase in all possible ways.
Do it for yourself, do it for your career, do it for fun. Or to simply extend your knowledge, to learn something new, something related to your existing background in relational databases and SQL. Why Couchbase? Because it is the only popular JSON data store I know that can be queries not through procedural JavaScript — like MongoDB or CouchDB — but through declarative and rich SQL.
This is a totally hands-on course. I’ll use the free Visual Studio Code, with a Couchbase extension that allows us to run SQL code in Jupiter Notebooks. I’ll also help you create in just a few minutes a free trial account to the cloud version of Couchbase Server, called Couchbase Capella. You can use this account for free for almost two months. Or you can install locally the Community Edition, and use it forever, without paying a dime.
I designed this course for anyone with some experience in relational databases and SQL, who wants to know what NoSQL, and in particular JSON document stores, are all about. To apply their SQL skills in querying semi-structured data that is no longer stored in a tabular, but hierarchical manner.
The course will be yours for life, it comes with a one-month money-back guarantee, and I will personally answer your questions in one day max.
Enroll today, and learn how to query any kind of JSON data in Couchbase, through SQL!
