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