DataBase Management Systems
Objectives
Introduce the fundamental concepts inherent to relational databases including data modeling - from the conceptual point of view and to a physical implementation, standardization, optimization of queries, data integrity and transaction management, aimed at supporting the development of transactional systems. This course places great emphasis on a theoretical framework coupled with the provision of an extensive practical experience grounded in the use of a relational Database Management System (DBMS) such as Microsoft SQL Server and data modeling tools such as SAP Power Designer. At the end of the course, participants will be able to use these skills to design, implement and query a database, packaging it with a layer of functional, integrity and security constraints.
General characterization
Code
200032
Credits
7.5
Responsible teacher
Hours
Weekly - Available soon
Total - Available soon
Teaching language
Portuguese. If there are Erasmus students, classes will be taught in English
Prerequisites
Basic knowledge of information systems.
Bibliography
Abraham Silberschatz, Henry F. Korth and S. Sudarshan, Database System Concepts - 7th ed., McGraw-hill, 2020
Teaching method
Teaching based on lectures and practical classes. The lectures are, in essence, for expository sessions, which
serve to introduce the fundamental concepts of databases associated with each of the topics. The practical
classes are based on design and implementation of database systems, using the computers and software
Teaching Methods
- Expository and interrogative teaching: lectures and discussions.
- Declarative: tutorials and self-learning tests.
- Active and participative: case studies, participation in project teams, use of database management systems
Evaluation method
1st Call: Exam (40%) + Final Project Deliverable 1 (20%) + Final Project Deliverable 2 (40%)
2nd Call: Exam (60%) + Final Project Deliverable 1 (15%) + Final Project Deliverable 2 (25%)
The final project doesn't have a minimum grade. Both exams (1st Call and 2nd Call) have a minimum
grade of 8.0.
Subject matter
CUC1. Introduction to DBMSs and to the Relational model
CUC2. Database Design
- Entity-Relationship modelling
CUC3. Overview of the SQL Language
- Data Definition Language
- Data Manipulation Language
CUC4. Intermediate SQL
- Implicit and explicit join expressions
- Aggregations
- Database modifications
- Database integrity
CUC5. Advanced SQL
- Views
- Stored Procedures and Functions
- Triggers
- Transactions and Indexes
Programs
Programs where the course is taught:
- Specialization in Risk Analysis and Management
- specialization in Information Systems - working hours
- Laboral - Data Science for Marketing
- PostGraduate in Data Analysis
- PostGraduate Risk Analysis and Management
- PostGraduate in Business Intelligence
- PostGraduate in Smart Cities
- Post-graduation in Geospatial Data Science
- PostGraduate Marketing Research e CRM
- PostGraduate in Information Management and Business Intelligence in Healthcare
- PostGraduate Information Systems Management
- PostGraduate in Enterprise Information Systems