MSc in Computer and Telematics Engineering | University of Aveiro
pedrovt 2019
- Guide 01 : Configuring and testing Microsoft SQL Server, Microsoft SQL Server Management Studio and Microsoft Visual Studio.
- Guide 02 : Conceptual Drawing of Databases. Entity-Relationship diagrams.
- Guide 03 : Relational Model. Mapping of Entity-Relationship diagrams to the Relational Model.
- Guide 04 : SQL DDL to define tables, types and integrity restrictions.
- Guide 05 : Relational Algebra
- Guide 06 : SQL DML to insert, modify, delete and query data
- Guide 07 : Normalization in Relational Databases. Views in SQL.
- Guide 08 : Interface between Programs and Database
- Guide 09 : SQL Programming – Stored Procedure, User-Defined Function, Trigger and Cursor
- Guide 10 : Indexes for Relational Databases