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

Diving Deeper into Transactions
SQL SELF
39 level,0 lecture
In this lecture, we're gonna take a closer look at how transactions work in PostgreSQL, break down their key properties (ACID), check out some real-life usage examples, and learn how to manage transactions using the main commands. You'll see why transactions are the backbone of reliability in modern databases.
Open
Basic Commands for Working with Transactions: BEGIN, COMMIT, ROLLBACK
SQL SELF
39 level,1 lecture
Learn how to use transactions in PostgreSQL to protect your data and keep it consistent. In this material, you'll get to know the BEGIN, COMMIT, and ROLLBACK commands, check out common mistakes, and get some practical tips for working with transactions.
Open
Using SAVEPOINT to Handle Partial Rollbacks in Transactions
SQL SELF
39 level,2 lecture
Learn how to use SAVEPOINT in PostgreSQL to create save points inside transactions, roll back just part of your changes, and handle tricky data scenarios like a pro. Real-world examples and tips for practical tasks.
Open
Example of Using Transactions in Real-World Scenarios
SQL SELF
39 level,3 lecture
Transactions are a reliable way to protect your data from mistakes and failures when running complex operations. In this lecture, you'll learn how to use transactions in practice: from transferring money between accounts to bulk updating orders and using SAVEPOINT for flexible change management.
Open
Intro to Transaction Isolation Levels
SQL SELF
39 level,4 lecture
Find out what transaction isolation levels are in PostgreSQL, what problems they solve, and how to pick the right level for your app. Simple examples and explanations for beginners and folks who want to get hands-on.
Open