Contents
| Week | Theory Classes | Practice Sessions |
|---|---|---|
| 1 |
Course Presentation:First introduction to databases and the web.
Entity Relationship Model: Entities, attibutes and relationships. |
Entity Relationship Exercises |
| 2 | Relational Model: Relations, tuples, attributes and constraints. Conversion from the entity-relationship model. |
Relational Model Exercises |
| 3 | SQL: Table creation. Data types and constraints. PostgreSQL. |
SQL 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. |
HTML Exercises | Solutions |
| 7 | FEUP Week | |
| 8 | CSS 3: Introduction, basic selectors, properties. Positioning, specificity, inheritance. |
CSS Exercises | Solutions |
| 9 | PHP: Variables, loops, arrays and functions. Receiving values from HTML pages. Classes and objects. Database connections. |
Project Information
Accessing the Server |
| 10 | PHP: Forms, actions and authentication. | Project |
| 11 | PHP: Error handling and file uploads | Project |
| 12 | PHP Examples | Project |
| 13 | Q&A (preparation for the final exam) | Project Presentation |
Information
- Official Page
- Assessment Components: Exam 50% | Project 50%
- Grades