Help:COAP-3180/week8: Difference between revisions
Jump to navigation
Jump to search
m (using an external editor) |
m (using an external editor) |
||
| Line 12: | Line 12: | ||
=== Final exam === | === Final exam === | ||
Main subjects: | Main subjects: | ||
| Line 18: | Line 17: | ||
(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: | ||
| Line 52: | Line 55: | ||
(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 | |||
Revision as of 00:16, 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
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