Web Site Development II

Course Description

Students will analyze, design, build and maintain large Internet sites that successfully integrate server management, site design, database, and scripting skills.

Main Topics Covered

• Data-Driven Web Sites
• Programming as an Extension of Visual Organization
• The Freedom to Experiment
• Web Development Workflow
• Site Planning
• Proposal/Narrative
• Domain Registration
• Hosting/Solution/Options
• Storyboarding/Flowcharting
• Introduction to Web Development Tools
• Web Editors: Dreamweaver and GoLive
• Information Architecture
• Introduction to Database Design
• Syntax Overview
• PHP Scripting Basics
• Objects and Object-Oriented Programming
• ASP Basics
• Introduction to Database Management Concepts
• The Database Client and Server
• MS Access Resources
• MySQL Resources
• ASP Basics
• Translating Plain English into SQL Queries
• SQL statements/Queries
• Creating Dynamic Web Applications Using a Web Editor
• Review of ASP/PHP Control Structures
• Overview of the Data-Driven Web Site
• The Catalog Page: Glancing at Every Record
• The Detail Page: Seeing Every Field or Column of One Record
• Linking the Pages: Using the Primary Key in the Query String
• Paging through Data
• Setting File Permissions Using FTP Clients
• Web-Based MySQL Administrative Tool; phpMyAdmin
• The Shopping Cart as Business Environment
• E-Commerce Site Design
• Shopping Cart Processes
• Password-Protecting Web Pages
• The Online Quiz Show as Educational Environment
• Dynamic Media in Dynamic Applications
• The Online Exam from the Student's Perspective
• Modifying Code and the Freedom to Revise!
• Modular Construction
• Testing Your Site
• Client Interviews
• A Final Note on Security

Course Competencies

Upon successful completion of this course, the student should be able to:

• Demonstrate the principles and processes of planning a dynamic web site.
• Demonstrate an understanding of how to integrate plug in technology into a web site.
• Demonstrate a competency in the gathering of data from web site traffic.
• Demonstrate the ability to plan and produce a complete commercial web site.

Software Utilized

• Adobe Photoshop
• Adobe Illustrator
• Adobe Dreamweaver
• Microsoft Word
• Adobe Acrobat Professional

Programming Languages & Technologies Utilized

• PHP
• ASP
• XHTML
• CSS
• MySQL