This course aims to have an introductory to relational databases with emphasis on building complex schemas and queries. It prepares data scientists for the effective development of database applications. The course presents the fundamental features of current database architectures, with a specific emphasis on (i) the entity-relationship model, (ii) the relational model, (iii) Advanced SQL and Database application development. The course will also illustrate the main directions in the evolution of database systems in the area of Big Data.
Brief description of topics to be covered
- Introduction to Databases
- Conceptual design
- Relational Model
- SQL Languages (SQL)
- Data Warehousing
- Big Data (overview)
- Data Analytics
- Application Development
Lecture/consultation: Wednesday 10.15 - 12.00 Delta - 2034
Some lectures content will be recorded and posted online.
Every week: Thursday 14.15 - 16.00 Delta - 1022