Help:COAP-3180/week8: Difference between revisions
Jump to navigation
Jump to search
m (using an external editor) |
m (using an external editor) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 13: | Line 13: | ||
=== Final exam === | === Final exam === | ||
* The exam will be a paper exam with MCQ's, open questions, code repair and completion, etc. | |||
* Open book (any resource you like including the Internet) | |||
Main subjects: | Main subjects: | ||
| Line 18: | Line 20: | ||
(1) High level web application principles | (1) High level web application principles | ||
* Simple web application architectures (tiers) | * Simple web application architectures (tiers) | ||
* Kinds of databases | |||
(2) Practical know how | |||
* Using web services to create "mini-databases" | |||
* Using widgets | |||
* Creating simple HTML Web Forms | |||
* Using a WAMP server (Mowes) | |||
* CMS/CMF installation and configuration | * CMS/CMF installation and configuration | ||
* Database administration with PHPMyAdmin | * Database administration with PHPMyAdmin | ||
* Simple reuse of PHP code, i.e. you may be asked to change "parameters" | * Simple reuse of PHP code, i.e. you may be asked to change "parameters" | ||
(3) SQL: | (3) SQL: | ||
* SELECT | |||
**SELECT ... WHERE, INSERT ... ORDER | |||
**Joins (select from two tables) | |||
* CREATE | |||
**Data types: Integer, Float, VarChar, text | |||
**DEFAULT, NOT NULL, Auto increment | |||
**Keys | |||
**Primary keys | |||
**Foreign keys | |||
* INSERT (both forms) | |||
* UPDATE / DELETE | |||
* DROP | |||
(4) Relational database design: | (4) Relational database design: | ||
* Simple 2-3 table architectures | * Simple 2-3 table architectures | ||
* 1 to N and N to N relations between tables | * 1 to N and N to N relations between tables | ||
* Be able to read a diagram that summarizes table fields and shows relations (as in the [[Wordpress installation and configuration]] example). | |||
(5) XML | (5) XML | ||
| Line 51: | Line 58: | ||
(6) Identity and authentication (high-level principles) | (6) Identity and authentication (high-level principles) | ||
Not included: | '''Not''' included: | ||
* PHP programming, e.g. writing for loops and other algorithms | * PHP programming, e.g. writing for loops and other algorithms | ||
* XSLT and XQuery functions and other more advanced programming constructs | |||
Latest revision as of 00:17, 24 February 2010
Week 8 - COAP 3180
Term project presentation
(Monday)
- See term project page
Summary
(Monday)
- Final lecture, reminder of the most important subjects addressed etc.
Final exam
- The exam will be a paper exam with MCQ's, open questions, code repair and completion, etc.
- Open book (any resource you like including the Internet)
Main subjects:
(1) High level web application principles
- Simple web application architectures (tiers)
- Kinds of databases
(2) Practical know how
- Using web services to create "mini-databases"
- Using widgets
- Creating simple HTML Web Forms
- Using a WAMP server (Mowes)
- CMS/CMF installation and configuration
- Database administration with PHPMyAdmin
- Simple reuse of PHP code, i.e. you may be asked to change "parameters"
(3) SQL:
- SELECT
- SELECT ... WHERE, INSERT ... ORDER
- Joins (select from two tables)
- CREATE
- Data types: Integer, Float, VarChar, text
- DEFAULT, NOT NULL, Auto increment
- Keys
- Primary keys
- Foreign keys
- INSERT (both forms)
- UPDATE / DELETE
- DROP
(4) Relational database design:
- Simple 2-3 table architectures
- 1 to N and N to N relations between tables
- Be able to read a diagram that summarizes table fields and shows relations (as in the Wordpress installation and configuration example).
(5) XML
- Be able to edit/fix well-formed XML files
- XSLT: Simple use of templates (definition and applying), html page generation
- Simple use of XPath expressions (finding nodes and attributes, extracting text, identifying a position). XPath is used both by XSLT and XQuery.
- XQuery: Simple FLOWR expressions, html page generation
(6) Identity and authentication (high-level principles)
Not included:
- PHP programming, e.g. writing for loops and other algorithms
- XSLT and XQuery functions and other more advanced programming constructs