The course aims to enable students to
        ◦ be able to manage PostgreSQL databases using database management client applications on their own
        ◦ learn the use of the SQL language
        ◦ be able to recognize the problems, that occur while using database management tools
        ◦ to be able to create databases, upload and query data on their own

 

Learning outcomes, competences: the student

Knowledge: 
- learns to use the PostgreSQL database management system
Ability:
- is able to manage databases using various database management client applications
Attitude:
- works in an environmentally aware way, favouring electronic storage and management methods, and develops
independent learning skills
Autonomy and responsibility:
- continuously develops his/her IT skills and knowledge, expands his knowledge in the field of databases and develops his self-checking skills

Course content, topics
SQL basics
PostgresSQL database management system
Database client applications: Linux command line, R, Perl, QGIS, Web applications (Adminer, PhpPgadmin,..)
Managing biological databases

Intended learning activities, teaching methods
Manage databases in a guided and autonomous way. Weekly homework assignments, in-class supervision and
consultation.

Evaluation
To receive a grade, attendance in class and submission of homework assignments by the deadline in moodle is
required.
Practical exam.