Information Systems and Databases

LTW :: 2018/19 1st Semester

Contents

Week Theory Classes Practice Sessions
1 Course Presentation:First introduction to databases and the web.
Entity Relationship Model: Entities, attibutes and relationships.
2 Relational Model: Relations, tuples, attributes and constraints. Conversion from the entity-relationship model. Entity Relationship
Exercises
3 SQL: Table creation. Data types and constraints. PostgreSQL. Relational Model
Exercises
4 SQL: Database queries. Selecting, filtering, set operations and joins. SQL
Exercises
5 SQL: Inserting, deleting and updating SQL
Exercises
6 HTML 5: Introduction, basic tags, tables, text formatting, common attributes and generic blocks. Forms, the semantic web, metadata and media tags. SQL
Exercises
7 FEUP Week
8 CSS 3: Introduction, basic selectors, properties. Positioning, specificity, inheritance. HTML
Exercises | Solutions
9 PHP: Variables, loops, arrays and functions. Receiving values from HTML pages. Classes and objects. Database connections.
PHP
CSS
Exercises | Solutions
10 PHP: Forms, actions and authentication. Project Information
Accessing the Server
11 PHP: Error handling and file uploads Project
12 PHP Examples Project
13 SQL Triggers Project
14 Q&A (preparation for the final exam) Project Presentation

Information