List of lectures for the course SQL, 34 quest level on JavaRush

Merging and Modifying JSON Objects with the || Operator and the jsonb_concat() Function
SQL SELF
34 level,0 lecture
Learn how to merge and tweak JSONB objects and arrays in PostgreSQL using the || operator and the jsonb_concat() function. Real-life examples, gotchas, common mistakes, and tips for optimizing your JSONB queries.
Open
Indexing JSONB Data: Using GIN and BTREE Indexes
SQL SELF
34 level,1 lecture
Learn how to speed up searching in JSONB columns in PostgreSQL using GIN and BTREE indexes. This article explains the differences between these index types, gives examples of how to create and use them, and covers common mistakes when working with JSONB data.
Open
Examples of Advanced Queries with JSONB
SQL SELF
34 level,2 lecture
On this page, you'll learn how to run advanced queries on data stored in JSONB format in PostgreSQL. We'll cover filtering, sorting, grouping, and complex scenarios for working with JSONB using real-world online store examples.
Open
Comparing JSON with Other Types: ARRAY, TEXT, HSTORE
SQL SELF
34 level,3 lecture
Find out when to use JSON/JSONB, arrays, text fields, or HSTORE in PostgreSQL. Detailed comparison, usage examples, and tips on picking the best data type for your needs.
Open
Common Mistakes When Working with JSON Data and How to Avoid Them
SQL SELF
34 level,4 lecture
Check out the most common mistakes people make when working with JSON and JSONB in PostgreSQL, plus get some hands-on tips on how to dodge them. Learn how to boost performance and steer clear of gotchas when storing and handling JSON data.
Open