← All courses

PostgreSQL: from your first database to transactions

Run a PostgreSQL database the way it runs in production: roles, constraints, indexes, transactions, a trigger and a dump.

16 tasks · 2 questions
  1. PostgreSQL: create a databaseeasy
  2. PostgreSQL: role with a passwordmedium
  3. PostgreSQL: table with constraintsmedium
  4. PostgreSQL: INSERT and SELECTmedium
  5. PostgreSQL: INNER JOINmedium
  6. PostgreSQL: GROUP BY and HAVINGmedium
  7. PostgreSQL: create an indexeasy
  8. PostgreSQL: RANK window functionmedium
  9. PostgreSQL: CTE (WITH)medium
  10. PostgreSQL: view (VIEW)medium
  11. PostgreSQL: foreign key with CASCADEmedium
  12. PostgreSQL: seq scan → index scanmedium
  13. Why a database needs indexesinterview questionmedium
  14. PostgreSQL: transferring money in a transactionmedium
  15. Transactions and ACIDinterview questionmedium
  16. PostgreSQL: audit triggerhard
  17. PostgreSQL: read-only userhard
  18. PostgreSQL: dump and restoremedium