Charles Explorer logo
🇬🇧

Introduction to relation databases

Class at Faculty of Arts |
AISV5907

Annotation

The course gives a basic orientation in the domain of databases.

Aimed at students of the 2nd year of the combined follow-up study.

- Relational database overview

- Base relational database objects: database, table, column, key, foreign key

- Database actions: queries, data modification

- Illustrated on examples in LibreOffice Base, the free database tool

- Database implementation variants: desktop databases, database servers, database clusters, cloud databases, embedded databases

- Database administration basics, esp. backing-up and restoration

- Transactions: handling concurrent access to the same data

- Access rights to data in databases

- A short overview of current trends in databases