Help:COAP-3180/week8

The educational technology and digital learning wiki
Revision as of 00:02, 24 February 2010 by Daniel K. Schneider (talk | contribs) (Created page with '== Week 8 - COAP 3180 == === Term project presentation === (Monday) * See Help:COAP-3180/term project term project page === Summary === (Monday) * Fi…')
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Week 8 - COAP 3180

Term project presentation

(Monday)

Summary

(Monday)

  • Final lecture, reminder of the most important subjects addressed etc.

Final exam

Main subjects

  • web application architecture (high level principles)
  • SQL:
   * SELECT
         o SELECT ... WHERE, INSERT ... ORDER
         o Joins (select from two tables) 
   * CREATE
         o Data types: Integer, Float, VarChar, text
         o DEFAULT, NOT NULL, Auto increment
         o Keys
         o Primary keys 
         o Foreign keys 
   * INSERT (both forms(
   * UPDATE / DELETE
   * DROP 
  • Database design:
    • Simple 2-3 table architectures
    • 1 to N and N to N relations between tables
  • XML