lectures:
I. Introduction to DB
1. History of data bases;
2. DB management systems (DBMS);
3. Types of DBMS;
4. Roles in DB Management;
II. Describing, Storing and Querying data in DB
5. 3-tire data representation;
6. Data storing and indexing;
7. Formal query languages;
8. SQL basics;
9. QBE;
10. XML SUPB, XQuery;
III. DB design - basics
11. 3-level data modelling approach;
12. Conceptual data modelling;
13. Logical data modelling;
14. Normalisation - basics;
15. Physical data modelling.
16. Data warehouses and their design;
Optional: noSQL and newSQL basics