1. Contents
  2. Information
  3. Contact
  4. Acknowledgement

Contents

Week Dates Theory Class Practical Class
1 15-20 Sept. Course Presentation: Introduction to the web and databases
UML Class Diagrams: Classes and Associations

Slides: Presentation | UML Class Diagrams
No practical class
2 23-27 Sept. Relational Model: Relations, tuples, attributes and constraints. Conversion from the UML model.
Slides: Relational Model
Entity Relationship
Exercises
3 29 Sept-5 Oct. SQL: Table creation. Data types and constraints. SQLite.
Slides: SQL Definition
Relational Model
Exercises | Delivery Project Topics and Group Formation
4 6-12 Oct. SQL: Database queries. Selecting, filtering, set operations and joins.
Slides: SQL Query
SQL
Exercises
5 13-19 Oct. SQL: Inserting, deleting and updating
Slides: SQL Manipulation
SQL
Exercises
6 20-26 Oct. HTML 5: Introduction, basic tags, tables, text formatting, common attributes and generic blocks. Forms, the semantic web, metadata and media tags.
Slides: HTML 5
SQL
Exercises
7 27 Oct.-2 Nov. No classes (FEUP Week)  
8 3-9 Nov. CSS 3: Introduction, basic selectors, properties. Positioning, specificity, inheritance.CSS 3
Slides: CSS 3
HTML Exercises | Delivery UML and Relational Model for the Project
9 10-16 Nov. PHP: Variables, loops, arrays and functions. Receiving values from HTML pages. Classes and objects. Database connections.
Slides: PHP

Examples: HTML & CSS | Listing
CSS Exercises | Solutions
10 17-23 Nov. PHP: Code organization, forms, actions and register.

Examples: Organization & Register
Project Information
Accessing the Server
11 24-30 Nov. PHP: Error handling and file uploads
Examples: Login, Logout and Shopping Cart
Project
12 1-7 Dec. PHP Examples

Examples: Messages, Search and Pagination
Project
13 8-14 Dec. PHP Examples
Examples: Orders
Project
14 15-20 Dec. Q&A (preparation for the final exam) Delivery Project Presentation

Information

Contact

Institutional e-mail: jrsilva@fe.up.pt

If you have any questions or doubts, you can find me on Fridays from 5pm to 6pm at the I123 Laboratory, Department of Informatics Engineering.

Student/Worker students are encouraged to visit and present the progress of their work and the practice exercises that they should do at home.

Acknowledgement

Prof. André Restivo is the original author of many of the materials made available at this website.