Help:COAP-3180/exam: Difference between revisions

The educational technology and digital learning wiki
Jump to navigation Jump to search
 
Line 7: Line 7:
== Conceptual exam topics ==
== Conceptual exam topics ==


=== Simple web 2.0 databases ===
* Understand the potential of tools like [[Zoho]] Creator and other virtual office software, e.g. other Zoho applications or Google Apps like [[Google Docs]]


=== Simple web 2.0 databases ===
Reading:
* O'Reilly Tim (2005), [http://www.oreillynet.com/pub/a/oreilly/tim/news/2005/09/30/what-is-web-20.html What is Web 2.0], better take the [http://www.oreillynet.com/lpt/a/6228 print] version.


=== Webtops and widgets ===
=== Webtops and widgets ===


=== Database types ===
* Understand the principle of web top like [[pageflakes]]
* Understand the principle of web widgets
 
Reading:
* [[Web widget and mashup]] (chapters 1 and 2)
 
=== Webdatabases, major database types and simple Internet architectures  ===
 
* Understand the difference between major database types
* HTML Forms, server-side scripts and databases
* Three-tier architecture model
 
Reading:
* http://tecfa.unige.ch/guides/te/files/webdatabases-intro.pdf


=== Relational databases ===
=== Relational databases ===
* Principles of relational databases, i.e. how objects can be represented with tables, and how tables can be linked together with keys
=== The LAMP architecture ===
* Understand what Apache/MySQL/Php means


=== Code generators ===
=== Code generators ===


=== The LAMP architecture ===
* Be able to produce scripting code with a generator
* Understand what the generator does and why generators can be useful


=== Configuration of LAMP-based portalware ===
=== Configuration of LAMP-based portalware ===
* Discuss design of a CMS


=== The W3C XML framework ===
=== The W3C XML framework ===
Line 37: Line 63:
=== SQL basics ===
=== SQL basics ===


* Understand simple table definition
* SELECT, INSERT, UPDATE


Readings:
Readings:


=== PHP/MySQL basics ===
* Be able to use the PHPMySQLadmin interface (create users, databases and fix permissions)
* Install a portal on a LAMP server


=== XQuery basics ===
=== XQuery basics ===

Revision as of 18:41, 11 December 2007

This article or section is currently under construction

In principle, someone is working on it and there should be a better version in a not so distant future.
If you want to modify this page, please discuss it with the person working on it (see the "history")

<pageby nominor="false" comments="false"/>

Introduction

Conceptual exam topics

Simple web 2.0 databases

  • Understand the potential of tools like Zoho Creator and other virtual office software, e.g. other Zoho applications or Google Apps like Google Docs

Reading:

Webtops and widgets

  • Understand the principle of web top like pageflakes
  • Understand the principle of web widgets

Reading:

Webdatabases, major database types and simple Internet architectures

  • Understand the difference between major database types
  • HTML Forms, server-side scripts and databases
  • Three-tier architecture model

Reading:

Relational databases

  • Principles of relational databases, i.e. how objects can be represented with tables, and how tables can be linked together with keys

The LAMP architecture

  • Understand what Apache/MySQL/Php means

Code generators

  • Be able to produce scripting code with a generator
  • Understand what the generator does and why generators can be useful

Configuration of LAMP-based portalware

  • Discuss design of a CMS

The W3C XML framework

Webservices

LDAP databases

Readings:


Technical exam topics

You are expected to master technical details (beginner's level) of these topics.

SQL basics

  • Understand simple table definition
  • SELECT, INSERT, UPDATE

Readings:

PHP/MySQL basics

  • Be able to use the PHPMySQLadmin interface (create users, databases and fix permissions)
  • Install a portal on a LAMP server

XQuery basics

Readings:

Retrieved from "https://edutechwiki.unige.ch/mediawiki/index.php?title=Help:COAP-3180/exam&oldid=16658"