_____________________________________________________________________________________



Database

LOURDES MORENO LÓPEZ

PALOMA MARTÍNEZ FERNÁNDEZ
JOSÉ LUIS MARTÍNEZ FERNÁNDEZ
RODRIGO ALARCÓN GARCÍA

Department of Computer Science, Universidad Carlos III de Madrid

Area: Computer Science

Bachelor's degree in Data Science and Engineering,
Dual Bachelor in Data Science and Engineering and Telecommunication Technologies Engineering

July, 2023Share:    


12 theoretical sessions (2 hours per session).

8 exercises resolution sessions (2 hours per session).

9 lab demos sessions (2 hours per session).

Total learning time (class hours+homework hours): 150 hours.

 

PRERREQUISITES AND RECOMMENDED PREVIOUS KNOWLEDGE

Programing is recommended.

 

GENERAL DESCRIPTION OF THE COURSE

This course presents different resources to gain knowledge about information systems and databases, which includes acquiring knowledge of the data model as a design tool to create a database.

The process of designing the relational model is learned, and practical experience using data language (SQL) to create, develop and manipulate a database is acquired. In addition, management and use of the database technology using commercial  Database  Management Systems (DBMSs) are studied.

This course covers relational databases and the main fundamentals of current NoSQL databases. The experience in practical uses of a data language to create a NoSQL database is acquired. Finally, managing and using database technology using  commercial NoSQL-type DBMSs are studied.


OBJECTIVES: KNOWLEDGE AND SKILLS

The main objectives are:

  • Gain knowledge about information systems.
  • Acquire knowledge of the data model as a design tool to create a database.
  • Learn the process of designing using the relational model.
  • Acquire practical experience using data language (SQL) in order to create, develop and manipulate a database (DB).
  • Learn to manage and use database technology using a commercial DBMS.
  • Learn fundamentals of current NoSQL DBs. Learn NoSQL approaches types such as Aggregation Oriented Models and Graph Oriented Models.
  • Acquire knowledge in the design of NoSQL Databases with MongoDB.
  • Acquire knowledge in the design of NoSQL Databases with Neo4j.


TEACHING MATERIAL

For the theoretical part, slides of studied topics are included as well as recommended readings.

For the exercises part, exercises with the corresponding solutions are included.

Lab demo assignments are included with the corresponding possible solutions for the practical part.


 PRACTICAL ASSIGMENTS AND ASSESSMENT ACTIVITIES

Exams with the corresponding possible solutions are included.


Last modified: Tuesday, 18 July 2023, 12:15 PM