Programming II
 

LEARNING OUTCOMES
 

The current course aims to teach students to understand and master the concepts and techniques inherent to the development of dynamic pages for the web, using relational databases. In this way, students are expected to:
• Understand the architecture and operation of web servers and aspects related to its management;
• Examine major existing technologies for the development of dynamic pages;
• Acquire theoretical and practical knowledge of the technologies, including communication mechanisms with databases;
• Understand the theoretical foundations necessary for analysis and design of relational databases;
• Design and implement systems for enabling web content management;
• Build a technological background that enables understanding of the concepts inherent in the development of PHP pages;
• Know the syntax, the lexicon and the PHP semantics;
• Consolidate the development of dynamic web pages of moderate complexity, using databases;
• Apply the knowledge gained in the development of a group project.

STUDY PROGRAMME
 

Unit I. Introduction to the development of dynamic pages for the Web
• Architecture and operation of dynamic pages systems;
• Analysis of the main technologies used in the area;
• Study of technology PHP (Hypertext Preprocessor);
Unit II. Analysis, design and implementation of relational databases:
• Theoretical foundations related to databases and the RDBMS;
• Strategies for analysis and design of relational databases;
• Implementation of relational databases in MySQL using the SQL language.
Unit III. Development of dynamic pages using databases:
• Analysis of the main mechanisms of communication between dynamic pages and databases;
• Design and implementation of content management systems for the Web.

BIBLIOGRAPHY
 

Gilmore, W. J. (2010). Beginning PHP and MySQL: From Novice to Professional (3rd Edition). Apress.
Serrão, C. & Marques, J. (2011). Programação com PHP 5.3. Lisboa: FCA.
Converse, T. &Park, J.; Clark, M. (2004) PHP5 and MySQL Bible . Wiley.
Doyle, M. (2009). Beginning PHP 5.3 . Wrox.
TuxRadar (2012). Practical PHP Programming. [Online] http://www.tuxradar.com/practicalphp