Web-application development workshop

[Debra Shapiro]

With apologies to Thomas (*Low Boggle Threshold) Dowling & others who 
advocate other platforms, for excellent reasons <grin>, UW-Madison 
SLIS-CES presents this workshop for the 40% of libraries running 
their Web servers under MSIIS. Since the underlying concepts are 
similar regardless of environment, guest speakers from UW-Madison 
Libraries, a unix-based production environment, will present short 
synopses of other ways of doing things.
------------------------------------------------
Web-Database Application Development

Date: August 19th - 23rd, 2002 (5 days)

Time: 8:30 am. - 4:30 p.m.; plus two evening labs

Location: ARCH InfoLab at Chadbourne Hall, UW-Madison Campus

Fee: $799 for one person, $699 each for up to 2 more from the same 
institution, enrolled as a team

Registration deadline: August 1

CEUs: 4.0

This 5-day workshop will introduce relational database design 
concepts, HTML form design, and active server page (ASP) scripting. 
Participants will design a database to house specific library content 
and will develop the search and display formats necessary for 
presenting this information interactively on the Web. Concepts will 
be presented in demonstration format, with ample time devoted to 
hands-on exercise and implementation of the application design and 
programming.  At the completion of the workshop, participants will 
have a working application that can be housed on an NT server running 
IIS. Our example application will examine a newspaper index database 
and how to develop query functions and data maintenance routines via 
active server pages. The principles covered can be applied to 
specific library applications using the code as an application design 
template.

Since most Web-application development is a collaborative process, 
development teams are strongly encouraged to attend together, and a 
registration discount for teams is offered.  Ideally, a team should 
include a content specialist (the person who best understands the 
data collection and reporting needs of the application), a Web author 
or designer, a database designer, and an application programmer.  In 
many libraries a single person may share these roles, but best 
practice is to create a team of at least two people for a major 
application development project.

Some course topics:

Relational Database Design
Database Theory
Junction Tables, Lookup Tables, Relationships, Referential Integrity
SQL - Structured Query Language
ASP - Active Server Pages
Developing a website layout for the search page
Develop a basic Cascading Style Sheet (CSS)
Creating search forms and generating formatted output
Viewing, Adding, Updating and Deleting Records
Result Set Paging, Error Handling, Expanding the Application
Advanced Recordset Techniques
Ways to expand the application

Printable registration form (in Adobe .pdf format) available at:
http://www.slis.wisc.edu/academic/ces/webdb.html

Please call (608) 263-2942, or email cesinfo at slis.wisc.edu for 
information on other ways to register, or to request a brochure with 
a registration form. Questions about the course content can be 
directed to Debra Shapiro, dshapiro at slis.wisc.edu, but please do not 
send her registrations!

Course Instructor: Dawne Tortorella is President and co-founder of 
BellCow, Inc., a technology consulting company. BellCow provides 
technology training, database design, web-based application 
development, network design, implementation and support, and 
technology planning services for libraries of all types.

Housing: A block of rooms has been reserved for this class at the 
Lowell Center, 608-256-2621 Additional housing and parking 
information will also be sent with your registration confirmation.

-- 
dshapiro at slis.wisc.edu
Debra Shapiro
Continuing Education Services
UW-Madison SLIS
4282 Helen C. White Hall
Madison WI 53706
608 262 9195
FAX 608 263 4849