Westwood College Library
Westwood College Online Learning Resource Center
Home | Online Course Resources | Online Books and Articles | General Reference
 

GD444: Database Design and Development
Prerequisite(s): GD436

This course introduce students to e-commerce database design and management.Topics include Structured Query Language (SQL); shopping carts; Secure Socket Layer (SSL); secure transactions; advanced forms, tables, and queries; Macromedia Generator; database analysis, design and management; Hypertext Preprocessor (PHP); and Active Server Pages (ASPs). Upon completion of this course, students should be able to build a small e-commerce site that utilizes a shopping cart, forms, SSL, and a back end database.
 

Structured Query Language (SQL)

CS225: SQL and Relational Database Management
Resources on SQL and RDBMS

Microsoft SQL Server
Official site for SQL Server 2005

SQL Server Magazine
Articles on various topics related to SQL (some available to subscribers only)

SQL.org
Sequel database reference material

SQLCourse.com
Interactive SQL training for beginners


Secure Socket Layer (SSL)

Open SSL
Open source SSL toolkit

SSL
Article from NetworkWorld.com, includes links to other SSL news stories

Secure Socket Layer
Definition with links to related articles


Advanced Forms, Tables, and Queries

Advanced HTML Forms
Tutorial from the UK Web Design Company

HTML Forms and Input
From W3Schools.com

How to Create Tables for a Web Page
From Tips-Tricks.com

Retrieving Data with SQL Queries
Article from About.com

Tables in HTML Documents
From the World Wide Web Consortium


Database Design, Analysis, and Management

dB Forums
Database support community

Database Design
Articles and resources from About.com

Getting Started with Databases
Data access and storage developer center from MSDN (Microsoft)

Secure MySQL Database Design
Article written by Kristy Westphal at SecurityFocus.com


Active Server Pages (ASPs)

ASP 101
News, articles, lessons, resources, and links

ASP Free
ASP help, tutorials, programming, and code

Active Server Pages Resource
Code, message board, and tutorials

Shopping Carts

Choosing a Shopping Cart
Article by Paul Whitman at the Macromedia Dreamweaver Development Center

Choosing a Shopping Cart Program
Q&A from Entrepreneur.com


Secure Transactions

Customer Security: Basic Principles
E-commerce security issues from ECD (Ecommerce Digest)

ZDNet: Security
White papers, webcasts, and case studies


Macromedia Generator

Generator for Flash Users
From the Macromedia Flash Support Center

Hypertext Preprocessor (PHP)

Hotscripts.com
PHP resources

PHP: Hypertext Preprocessor
PHP resources

The PHP Resource Index
Scripts, functions and classes, and a PHP community

PHPBuilder.com
Tutorials, templates, and manuals


Additional Sites of Interest

ActionFX Photoshop Resources
Tricks and downloads for Adobe Photoshop

Adobe
Official website

All Graphic Design
Graphic design resources directory

Builder.com
White papers, trialware, and online book library

CMYK Magazine
Magazine for graduate work in advertising, design, photography, and illustration

Communication Arts Network
Leading trade journal for visual communications

Design Graphics
Magazine devoted to digital publishing

A Digital Dreamer
Graphic design career information  

Digital Photography Blog
Digital camera reviews, ratings, tips, and comparisons

Digital Photography Weblog

Electronic Publishing
Graphic arts, digital printing, and publishing

Game Developer
Publication written specifically for creators of entertainment software

Go 2 Graphics
Illustrator tutorials

Google Image Search

Graphics.com
Shared resource for creative design

How
Graphic design books, magazines, competitions, and conferences

Kaliber10000
The Designers' Lunchbox

Mike's Sketchpad
Photoshop tutorials, free fonts, QuarkXpress, and graphics tutorials

Open Directory
Directory of stock photo websites

PhotoFoolery Tutorial Links
Photoshop tutorials

Photoshop Cafe
Photoshop tutorials and resources 

Photoshop911
Resources for help with Photoshop

Planet Photoshop

Photoshop Roadmap
Photoshop tutorials

PhotoshopSupport.com
Photoshop tutorials and photoshop plugins

Print
Graphic design magazine

STEP Inside Design
Publication that explores the impact of design in our lives

WebMachine
Guide through Adobe web collection
 
LIBRARY HOME | CONTACT | DISCLAIMER