Objective
The main objective of the course is to enable students learn modern data management techniques for relational and non-relational databases.
Topics taught include the relational data model, the extended entity – relationship model, database design and implementation, the SQL language, physical storage and query processing and optimization.
Emphasis is placed on understanding modern data management systems and on developing database applications in modern software platforms.
Distributed and parallel databases and modern non-relational systems for high performance and scalability are also discussed.
Through this course, students are expected to acquire significant technical skills in large-scale data management and to learn how to design and implement applications that manage massive amounts of structured, semi-structured and unstructured data.
After successfully completing the course, students will be able to:
- analyze a database design problem and gather requirements for implementing the database system
- design a database at a conceptual and logical level and create appropriate data models
- design and implement databases based on normalization rules
- know and use the appropriate tools for the design and implementation of a relational database
- implement SQL queries to define and manage databases
- design and implement a non-relational database
- evaluate and select the most appropriate data management system for a specific problem
Learning outcomes
- Search for, analysis and synthesis of data and information, with the use of the necessary technology
- Adapting to new situations
- Decision-making
- Working independently
- Production of new research ideas
- Project planning and management
- Criticism and self-criticism
- Working in an interdisciplinary environment
