CIS154 Useful Links

This page contains a list of links to sites related to this course. On This Page Database Reference Glossaries HTML Reference PHP Reference Server-Side Scripting Language Homepages Server-Side Scripting Technology Comparisons SQL Tutorials and Practice Web Site Design Other/Miscellaneous Database Reference Access Homepage: Microsoft's homepage for Access DevGuru's Jet SQL Quick Reference: An informative 40 page reference source that explains and gives examples of code for the clauses, declarations, expressions, functions, operators, and statements used by Jet SQL. Fundamental Microsoft Jet SQL for Access 2000: Microsoft's articles on SQL for Access MySQL Homepage: The MySQL AB Company's homepage for MySQL MyODBC: Download page for MyODBC API MySQL Documentation: Excellent resource for MySQL Oracle: Oracles's homepage PostgreSQL: Index to PostGreSQL sites. SQL Server: Microsoft's homepage for SQL Server back to top Glossaries FOLDOC: A good starting place for looking up computing terms. Webopedia: Another good place for looking up technical terms. VBScript Glossary: Microsoft's glossary for VBScript. back to top HTML Reference Bill's HTML short cut sheet: A visual HTML reference and a quick starting point. Getting started with HTML: A short introduction to writing HTML. Adding a touch of style: A short guide to styling your Web pages. Bare Bones Guide to HTML: A quick reference to all the tags that current browsers are likely to recognize. Compact Index of HTML Tags: An alphabetical arrangement of HTML tags with links to a description of the tag and its syntax. HTML Tutorial: A set of tutorials on HTML topics from w3schools. back to top PHP Reference Introductory Tutorial: PHP.net's tutorial for beginners. PHP Manual: Online documentation. PHP4 Installation Overview: Detailed installation instructions from WebMonkey. back to top Server-Side Scripting Language Homepages ASP: Microsoft's MSDN Page for ASP. See also the DevGuru references on ASP, ADO and VBScript. ColdFusion: Macromedia's ColdFusion 5 page JSP: Sun's Page for JSP Perl: Comprehensive Perl Archive Network. PHP: The PHP Group. See also www.zend.com. back to top Server-Side Scripting Technology Comparisons Four scripting languages tried and tested: From zdnetindia.com circa October 2000. One of the more balanced comparisons of the major server-side scripting frameworks. However, note that Java has made significant performance improvements with their HotSpot compiler since this article was published. Fun with ColdFusion: A ColdFusion advocate comparing the major offerings. JSP vs mod_php and mod_perl: Performance comparison of JSP, PHP and Perl on a Java application server named Resin. J2EE vs. Microsoft.NET: Whitepaper commissioned by Sun comparing these two platforms. Thanks to Pat Ferrell for finding this timely article. 7 Reasons Why PHP is Better than ASP: A PHP advocate comparing ASP and PHP. His comments about gaining speed by not writing to the ADO interface ("No COM more speed") are pertinent, but the flip side is that you lose portability. The follow-up articles are also interesting. PHP, Javascript and VBScript Language Summary: A comparison of language syntax differences. back to top SQL Tutorials and Practice SQLcourse.com: An introductory SQL tutorial that allows you to practice what you learn using an on-line SQL interpreter. A Gentle Introduction to SQL: An introductory SQL tutorial that allows you to practice what you learn using an on-line SQL interpreter. Allows you to pick different database engines. back to top Web Site Design How to Write a Request for Proposal for a Web Project by Bruce Morris: An article on how to write a Request for Proposal. Contains useful guidelines for developing your project proposal. Website Planning Worksheet: A useful questionnaire to follow for designing web sites. web-build.net: A typical web site design proposal Yale Web Style Guide: A useful set of guidelines for designing web sites. back to top Other/Miscellaneous Internet Security: An introductory tutorial on Internet security from WebPro Forum by Sun Microsystems Media Types: A current list of Content Types (MIME) for Web pages. back to top Home | WebCT | Announcements | Schedule | Syllabus Expectations | Help | FAQ's | HowTo's | Samples | Links Last Updated: 7/16/2003 5:37:33 PM