JSON vs JSONB: Understanding the Difference
+15 Mana
JSON vs JSONB: Understanding the Difference
+15 Mana
Creating and Storing JSON Data
+15 Mana
Creating and Storing JSON Data
+15 Mana
JSON Type Selection(Sign in required)
Beginner+10 Mana
JSON Validation and Type Checking
+15 Mana
Building JSON Objects(Sign in required)
Beginner+10 Mana
JSON Type Selection(Sign in required)
Beginner+10 Mana
JSON Build Function(Sign in required)
Beginner+10 Mana
JSON Type Characteristics(Sign in required)
Beginner+10 Mana
JSON Extraction Operators
+15 Mana
JSON Extraction Operators
+15 Mana
Containment and Existence Operators
+15 Mana
Containment and Existence Operators
+15 Mana
JSON Path Expressions
+15 Mana
JSON Path Expressions
+15 Mana
JSON Extraction Operators(Sign in required)
Intermediate+10 Mana
JSON Extraction Operators(Sign in required)
Intermediate+20 Mana
Containment Operator(Sign in required)
Intermediate+10 Mana
Containment Operator Usage(Sign in required)
Intermediate+20 Mana
JSON Path Expressions(Sign in required)
Intermediate+10 Mana
JSON Path Functions(Sign in required)
Intermediate+20 Mana
JSON_TABLE: Converting JSON to Relational Rows
+15 Mana
JSON_VALUE, JSON_QUERY, and JSON_EXISTS
+15 Mana
JSON_SERIALIZE, IS JSON, and JSON Constructor
+15 Mana
JSON_TABLE Column Extraction(Sign in required)
Intermediate+20 Mana
SQL/JSON Function Selection(Sign in required)
Intermediate+20 Mana
JSON_VALUE RETURNING Clause(Sign in required)
Intermediate+20 Mana
JSONPath Fundamentals
+15 Mana
JSONPath Fundamentals
+15 Mana
JSONPath Filter Expressions
+15 Mana
JSONPath Filter Expressions
+15 Mana
JSONPath Variables and Methods
+15 Mana
JSONPath Variables and Methods
+15 Mana
JSONPath Root Symbol(Sign in required)
Beginner+10 Mana
JSONPath Root Symbol(Sign in required)
Beginner+10 Mana
JSONPath Filter Symbol(Sign in required)
Intermediate+15 Mana
JSONPath Filter Symbol(Sign in required)
Beginner+10 Mana
JSONPath Function Return Types(Sign in required)
Intermediate+20 Mana
JSONPath Query Function(Sign in required)
Intermediate+15 Mana
Updating JSON with jsonb_set and jsonb_insert
+15 Mana
Updating JSON with jsonb_set and jsonb_insert
+15 Mana
PostgreSQL JSON: Concatenation (||) and Deletion (-) Operators
+15 Mana
Concatenation (||) and Deletion (-) Operators
+15 Mana
Cleaning JSON Data
+15 Mana
Cleaning JSON Data
+15 Mana
JSONB Set Function(Sign in required)
Intermediate+10 Mana
jsonb_set Update Statement(Sign in required)
Intermediate+20 Mana
JSONB Concatenation Behavior(Sign in required)
Intermediate+20 Mana
JSONB Concatenation(Sign in required)
Intermediate+10 Mana
Strip Nulls in Arrays (PG18)(Sign in required)
Advanced+30 Mana
GIN Indexes for JSONB
+15 Mana
GIN Indexes for JSONB
+15 Mana
Expression Indexes on JSON
+15 Mana
Expression Indexes on JSON
+15 Mana
GIN Operator Classes(Sign in required)
Intermediate+10 Mana
Combined Indexing Strategies
+15 Mana
Expression Index Usage(Sign in required)
Intermediate+10 Mana
GIN Operator Classes(Sign in required)
Intermediate+20 Mana
Index Type Selection(Sign in required)
Intermediate+20 Mana
Index Type for Query Pattern(Sign in required)
Intermediate+20 Mana
Hybrid Relational and Document Design
+15 Mana
Hybrid Relational and Document Design
+15 Mana
Converting JSON to Relational Tables
+15 Mana
Converting JSON to Relational Tables
+15 Mana
Generated Columns from JSON
+15 Mana
Generated Columns from JSON
+15 Mana
Hybrid Design Decision(Sign in required)
Intermediate+10 Mana
Hybrid Design Decision(Sign in required)
Intermediate+20 Mana
Generated Columns Benefits(Sign in required)
Intermediate+10 Mana
Data Storage Strategy(Sign in required)
Intermediate+20 Mana
Generated Columns Benefits(Sign in required)
Advanced+30 Mana
Ready to start PostgreSQL JSON & Document Processing?
37 interactive lessons and 35 hands-on challenges — learn in VS Code, Cursor, or the web.