|
Please send feedback, suggestions, and additions to the SAA Technology Best Practices Task Force at techbp-tf [at] forums [dot] archivists [dot] org
Managing Electronic Records and Assets: A Working Bibliography
10. Databases and Programming
Databases
Databases: Step-by-Step Guides to Using Databases
http://www.geekgirls.com/menu_databases.htm
A series of easy to use tutorials on database design and use, including when not to use a database. Primarily for Microsoft Access users. Does not deal with making databases available online.
Lozano, Fernando, Introduction to Relational Database Design
http://www.edm2.com/0612/msql7.html
A basic introduction to relational databases. Has nice explanations of joins and keys. Also discusses the first three levels of normalization, referential integrity, and indexes. Primarily aimed at mSQL users, but still fairly general in scope.
Morgan, Eric Lease, DBM's and Web Delivery
http://www.infomotions.com/musings/dbms-and-web-delivery/
Presentation on databases in libraries, with specific information on Filemaker, Microsoft Access, mySQL, and ODBC. Includes examples of code that can search for and manipulate data through the web.
Web Developer's Virtual Library: Web Databases
http://www.wdvl.com/Authoring/DB/
Articles and Tutorials on database design and creation. Includes information on relational databases, SQL, PHP, MySQL, and more.
Webmonkey, The Web Developer's Resource: Your First Database
http://webmonkey.wired.com/webmonkey/backend/databases/tutorials/tutorial3.html
Basic tutorial on creating a database and putting it on the Web using Microsoft Access and ASP.
ASP
ASP Free: Database
http://www.aspfree.com/c/a/Database/ and http://www.aspfree.com/c/a/Database-Code/
Lists of articles on using ASP with databases. These articles tend to be for intermediate to advanced programmers.
Web Developer's Virtual Library: ASP
http://www.wdvl.com/Authoring/ASP/
Articles and tutorials on ASP programming, including how to build web enabled databases.
PHP
PHP: Hypertext Preprocessor
http://www.php.net/
The official source for all information PHP. Download the software, see tutorials, read the manuals, learn about conferences, get help, find bibliographies, get sample code. It's all here. Includes:
Devshed: PHP
http://www.devshed.com/c/b/PHP
Tutorials, articles, code samples, and more. These articles tend to be for intermediate to advanced programmers.
Free2Code: Introduction to PHP
http://www.free2code.net/plugins/articles/read.php?id=259
Short, easy to understand introduction to using PHP to generate dynamic web content. Includes links to related and follow-up articles.
SQL
A Gentle Introduction to SQL
http://sqlzoo.net/
An interactive tutorial with live exercises using the publicly available CIA World Factbook database, giving you a chance to write and test your own SQL. Also includes a reference section that details the syntax of common functions in SQL Server, Oracle, MySQL, DB2, Mimer SQL, PostgreSQL, and Microsoft Access. Gives you the ability to see and compare SQL statements from various RDBMS's.
SQL Tutorial and Reference (EN)
http://aam.ugpl.de/?q=sql_help
This is the English language version of German tutorial. It is more of a reference manual than a tutorial. The navigation system makes it fairly easy to find the proper syntax of many basic SQL commands.
|
