Sumários

4 Outubro 2024, 09:00 • Jesualdo Fernandes

SQL:

Insert / update / delete statements

Select statement: queries from a single table with where and order by clauses

3 Outubro 2024, 12:00 • Jesualdo Fernandes

Introduction to SQL

Installation and configuration of the SQL client sw.

Creating tables: create the library schema

27 Setembro 2024, 09:00 • Jesualdo Fernandes

Modeling Exercise Project Planning: Class Diagram and Relational Schema.

26 Setembro 2024, 12:00 • Jesualdo Fernandes

Solved exercise Helpdesk: Class Diagram and Relational Schema

20 Setembro 2024, 09:00 • Jesualdo Fernandes

Data modeling exercises:

Library exercise Relational Schema and Logical Model

Helpdesk Exercise - students are to try the Class Diagram for home work. To be completed next class