How to practice with transactions and locks?

Question

Database

I study the database from a book, where there is a lot of theory, but little practice. If I understand data integrity, then transactions and locks - no: How to make a series of parallel transactions that will be executed at the same time? How can you track the progress of transactions?

Answer 1

1. create tables, add data to them and practice querying them.
2. write a script that will do it.
3. depends on subd. usually it's all in the logs.