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

Setting Up Automated Backups with pg_cron and cron on Linux
SQL SELF
44 level,0 lecture
Automating database backups is the key to peace of mind and keeping your data safe. In this article, you'll learn how to set up regular PostgreSQL backups using the pg_cron extension and the classic cron scheduler on Linux, plus get some tips on troubleshooting common mistakes.
Open
Data Integrity Check After Restore
SQL SELF
44 level,1 lecture
Learn how to properly check your data integrity after restoring a database: log analysis, using checksums, comparing data, and breaking down real-world errors. Practical tips for confident restores and avoiding data loss.
Open
Data Recovery After a Crash
SQL SELF
44 level,2 lecture
Learn how to properly recover your data in PostgreSQL after a crash: step-by-step guide, tips for checking backups, starting the server, and testing data integrity. Real-world examples of errors and how to fix them.
Open
Problems and Errors During Data Recovery
SQL SELF
44 level,3 lecture
Restoring data from backups is a crucial step in keeping your info safe, but even if you’ve got backups, you can still run into unexpected errors and lose data. On this page, you’ll learn about common issues when restoring PostgreSQL, ways to prevent them, and real-world cases that’ll help you dodge critical mistakes in the future.
Open
What to Do If Your Backup Gets Corrupted
SQL SELF
44 level,4 lecture
In this article, you'll learn what to do if your database backup turns out to be corrupted: how to try to recover your data, which tools to use, and how to prevent this kind of thing from happening in the future.
Open