Help:COAP-3180: Difference between revisions

The educational technology and digital learning wiki
Jump to navigation Jump to search
Line 92: Line 92:
=== Other teaching resources ===
=== Other teaching resources ===


* [http://tecfa.unige.ch/guides/te/files/webdatabases-intro.pdf webdatabases-intro.pdf]
* [http://tecfa.unige.ch/guides/te/files/webdatabases-intro.pdf webdatabases-intro.pdf] (revised version, Monday week 8)
* [http://tecfa.unige.ch/guides/te/files/mysql-intro.pdf mysql-intro.pdf] but [[SQL and MySQL tutorial]] is better reading.
* [http://tecfa.unige.ch/guides/te/files/mysql-intro.pdf mysql-intro.pdf] but [[SQL and MySQL tutorial]] is better reading.
* [http://tecfa.unige.ch/guides/te/files/php-mysql.pdf php-mysql.pdf] but [[PHP tutorial - basics]] and [[PHP-MySQL tutorial -basics]] is better reading (quality for both slides and wiki articles is not great, consider reading one of the tutorials suggested on the week 4 page)
* [http://tecfa.unige.ch/guides/te/files/php-mysql.pdf php-mysql.pdf] but [[PHP tutorial - basics]] and [[PHP-MySQL tutorial -basics]] is better reading (quality for both slides and wiki articles is not great, consider reading one of the tutorials suggested on the week 4 page)

Revision as of 00:22, 24 February 2010

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

Introduction

Disclaimer: This is a resource page for my Spring 2010 I Web Databases course (COAP 3180) at Webster University, Geneva. This page does neither replace the official syllabus nor the information in the official learning management system (WorldClassroom/Blackboard). It allows students to navigate more efficiently through the materials in this wiki.

The program and materials are provisional and will be adjusted on a weekly basis.

Course level outcomes

At the completion of this course students will be able to:

  1. Add a Webpage Database to an HTML page
  2. Manipulate data using SQL operations
  3. Publish both static and dynamic data on the Web
  4. Convert text files to XML databases
  5. Be able to query XML data using XQuery
  6. Be able to work with relational data as XML

These outcomes defined in the syllabus can be translated to more practical outcomes:

  1. Use simple Web 2.0 database services and integrate it into a webpage.
  2. Manipulate data using SQL operations and create simple SQL databases in a DBMS.
  3. Understand the architecture of a simple web application (HTML client / Web server / Script / Database).
  4. Be able use a LAMP/WAMP software bundle and to install and to configure web applications, e.g. a CMS. This can evolve into a term project.
  5. Generate a very simple web application that can connect to a database management system (DBMS) though an ODBC API.
  6. Understand/recall XML basics, like converting text files and database output to XML, editing an XML file using a schema and displaying XML data.
  7. Be able to query and update XML data files and XML Databases using XQuery dand XQuery Update.
  8. Understand the general architecture and purpose of LDAP address and authentication servers and light-weight solutions like OpenID.

Current weekly program

Week 7 - COAP 3180

Topics Covered

  • Termproject - Getting it done with Wordpress
  • XQuery (follow-up)
  • Digital identities

Classroom activities Monday

Classroom activities Wednesday

First hour
talk and some visits/demos
  • A tour of identity and authentication on the web issues
Second hour
  • Exam Q/A
  • Work on Term project Q/A

Homework 6

Task

  • Create three XQuery scripts that extract three different data from a single large XML File.
  • You are expected to use at least simple FLWR expressions like the following one:
<result>
  { for $t in 
    fn:doc("http://tecfa.unige.ch/guides/xml/examples/shakespeare.1.10.xml/hamlet.xml")//ACT//SCENE/TITLE
   return $t }
</result>
  • You will get a better grade if you render in HTML, e.g.
xquery version "1.0";

let $source_doc := fn:doc("http://tecfa.unige.ch/guides/xml/examples/shakespeare.1.10.xml/hamlet.xml")
return
<html>
 <head> <title>Questionnaire Items</title> </head>
 <body>
  Acts of Hamlet
  <ol>
  { for $t in $source_doc//ACT//SCENE/TITLE
   return 
   <li> {$t/text()} </li>
   }
   </ol> 
 </body>
</html>

... you will get an A if your are somewhat original and/or if you produce more complex queries.

Submission Dates

  • This homework is due at start of Monday lesson, week 8.
  • Students must provide three XQuery scripts plus a copy of the XML file.
  • Each homework counts 10% in your global evaluation. The four best homeworks will be taken into account.

Evaluation

  • Three working scripts
  • Complexity of the query
  • Rendering quality, e.g. you get a bonus if you render in a (X)HTML page.

Tips for the homework

  • Read my handout first, you may need to find some extra reading.
  • If you use the XQuery USE ME plugin, set the Output file ext. to html !

Links and teaching materials XQuery

Online software
Teaching materials
Optional reading

Links and teaching materials Digital identity

Week 7 - COAP 3180

Topics Covered

  • Termproject - Getting it done with Wordpress
  • XQuery (follow-up)
  • Digital identities

Classroom activities Monday

Classroom activities Wednesday

First hour
talk and some visits/demos
  • A tour of identity and authentication on the web issues
Second hour
  • Exam Q/A
  • Work on Term project Q/A

Homework 6

Task

  • Create three XQuery scripts that extract three different data from a single large XML File.
  • You are expected to use at least simple FLWR expressions like the following one:
<result>
  { for $t in 
    fn:doc("http://tecfa.unige.ch/guides/xml/examples/shakespeare.1.10.xml/hamlet.xml")//ACT//SCENE/TITLE
   return $t }
</result>
  • You will get a better grade if you render in HTML, e.g.
xquery version "1.0";

let $source_doc := fn:doc("http://tecfa.unige.ch/guides/xml/examples/shakespeare.1.10.xml/hamlet.xml")
return
<html>
 <head> <title>Questionnaire Items</title> </head>
 <body>
  Acts of Hamlet
  <ol>
  { for $t in $source_doc//ACT//SCENE/TITLE
   return 
   <li> {$t/text()} </li>
   }
   </ol> 
 </body>
</html>

... you will get an A if your are somewhat original and/or if you produce more complex queries.

Submission Dates

  • This homework is due at start of Monday lesson, week 8.
  • Students must provide three XQuery scripts plus a copy of the XML file.
  • Each homework counts 10% in your global evaluation. The four best homeworks will be taken into account.

Evaluation

  • Three working scripts
  • Complexity of the query
  • Rendering quality, e.g. you get a bonus if you render in a (X)HTML page.

Tips for the homework

  • Read my handout first, you may need to find some extra reading.
  • If you use the XQuery USE ME plugin, set the Output file ext. to html !

Links and teaching materials XQuery

Online software
Teaching materials
Optional reading

Links and teaching materials Digital identity

List of all Coap 3180 pages

Weekly programs

Most important wiki pages

The COAP 3180 lecture notes page allows you to get the whole lot of wiki pages in a single PDF. Of course, some contents will not be tested in exams. In particular, there will be no PHP and no XML DTD/Schema questions. Mid-term will focus on SQL. The final exam will add XML, XSLT and Xquery plus some minor topics.

The following list may not be complete. Also, some subject require extra reading (see the weekly programs).

Other teaching resources

Most important software

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