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

Using RETURNING to Get Data After Insert/Update
SQL SELF
22 level,0 lecture
Learn how to use the RETURNING command in SQL to instantly grab data after INSERT, UPDATE, and DELETE operations. This makes working with your database way easier and helps you avoid extra queries!
Open
Intro to Transactions: BEGIN, COMMIT, ROLLBACK
SQL SELF
22 level,1 lecture
Find out what transactions are in databases, why you need the BEGIN, COMMIT and ROLLBACK commands, how they keep your data reliable and consistent, and how to use them the right way in real life.
Open
Working with Transactions to Keep Your Data Consistent
SQL SELF
22 level,2 lecture
Learn how transactions help keep your data consistent in apps: ACID principles, usage examples, error handling, control with SAVEPOINT, and common mistakes when working with transactions.
Open
Handling Errors When Inserting and Updating Data
SQL SELF
22 level,3 lecture
On this page, you'll learn about common mistakes when working with a PostgreSQL database: what to do when constraints are violated, how to use transactions to protect your data, plus how to prevent duplicates and handle errors using special SQL constructs.
Open
Typical Mistakes When Working With Data
SQL SELF
22 level,4 lecture
Working with databases is all about paying attention to details: even the tiniest mistake can lead to data loss or break data integrity. In this material, you'll learn about the most common mistakes when working with data, how to spot and prevent them, and get some practical tips for safe work with PostgreSQL.
Open