← All courses

Databases in an evening: SQLite, PostgreSQL, Redis

Try three popular databases in one evening: tables and queries in SQLite and PostgreSQL, keys, queues and TTLs in Redis.

17 tasks
  1. SQLite: a book catalog in one fileeasy
  2. SQLite: how many pages in the catalogeasy
  3. SQLite: update the dataeasy
  4. SQLite: create an indexeasy
  5. SQLite: join the tablesmedium
  6. Your first PostgreSQL databaseeasy
  7. A reader for the library databasemedium
  8. Book catalog: INSERT and SELECTmedium
  9. Books and authors with a JOINmedium
  10. Dump a PostgreSQL databasemedium
  11. Redis with a passwordmedium
  12. Redis: key with TTLeasy
  13. A counter with INCRBYeasy
  14. Redis: visit countereasy
  15. Redis: a queue with a listeasy
  16. Redis: profile in a hasheasy
  17. Delete keys by patternmedium