Books & Videos

Table of Contents

Chapter: Introduction

Welcome To The Course

04m 7s

About The Author

01m 5s

How To Access Your Working Files

01m 15s

Chapter: JSON And Relational Data And SQL

Introducing Relational Data

02m 35s

Introducing JSON Data

03m 4s

Course Example Data

02m 23s

Introducing Relational SQL

04m 27s

Introducing JSON SQL

03m 24s

Chapter: JSON Dot Notation

Introduction To Dot Notation

03m 4s

Query With Dot Notation

06m 32s

Explain Plan For Dot Notation Queries

03m 1s

Comparison To Relational Queries

02m 54s

Chapter: JSON Conditions

Strict JSON

02m 52s

Unique JSON

02m 26s

Is_JSON Constraint

05m 41s

Comparison To Relational Data

02m 26s

Chapter: JSON_Exists Function

Introduction To JSON_Exists

02m 4s

SQL Where Clause

01m 10s

Error Clauses

02m 22s

Explain Plan

01m 8s

Comparison To Relational

01m 42s

JSON_Exists Values

01m 47s

JSON_Exists Passing Clause

01m 54s

Chapter: JSON_Value Function

Introduction To JSON_Value

02m 1s

Error Clauses

02m 27s

Returning Clause

02m 10s

On Empty Clause

02m 26s

Explain Plan

01m 1s

Comparison To Relational

02m 2s

Chapter: JSON SQL Deep Dive

Deep Dive Introduction

02m 6s

Columns Clause

03m 4s

Return Value

02m 36s

Return JSON

02m 50s

Error Clause

05m 41s

Columns In Where Clause

03m 4s

Wrappers

03m 31s

Nested Rows

03m 17s

Array Values

03m 16s

Explain Plan

04m 36s

Chapter: JSON_Query Function

Introducing JSON_Query

02m 49s

Returning Clause

02m 2s

Wrappers

03m 21s

Error Clauses

01m 48s

Explain Plan

01m 33s

Comparison To Relational

02m 20s

Chapter: JSON_Table Function

Introduction To JSON_Table

03m 40s

Columns Clause

04m 16s

Error Clause

03m 32s

JSON Format

01m 22s

Wrappers

01m 39s

Nested Values

03m 4s

Mix And Match Data

01m 53s

Explain Plan

03m 50s

Comparison To Relational

01m 53s

Chapter: JSON Indexes

Introduction To Indexes

02m 10s

Relational Indexes

01m 47s

JSON Indexes

06m 0s

Explain Plan

04m 8s

Chapter: Errors Clause

Introduction To Errors Clause

02m 27s

Available Error Clauses

02m 36s

Interaction With SQL Errors

02m 8s

Advice For Error Clauses

02m 57s

Chapter: Combining JSON And Relational Data

Queries With Both JSON And Relational Data

04m 47s

Oracle Views

04m 21s

Chapter: Conclusion

Wrap Up And Thank You

00m 46s