Help:COAP-3180/exam: Difference between revisions

The educational technology and digital learning wiki
Jump to navigation Jump to search
Line 1: Line 1:
{{under construction}}
<pageby nominor="false" comments="false"/>
<pageby nominor="false" comments="false"/>


== Introduction ==
== Introduction ==


This is a page to help preparation for the [[Help:COAP-3180|COAP-3180]] exam, december 2007.
This is a page to help you prepare the [[Help:COAP-3180|COAP-3180]] exam, December 2007.


== Conceptual exam topics ==
== Conceptual exam topics ==


=== Webdatabases, major database types and simple Internet architectures  ===
=== Web databases, major database types and simple Internet architectures  ===


* Understand the difference between major database types
* Understand the difference between major database types
Line 62: Line 61:


Reading:
Reading:
* Note really required, but you must be able to define objectives and come up with a sketch of desired functionalities.
* Not really required, but you must be able to define objectives and come up with a sketch of desired functionalities.
* Joomla Manual, http://help.joomla.org/images/User_manual/user_manual_v1%200%201_10%2021%2006.pdf (optional)
* Joomla Manual, http://help.joomla.org/images/User_manual/user_manual_v1%200%201_10%2021%2006.pdf (optional)


Line 77: Line 76:
Reading:
Reading:
* http://tecfa.unige.ch/guides/te/files/xml-databases.pdf
* http://tecfa.unige.ch/guides/te/files/xml-databases.pdf
* http://tecfa.unige.ch/guides/te/files/xml-intro-edit.pdf (not all the technical details, but you should understand for example how various XMP applications can combine)
* http://tecfa.unige.ch/guides/te/files/xml-intro-edit.pdf (not all the technical details, but you should understand for example how various XML applications can combine)
* http://tecfa.unige.ch/guides/te/files/xml-ns.pdf (optional)
* http://tecfa.unige.ch/guides/te/files/xml-ns.pdf (optional)
* http://tecfa.unige.ch/guides/te/files/xslt-basics.pdf (not all the technical details, but you should understand what a "template" is)
* http://tecfa.unige.ch/guides/te/files/xslt-basics.pdf (not all the technical details, but you should understand what a "template" is)
Line 92: Line 91:
* Ronald Bourret (2005). XML and Databases, http://www.rpbourret.com/xml/XMLAndDatabases.htm
* Ronald Bourret (2005). XML and Databases, http://www.rpbourret.com/xml/XMLAndDatabases.htm


=== Webservices ===
=== Web services ===


* Have a general understanding of what we mean be "webservice"
* Have a general understanding of what we mean be "webservice"

Revision as of 19:46, 11 December 2007

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

Introduction

This is a page to help you prepare the COAP-3180 exam, December 2007.

Conceptual exam topics

Web databases, 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:

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:

Relational databases

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

Reading:

The LAMP architecture

  • Understand what Apache/MySQL/Php means
  • Understand advantages/disadvantages of working with a web hosting service, a local WAMP installation or a WAMP on a memory stick.

Reading:

PHP/MySQL and Code generators

  • Be able to produce scripting code with a generator
  • Understand what the generator does and why generators can be useful
  • Have a basic understanding how PHP interacts with MySQL

Reading: http://tecfa.unige.ch/guides/te/files/php-mysql.pdf

Configuration of LAMP-based portalware

  • Discuss the design of a CMS, i.e. its purpose, front page design, menu layout, skin and extra tools installed
  • Understand different user roles: Administrator, editor, user and guest

Reading:

The W3C XML framework

  • Purpose of XML
  • Basic technical features of XML:
    • well-formedness,
    • validity, i.e. the Schema concept (DTD, XML Schema, etc.) and its purpose
    • namespaces
  • Some understanding of the purpose of important XML applications, e.g. XHTML, XSLT, XPath, SVG.
  • Understand the difference between "true XHTML" and XHTML used as "just" HTML

Reading:

XML Databases

  • Understand the purpose of XML databases
  • Advantages and disadvantages compared to other database technologies
  • Have a rough understanding on how XPath, XQuery, Xupdate, XQuery Update, XSLT and CSS may work together

Reading:

Web services

  • Have a general understanding of what we mean be "webservice"
  • Be able to distinguish between a REST, A XML-RPC and SOAP interface

Reading:

LDAP databases

Readings:

Technical exam topics

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

SQL basics

Readings:

PHP/MySQL basics

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

Readings:

  • none

XQuery basics

  • Be able to write a simple XQuery application
  • Produce both XML and HTML output
  • Be able to upload XML data files and *.xq files to an eXist server
  • Query and eXist database with simple REST expressions

Readings:

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