Web Technologies

TW :: 2017/18 1st Semester

Contents

Week Theory Classes Practice Sessions
1 Course Presentation.
First introduction to web technologies.
2 HTML 5: Introduction, basic tags, tables, text formatting, common attributes and generic blocks. Forms, the semantic web, metadata and media tags. HTML
Exercises | Solutions
3 CSS 3: Introduction, basic selectors, properties. CSS
Exercises | Solutions
4 CSS 3: Positioning, specificity, inheritance. CSS Exercises
5 Entity Relationship Model: entities, attibutes and relationships. Entity Relationship
Exercises
6 Relational Model: relations, tuples, attributes and constraints. Conversion from the entity-relationship model. Relational Model
Exercises
7 FEUP Week
8 SQL: Table creation. Data types and constraints. PostgreSQL.
SQL: Database queries. Selecting, filtering, set operations and joins.
SQL
Exercises
9 SQL: Inserting, deleting and updating SQL
Exercises
10 PHP: Variables, loops, arrays and functions.
PHP
Project

PHP
Exercises | Solutions
11 PHP: Receiving values from HTML pages. Classes and objects. Database connections. Project
12 PHP: Forms, actions and authentication. Project
13 PHP: Error handling and file uploads Project

Information