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

Generating Unique Identifiers
SQL SELF
16 level,0 lecture
Learn how globally unique identifiers (UUID/GUID) work, why they're needed in distributed systems, how to use them in PostgreSQL, plus their pros and cons.
Open
Working with the JSONB Data Type
SQL SELF
16 level,1 lecture
Learn how to use the JSONB data type in PostgreSQL like a pro: its perks, examples of storing and grabbing semi-structured data, filtering, and best practices.
Open
Using Arrays (`ARRAY`)
SQL SELF
16 level,2 lecture
Learn how to use arrays (`ARRAY`) in PostgreSQL to store and handle lists of values in a single column. Examples, benefits, common mistakes, and basic array operations.
Open
Comparing and Converting Data Types
SQL SELF
16 level,3 lecture
Learn how to properly compare and convert data types in PostgreSQL: from numbers and strings to dates and booleans. Real-life examples, common mistakes, and best practices for safe data handling.
Open
Choosing the Right Data Types for Different Tasks
SQL SELF
16 level,4 lecture
Learn how to pick the right data types for different tasks in your database: financial calculations, storing strings, dates, unique identifiers, arrays, and complex structures. Practical examples and tips to optimize performance and make your data storage more reliable.
Open