Database
Course introduction
_____________________________________________________________________________________
|
Database
LOURDES MORENO LÓPEZ
PALOMA MARTÍNEZ FERNÁNDEZ Department of Computer Science, Universidad Carlos III de Madrid Area: Computer Science Bachelor's degree in Data Science and Engineering, |
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.