European Union Portugal 2020 - Agriculture and Rural Development Foundation for Science and Technology European University Foundation
Suggestions, Compliments, Complaints Terms & Conditions of Use Projects Co-financed by the European Union
©2026 Instituto Politécnico de Coimbra. Todos os direitos reservados.

Search

Architecture and Administration of Database Management Systems

Home / Oferta Formativa / Coimbra Institute of Engineering / Bachelor / Bachelor in Informatics Engineering (Evening Classes)

Base Knowledge

SQL

ER model

Teaching Methodologies

TheoreticaI cIasses:

Exposition of the subjects foIIowed by exercises resoIving

PracticaI cIasses:
Exercises soIving in the computer using exercises sheets and practicaI work support.

Students have at their disposaI in MoodIe pIatform aII the information, bibIiography and exercise sheets. 

Learning Results

  • Be able to know how to use advanced database normalization.
  • Be able to develop applications using database server-side programming.
  • Be able to know how to administrate a database management system.
  • Be able to justify the solutions proposed at the level of database administration.
  • Be able to identify the concepts related to tuning of relational databases.
  • Be able to make appropriate documentation about database administration.
  • Be able to identify the concepts related with parallel and distributed databases.
  • Be able to justify the solutions proposed at the level of database project.
  • Be able to make presentations and explain the developed projects in a clear way.
  • Be able to evaluate solutions used in databases, showing critical attitude.
  • Be able to develop innovative projects, with a high degree of autonomy, where they are limited to apply the concepts learned in the classes.

Program

PL/SQL programming language.
Oracle Server architecture.
Database administration.
Backup and recovery.
Security.
Advanced normalization.
Parallel and Distributed databases.
Tuning.

Curricular Unit Teachers

João Pedro Matos da Costa

Internship(s)

NAO

Bibliography

Bibliography available in the library:

  • Rodrigues, António (2005), Oracle 10g e 9i : fundamentos para profissionais. Lisboa : FCA – Editora de Informática, cop. 2005. 403 p.. ISBN 972-722-344-3, 1A-5-136 (ISEC) – 13413
  • Owens, Kevin (2004), Programming Oracle triggers and stored procedures. 3rd ed. Upper Saddle River, NJ : Prentice-Hall PTR, cop. 2004. 411 p. ISBN 0-13-085033-0, 1A-5-133 (ISEC) – 12945
  • Abbey, Michael ; Corey, Michael J. ; Abramson, Ian (2002), Oracle 9i : a beginner’s guide. New York [etc.] : McGraw-Hill/Osborne, cop. 2002. 515 p. ISBN 0-07-219279-8, 1A-5-132 (ISEC) – 12842
  • Niemiec, Richard J. (2003), Oracle 9i performance tuning : tips & techniques. New York [etc.] : McGraw-Hill/Osborne, cop. 2003. 823 p.. ISBN 0-07-222473-8, 1A-5-121 (ISEC) – 12751
  • Damas, Luís Manuel Dias (2005), SQL : Structured Query Language. 10ª ed. Lisboa : FCA – Editora de Informática, cop. 2005. 418 p.. ISBN 978-972-722-443-2, 1A-5-151 (ISEC) – 14623
  • Date, C. J.(2004), An introduction to database systems. 8th ed.. International ed. Boston [etc.] : Pearson/Addison-Wesley, cop. 2004. 938 p.. ISBN 0-321-18956-6, 1A-5-120 (ISEC) – 12657
  • Elmasri, Ramez ; Navathe, Sham (2004), Fundamentals of database systems. 4th ed.. International ed. Boston [etc.] : Pearson/Addison Wesley, cop. 2004. 1030 p.. ISBN 0-321-20448-4, 1A-5-119 (ISEC) – 12656
  • Ramakrishnan, Raghu ; Gehrke, Johannes (2003),Database management systems. 3rd ed. Boston [etc.] : McGraw-Hill, cop. 2003. 1065 p.. ISBN 0-07-246563-8, 1A-5-118 (ISEC) – 12655
  • Campos, Luís Moreno (1999), Oracle 8i : curso completo. Lisboa : FCA – Editora de Informática, 1999. 940 p.. ISBN 972-722-160-2, 1A-5-86 (ISEC) – 10703
  • Urman, Scott – Programação em Oracle 8 PL/SQL. Lisboa [etc.] : McGraw-Hill, 1999. 986 p.. ISBN 972-773-022-1, 1A-5-85 (ISEC) – 10704
  • Koch, George (1990), Oracle : the complete reference. Berkeley : Mcgraw-Hill, 1990. 1045 p., 1A-5-29 (ISEC) – 05886

Additional bibliography: 

  • Costa, João (2026), Slides and nodes of Arquitetura e Administração de Bases de Dados,  available at http://moodle.isec.pt
  • Oracle Database 11gR2 – Database Concepts https://docs.oracle.com/cd/E11882_01/server.112/e40540/toc.htm
  • Oracle Database 11gR2 – Database Administrator’s Guide https://docs.oracle.com/cd/E11882_01/server.112/e25494/toc.htm
  • Oracle Database 11gR2 – PL/SQL Language Reference https://docs.oracle.com/cd/E11882_01/appdev.112/e25519/toc.htm
  • CONNOLLY, Thomas M., BEGG, Carolyn E. (2015), Database Systems: A Practical Approach to Design, Implementation and Management, Pearson Education Limited 2015
  • ELMASRI, R.; NAVATHE, S.B. (2016), Fundamentals of Database Systems, Global Edition, Addison-Wesley Publishing, Pearson Education Limited, 2016