Duration
30h Th
Number of credits
| Master in business engineering (120 ECTS) | 5 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
Introduction to database management systems and to data organization.
The focus of the course is first on:
- how and why structure large data sets,
- different data types and key attributes,
- how to conceive entity-relationship models,
- how to write basic and advanced queries in SQL
- how to apply the theoretical concepts in practice (MySQL DBMS)
- how to exploit a DBMS from an external application and especially from websites (through PhP)
Some other forms of DBMS and some related concepts are also introduced: noSQL database, blockchain and centralised immutable ledgers, atomicity and parallelism, data warehouse, ERP systems...
A large part of the course is dedicated to practice through examples and a project.
Learning outcomes of the learning unit
- Strategy: This course will help students to analyze a context and to identify data in order to solve a management problem with DBMS
- Strategy: Identification and appropriate use of knowledge, theoretical, methodological and technical tools
- Strategy: Proposal of a relevant strategy / action plan
- Implementation: Organization and adherence to planning
- Implementation: Consideration of the multidisciplinary dimension; especially management and digital questions
- Implementation: Appropriate use of analytical tools and data in implementation.
- Implementation: Ethical position in one's recommendations and practices
- Quality and Performance Control: Use of data and analytical tools for performance monitoring
- Quality and Performance Control: Proposal of ways of improvement based on the analysis of performance data
- Communication: Oral and written communication in a foreign language
- Communication: Taking into account multicultural dimensions in one's communications
- Adaptability: Scientific integrity and critical thinking
- Adaptability : Team spirit and taking responsibility
- Adaptability : Autonomy - entrepreneurial spirit
- Adaptability : Curiosity and creativity
Prerequisite knowledge and skills
Compulsory: - programming skills. - the course INFO0076 or courses with an equivalent content. (https://www.programmes.uliege.be/cocoon/20212022/cours/INFO0076-1.html)
Planned learning activities and teaching methods
Theory is immediately illustrated by small examples. Students perform exercises on computer during the lectures. The students work in group on a real life project.
Mode of delivery (face to face, distance learning, hybrid learning)
Face-to-face course
Additional information:
Face to face.
Recommended or required readings
Exam(s) in session
Any session
- In-person
oral exam
Written work / report
Additional information:
Group project.
Peer evaluation taken into account.
Oral defense.