Industrial Engineering and Management
COMPUTER AIDED ENGINEERING
Description
Laboratory
4
Instructors
João Pinho
Contents
CP1. DATABASE MANAGEMENT SYSTEMS
1.1 Entity-Relationship Model.
1.3 Relational Model
1.3 Standardization
1.4 SQL programming language
1.5 Integration with Python
CP2. BUSINESS INTELLIGENCE TOOLS
2.1 Creation of Data Access Interfaces
2.2 Data Access Objects
2.3 VBA programming
CP3. AUTOMAÇÃO DE PROCESSOS
3.1 Introduction to Process Automation
3.2 Workflows
3.3 Integration of services (connectors)
Learning Outcomes
The purpose of this Curricular Unit is to provide students with skills that allow:
- Use relational modeling methodologies to develop data structures.
- Use the SQL language to create, change and query relational databases.
- SQL integration with Python.
- Analyze databases to extract information and build relevant indicators
- Create database access interfaces.
- Use VBA programming to enhance interfaces.
- Use Power Automate to automate processes and workflows
This Curricular Unit aims to provide students with skills that allow responding to the needs of companies to carry out the transition from the product design phase to the production adequacy phase. The purpose of this curricular unit is to provide students with skills that allow:
OB1: Use methodologies for modeling data structures to analyze information management problems in order to develop appropriate databases.
OB2: Analyze various data sources to obtain relevant information and indicators.
OB3: Create database access interfaces to simplify user interaction and create more efficient information flows.
OB4: Analisar fluxos de trabalho e automatizar processos digitais.