UW Homepage iSchool Contact Info iSchool Homepage iSchool Homepage An image that shows the iSchool brand

 

 

 

 

 

 

UW > iSchool > David Hendry > Course: INFO-445
- - - - -

INFO-445: Advanced Database Design, Management, and Maintenance

Spring 2013
Information School
University of Washington

What's new?

Getting Ready

To prepare for the first TWO classes, please:

  • Read this paper:
    • Agrawal, R. et al. (2009). The Claremont report on database research. Communications of the ACM, 51(1), 56-65. [PDF]
       
  • Be sure that you have this REQUIRED text and that you are comfortable with the material in chapters 1-5 and chapters 12-13:
    Connolly, T. M. & Begg, C. E. (2009). Database Systems: A Practical Approach to Design, Implementation, and Management (5th Edition). New York: Addison-Wesley Publishing.

Miscellaneous

Assignments and Project

Papers

Resources

PostgreSQL

Documentation

http://www.postgresql.org/docs/9.2/interactive/index.html

The command line

http://www.postgresql.org/docs/9.2/static/app-psql.html   (copy & paste link)

SQL command reference

http://www.postgresql.org/docs/9.2/static/sql-commands.html  (copy & past link)

PL/pgSQL - SQL Procedural Language

http://www.postgresql.org/docs/9.2/interactive/plpgsql.html

Other resources

http://www.postgresql.org/about/

 

Web Programming

Introduction

http://code.google.com/edu/submissions/uwspr2007_webprogramming/listing.html

PHP Language Reference

http://www.php.net/manual/en/langref.php

PostgreSQL API Reference

http://us3.php.net/manual/en/book.pgsql.php

 

Miscellaneous

Linux command line basics

http://code.google.com/edu/tools101/linux/basics.html

 

Source control – git

http://git-scm.com/

https://bitbucket.org/

http://sixrevisions.com/resources/git-tutorials-beginners/

  - - - - -

Copyright David Hendry, 2013.

You may use this material for educational purposes but please cite this source. To make comments, please contact David Hendry (dhendry@u.washington.edu).

Information School, University of Washington: Contact Information.