Databases
Objectives
- Understanding the mission and goals of a database system within an organization.
- Acquiring knowledge and expertise to characterize, design, and implement a relational database system.
- Applying data modeling techniques in the development of schemas for database systems, according to the types of data representation adopted.
- Acquiring knowledge to know how to manage and apply data security, recovery, and privacy models in data systems.
- Use SQL in description, manipulation and administration of relational database systems.
- Understanding how to collect and store data from different sources of information.
- Implement transactions.
Program
- Introduction to Database Systems.
- Database Management Systems.
- Databases Development.
- The development process.
- Requirements elicitation and analysis.
- Modelling and implementation of databases.
- Relational Databases.
- The relational model and relational algebra.
- The SQL language.
- Transactions and concurrency.
- Security and data recovery.
- Performance monitoring.
- Applications and Tools.
Bibliography
- Belo, O., “Bases de Dados Relacionais: Implementação com MySQL”, FCA - Editora de Informática, 376p, Set 2021. ISBN: 978-972-722-921-5.
- Connolly, T., Begg, C., Database Systems, A Practical Approach to Design, Implementation, and Management , Addison-Wesley, 4ª Edição, 2004. ISBN-10: 0321210255. ISBN-13: 978-0321210258.
- Garcia-Molina, H., Ullman, J., Widom, J., Database Systems: The Complete Book, Prentice Hall, 2a Edição, 2008. ISBN-10: 0131873253. ISBN-13: 978-0131873254.
- Ramakrishman, R., Database Management Systems, McGraw-Hill Higher Education; 3a Edição, 2002. ISBN-10: 0071230572. ISBN-13: 978-0071230575.
- G. Harrison, Next Generation Databases: NoSQLand Big Data, 1st Edition, Apress, 2015.
- Gouveia, F., “Fundamentos de Bases de Dados”, FCA, 2014.