SubjectsSubjects(version: 811)
Course, academic year 2017/2018
  
Webdesign II - N445059
Czech title: Webdesign II
Guaranteed by: Department of Computing and Control Engineering (445)
Actual: from 2015
Semester: summer
Points: summer s.:5
E-Credits: summer s.:5
Examination process: summer s.:
Hours per week, examination: summer s.:2/3 MC [hours/week]
Capacity: unknown / unknown (unknown)Schedule is not published yet, this information might be misleading.
Min. number of students: unlimited
Language: Czech
Teaching methods: full-time
Level:  
For type:  
Additional information: http://moodle.vscht.cz/course/view.php?id=106
Guarantor: Nachtigalová Iva Ing. Ph.D.
Annotation -
Last update: Nachtigalová Iva Ing. Ph.D. (23.07.2013)

The course focuses on the development of dynamic web applications using open source technology Apache - MySQL - PHP. The course first introduces students to the HTTP communication and current technology of applications running in the Internet environment, then focuses on the basic techniques (kernel commands, generating output, databases handling, etc.) and advanced techniques (sessions and cookies handling, user authentication, etc.) for writing code of applications in a server scripting language PHP, of which data is stored and retrieved dynamically to/from MySQL database server. The course also helps students to acquire the necessary knowledge to implement applications in the Apache web server, to program selected functions in the client browser using JavaScript scripting language and also to optimize web applications for web search engines (SEO).
Aim of the course -
Last update: Nachtigalová Iva Ing. Ph.D. (22.07.2013)

Students will be able to:

  • program the advanced features of web applications in a server scripting language PHP
  • connect web applications programmed in PHP with MySQL database server to store/retrieve data
  • program selected features of web application in the client scripting language JavaScript
  • optimize applications and published content for web search engines (SEO).

Deskriptory -
Last update: Nachtigalová Iva Ing. Ph.D. (22.07.2013)

www, web, applications, HTTP, PHP, MySQL, Apache, JavaScript scripting language, XHTML, CSS, Search Engine Optimization SEO

Literature -
Last update: TAJ445 (30.09.2013)

R: Murach's PHP and MySQL (Murach: Training & Reference): Murach's PHP and MySQL (Murach: Training & Reference). Mike Murach & Associates; First Printing edition (November 23, 2010). ISBN: 1890774561.

R: Bowen, R. - Coar, K.: Apache Cookbook: Solutions and Examples for Apache Administrators. O'Reilly Media; Second Edition edition (January 11, 2008). ISBN-10: 0596529945.

R: Tim Wright: Learning JavaScript: A Hands-On Guide to the Fundamentals of Modern JavaScript. Addison-Wesley Professional; 1 edition (August 5, 2012). ISBN: 0321832744.

R: Michael H. Fleischner: SEO Made Simple (Third Edition): Strategies for Dominating the World's Largest Search Engine. CreateSpace Independent Publishing Platform; 3 edition (January 2, 2013). ISBN: 1481838067.

Learning resources -
Last update: Nachtigalová Iva Ing. Ph.D. (22.07.2013)

The PHP Group: PHP Manual [on-line][cit. 9. 11. 2012] Availability on the Internet: http://www.php.net/manual/en/.

The Apache Software Foundation: Apache HTTP Server Documentation [on-line][cit. 9. 11. 2012] Availability on the Internet: http://httpd.apache.org/docs/.

Refsnes Data: w3schools.com - the world's largest web development site [on-line][cit. 9. 11. 2012]. Availability on the Internet: http://w3schools.com/.

Teaching methods -
Last update: Nachtigalová Iva Ing. Ph.D. (22.07.2013)

The 5-hour course starts with two-hour lecture followed by a three-hour thematic exercises in a computer lab where students solve tasks together and gradually step by step create sample web application like web blog. Each student works on his own computer at the same time regularly alternates with with other students at the teacher's computer and actively participates in the preparation of the specification in discussion with others. In the exercises, students learn to work with off-line and on-line resources and to analyse case studies and program codes as well.

