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.
- Oktató: Dr. Bán Miklós
