Bi5447 Database Systems in Biomedicine

Faculty of Science
Autumn 2020
Extent and Intensity
1/1/0. 2 credit(s) (fasci plus compl plus > 4). Type of Completion: zk (examination).
Taught online.
Teacher(s)
RNDr. Daniel Klimeš, Ph.D. (lecturer)
Guaranteed by
prof. RNDr. Ladislav Dušek, Ph.D.
RECETOX – Faculty of Science
Contact Person: RNDr. Daniel Klimeš, Ph.D.
Supplier department: RECETOX – Faculty of Science
Timetable
Wed 11:00–12:50 D29/347-RCX2
Prerequisites
basic knowledge of work on PC is the only requirement
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
fields of study / plans the course is directly associated with
Course objectives
Course participants will be able to:
Install database server (Postgresql);
Log into the ORACLE database by means of a database client;
Understand the basic terminology of relational databases and storing data in database tables;
Know basic data types of attributes that are used in relational databases;
Read schematic representation of data model, understand the issues of data modeling;
Use SQL to view and to determine the structure and contents of database tables;
Use SQL to insert, update and delete records in a database;
Use basic SQL operators and functions;
Acquire data by joining multiple tables;
Transfer data between databases and other software
Load data from a text file into a database
Create and run a SQL script;
Create a simple user procedure and function;
Use SQL to extract a specific information from a XML document;
Use SQL and a regular expression to extract a specific information from a text information;
Learning outcomes
Course participants will be able to:
Understand the basic terminology of relational databases and storing data in database tables;
Know basic data types of attributes that are used in relational databases and can read schematic representation of data model
Use SQL to view and to determine the structure and contents of database tables;
Use SQL to insert, update and delete records in a database;
Use basic SQL operators and functions;
Transfer data between databases and other software and load data from a text file into a database
Create a simple user procedure and function;
Use SQL to extract a specific information from a XML document;
Use SQL and a regular expression to extract a specific information from a text information;
Syllabus
  • Introduction into work with database
  • SQL basics
  • SQL functions and operators
  • Advanced SQL, nested SQL, work with multiple tables
  • Optimization of SQL queries and communication with other software
  • Data import
  • Analytical and statistical functions in SQL
  • SQL scripts, user procedures and functions
  • XML basics and XML processing in a relational database
  • Work with text, regular expressions
Literature
  • SOLAŘ, Tomáš. Oracle Database 11g : hotová řešení. Online. Vyd. 1. Brno: Computer Press, 2010. 288 s. ISBN 9788025128862. [citováno 2024-04-24] info
  • MOLINARO, Anthony. SQL : kuchařka programátora. Online. Vyd. 1. Brno: Computer Press, 2009. 573 s. ISBN 9788025126172. [citováno 2024-04-24] info
Teaching methods
Presentations in Microsoft Teams.
Assessment methods
A student will obtain his/her credit after doing a homework in the field of SQL and work with database. The examination will be performed by means of a test, which will consist in creating SQL queries similar to those practised in preceding lessons.
Language of instruction
Czech
Further comments (probably available only in Czech)
Study Materials
The course is taught annually.
The course is also listed under the following terms Autumn 2011, Autumn 2011 - acreditation, Autumn 2012, Autumn 2013, Autumn 2014, Autumn 2015, Autumn 2016, autumn 2017, Autumn 2018, Autumn 2019, Spring 2021, Spring 2022.
  • Enrolment Statistics (Autumn 2020, recent)
  • Permalink: https://is.muni.cz/course/sci/autumn2020/Bi5447