Introduction to Databases

DataBase
Abstract

Database systems are used for storing and maintaining any sort of data, providing convenient access to them through efficient query processing.

This course aims to give fundamental knowledge about databases, with particular attention to relational models. Students will learn how to design a relational database, using established methods such as E/R diagrams, and implement them. In addition, this course will offer an extensive presentation of SQL query languages.

Teaching and Learning Methods:

Lectures (with in-class exercises) and individual practical labs.

Bibliography

 

During the course, we will cover several chapters in the textbook: "Database Management Systems", R. Ramakrishnan and J. Gehrke.

When needed, suggested books and/or research articles will be reported in class.

Requirements

Basic knowledge of maths, computer science and coding

Description

The course will cover the following topics:

 

  • Introduction to database systems
  • Database Design principles
  • E/R Diagrams
  • SQL language: instructions for querying the database
  • SQL language: instructions for creating and manipulating tables
  • Relational Design
  • Introduction to NoSQL databases

Learning outcomes:

  • Learn the fundamental aspects of database management systems
  • Obtain competencies in designing relational databases
  • Learn and practice SQL for querying databases

Hours:

Total

Lect.

Lab.

Prob.

Self.

Re. Self.

Perso.

21

18

3

0

0

0

0

Grading:

Assignments during the course (25%), final written exam (75%)