Requirements to the exam - Czech
Last update: Nachtigalová Iva Ing. Ph.D. (17.01.2014)

  • Studenti jsou v rámci ověření studijních výsledků povinni absolvovat dva průběžné testy. V případě neúčasti na některém z průběžných testů musí studenti absolvovat náhradní souhrnný test.
  • Průběžné testy ověřují znalosti z látky probírané v první resp. druhé polovině semestru, trvají vždy 50 minut a proběhnou v 8. a 14. týdnu semestru. Souhrnné testy ověřují znalosti z látky probírané za celý semestr, trvají 100 minut a proběhnou ve zkouškovém období ve dvou náhradních termínech. K vypracování testů nelze využít žádných písemných či elektronických materiálů nebo pomůcek.
  • Klasifikovaný zápočet je udělován na základě součtu bodového hodnocení průběžných testů, anebo bodového hodnocení souhrnného testu. Obdrží jej ti studenti, kteří získají alespoň 50 z maximálních 100 bodů.

Syllabus -
Last update: TAJ445 (30.09.2013)

  1. 1. HTTP protocol - protocol versions and their characteristics, communication model, the structure of requests and responses, HTTP methods, headers and status codes.
  2. 2. Technology and tools of design and implementation of dynamic web applications - client technologies, server technologies, PHP language, Apache web server, the basic configuration.
  3. 3. Introduction to PHP - lexical structure, data types, constants, variables, (superglobal) arrays, commands for control the code flow, string interpretation, including files, built-in and user functions.
  4. 4. Advanced PHP properties - arrays and time data handling, string handling, regular expressions, basic and advanced OOP capabilities, handling with file and operating system.
  5. 5. Connection PHP with MySQL database - using the mysqli extension, starting and termination connection, errors handling, interaction with databases, queries and decomposition of the query results. PhpMyAdmin web client.
  6. 6. Form elements in XHTML. Transmission of data on a web server - GET and POST method, data transmission, data processing in PHP.
  7. 7. Maintaining status information - cookies method, structure, receiving and sending out/in PHP, session method, SID and the way of transmission, session variables, session handling in PHP, HTTP authentication, forms authentication in PHP.
  8. 8. Introduction to JavaScript - lexical structure, data types, constants, variables, arrays, control commands for control the code flow, user functions.
  9. 9. Advanced capabilities of JavaScript - client side of language, connection to hypertext documents, BOM and DOM, object hierarchy, DOM nodes handling, cookies handling, CSS handling, forms handling, events handling.
  10. 10. Web applications security - causes of vulnerability, attacks over all inputs, attacks through cookies and session cookies, attacks exploit technology bugs, social engineering.
  11. 11. Web applications security - passwords breaking, form spam, methods of protection.
  12. 12. Web applications architecture, templating systems, SMARTY system, systems Model-View-Controller (MVC), functions of MVC parts.
  13. 13. Search Engine Optimization - searching principles, indexing, generation of search results, evaluation factors, on-page and off-page optimization factors, recommended techniques, XML maps.
  14. 14. The development of sample dynamic web application like web blog.

Entry requirements -
Last update: Nachtigalová Iva Ing. Ph.D. (22.07.2013)

Study of the course assumes:

  • knowledge to create valid, well-styled, usable and accessible hypertext documents in XHTML and CSS languages (i.e. to create published content using semantic and structural elements of XHTML in accordance with language standard, to create layouts and to format text, background, fonts, links, lists, and tables using properties and values of CSS in accordance with language standard, to improve and usability and accessibility of published content by recommended XHTML and CSS techniques)
  • knowledge of aspects of simple databases design (i.e. data types, relational data model, primary and foreign keys) and knowledge of using SQL queries to interact with databases (i.e. commands for creating and editing diagrams and commands for inserting, retrieving, editing and deleting data)

Required skills can be obtained after the studies of courses listed in the Registration Requirements.

Registration requirements -
Last update: Nachtigalová Iva Ing. Ph.D. (22.07.2013)

Database Systems, Computer Presentations

Class methods
Activity Credits Hours
Konzultace s vyučujícími 1 28
Účast na přednáškách 1 28
Příprava na přednášky, semináře, laboratoře, exkurzi nebo praxi 1,5 42
Účast na seminářích 1,5 42
5 / 5 140 / 140
Evaluation of a student
Form Balance
Aktivní účast na výuce 70
Průběžné a zápočtové testy 30

 
VŠCHT Praha