Duration
10h Th, 20h Mon. WS
Number of credits
| Master in bio-informatics and modelling, research focus | 3 crédits |
Lecturer
Language(s) of instruction
English language
Organisation and examination
Teaching in the first semester, review in January
Schedule
Units courses prerequisite and corequisite
Prerequisite or corequisite units are presented within each program
Learning unit contents
This course teaches the creation and use of relational databases, in the context of bioinformatics applications.
Databases & SQL
1. General concepts and benefits of structuring data
2. Database structure modelling
- The Entity-Association Model
- The relational model
- Normalization
- Generation of a relational diagram
- From the model to the physical structure, the Data Definition Language (DDL)
- Manipulate and query the database, the Data Modification Language (DML)
- Simple queries
- Complex queries
Learning outcomes of the learning unit
The aim of this course is to enable students to understand, organise and query complex and massive data. At the end of this course, students will have acquired the basic skills needed to design relational databases and write SQL language queries to manipulate these databases and extract information from them.
Prerequisite knowledge and skills
This course requires no prior knowledge in computer programming, but it is nevertheless based on the introduction to the Linux environment and the command line [INFO0960] of the Master BBMC and Master BIM.
Planned learning activities and teaching methods
- brief theoretical lectures
- challenges to solve
- computer practicals
- self-learning (textbooks and online tutorials)
Mode of delivery (face to face, distance learning, hybrid learning)
This course is mostly face-to-face but as a problem-oriented course, it will require that students work also outside of the classroom.
Course materials and recommended or required readings
Platform(s) used for course materials:
- eCampus
Exam(s) in session
Any session
- In-person
written exam ( open-ended questions )
Further information:
The evaluation will consist of the realization of an integrative problem. The exam will be open book.
Work placement(s)
Organisational remarks and main changes to the course
WARNING: Each M-BIM student must have a laptop on which one can install the Linux operating system (e.g., Ubuntu LTS). Virtual machines running in VirtualBox are not adequate solutions, but WSL2 on a recent version of Windows is possible, as is dual-boot with Windows.
https://ubuntu.com/tutorials/install-ubuntu-on-wsl2-on-windows-11-with-gui-support
Contacts
Dr. Pierre Tocquin
Institut de Botanique B22 (P70)
ptocquin@uliege.be