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

Working with JSON and JSONB
SQL SELF
33 level,0 lecture
Learn how to use the JSON and JSONB data types in PostgreSQL to store, search, and handle complex structured data. This article covers the differences between the formats, usage examples, and practical tips for picking the right type for your needs.
Open
Comparing JSON and JSONB: Pros and Cons of Each Format
SQL SELF
33 level,1 lecture
Find out what’s different between JSON and JSONB data storage formats in PostgreSQL, how they affect performance, indexing, and data processing, and when you should pick one or the other for your projects.
Open
Extracting Data from JSON Objects
SQL SELF
33 level,2 lecture
Learn how to pull data out of JSONB objects in PostgreSQL using operators and functions. Real-life examples, common mistakes, and tips for working with nested data structures.
Open
Extracting Nested Data: jsonb_to_recordset()
SQL SELF
33 level,3 lecture
Learn how to use the jsonb_to_recordset() function in PostgreSQL to turn arrays of JSONB objects into table rows for easy filtering, aggregation, and data analysis. Real-life examples, common mistakes, and tips for working with nested structures.
Open
Updating Data in JSON Objects Using jsonb_set() and jsonb_insert()
SQL SELF
33 level,4 lecture
Learn how to efficiently update and modify data inside JSONB objects in PostgreSQL using the jsonb_set() and jsonb_insert() functions. Real-life examples, common mistakes, and tips for working with nested structures.
Open