Course Overview Building Data Driven Web Sites (WBM-461)

cortegesmashInternet και Εφαρμογές Web

10 Νοε 2013 (πριν από 3 χρόνια και 9 μήνες)

98 εμφανίσεις

Course Overview

Building Data Driven Web Sites (WBM
-
461)


Instructor Information


Bill Crosbie

Instructor/Curriculum Developer

Rutgers University Center for Applied Computer
Technology


Silvia Muller

Instructor/Curriculum Developer

Rutgers University Cente
r for Applied Computer
Technology


bcrosbie@rci.rutgers.edu

silvia@ums.rutgers.edu









Meeting Times & Locations


Session

Day

Date

Time

Location






1

Saturday

Oct 5

9 a.m.
-
12 p.m.

Hill 009

2

Saturday

Oct 5

1:30
-
4:30 p.m.

Hill 009

3

Saturday

Oct 12

9 a.m.
-
12 p.m.

Hill 009

4

Saturday

Oct 12

9 a.m.
-
12 p.m.

Hill 009

5

Saturday

Oct 19

1:30
-
4:30 p.m.

Hill 009

6

Saturday

Oct 19

9 a.m.
-
12 p.m.

Hill 009

7

Saturday

Oct 26

1:30
-
4:30 p.m.

Hill 009

8

Saturday

Oct 26

9 a.m.
-
12 p.m.

Hill 009

9

Sat
urday

Nov 2

1:30
-
4:30 p.m.

Hill 009

10

Saturday

Nov 9

9 a.m.
-
12 p.m.

Hill 009

11

Saturday

Nov 9

1:30
-
4:30 p.m.

Hill 009

12

Saturday

Nov 16

9 a.m.
-
12 p.m.

Hill 009

13

Saturday

Nov 16

1:30
-
4:30 p.m.

Hill 009

14

Saturday

Nov 23

9 a.m.
-
12 p.m.

Hill 009

1
5

Saturday

Nov 23

1:30
-
4:30 p.m.

Hill 009




Class Sessions


Session 1


Intro to dynamic HTML generation, Databases and SQL (Structured
Query Language)




Introductions and Syllabus review



Client/Server interaction review



Middleware applications and their

purpose



Demonstration of pulling information from a database into an HTML document



Project Overview



READING: Chapter 1
Dreamweaver UltraDev 4


& Fast & Easy ColdFusion Development Chapter 1 (handout)


Session 2

SQL and Cold Fusion




SQL syntax review



Comp
ose a basic SQL statement to search database for specific information



Dynamically generating SQL statements with Cold Fusion



Create a form to get parameters and dynamically generate a SQL statement



READING: Chapter 3
Dreamweaver UltraDev 4


& Chapter 1
-
6 T
each yourself SQL in 10 Minutes


Session 3


Insert & Update using Cold Fusion and m
ore SQL




SQL insert Statement syntax review



Compose a basic SQL statement to insert form results into a database



SQL update Statement syntax review



Compose a basic SQL st
atement to update form results into a database



READING: Chapter 15
-
16 Teach yourself SQL in 10 Minutes


Session 4


Setting up a local development environment




Choosing your development environment software



Installing a Web server on the local system



Insta
lling and configuring the Cold Fusion environment



Setting up an ODBC connection



Database decomposition and normalization



Create a simple database for the project site



READING: Chapter 2
Dreamweaver UltraDev 4


Session 5


Intro to Dreamweaver UltraDev




Dre
amweaver interface review


new palettes in Ultradev



Composing a template in Dreamweaver



Pulling and displaying information from a database with Cold Fusion



Create a Cold Fusion template with UltraDev that pulls information from your
database



READING: Chap
ter 4, 5 & 6
Dreamweaver UltraDev 4



Session 6


Inserting & Updating information in a Database with UltraDev




Updating information in a database with Cold Fusion



Creating forms to add information into the database



Creating forms to change existing info
rmation in a database



READING: Handouts


Session 7


Interaction Design Basics




Discussion of interaction design principles


“Don’t Make Me Think”



Cite actions taken by the user to place an order in our system



Map out the corresponding functions of the si
te



Create email messages using CFMAIL



Create a Cold Fusion template to allow an administrator to select information from
the database and compose email based on that information



READING


Session 8


Shopping Carts/Project Review




Create a basic shopping Ca
rt



Introduction to CFApplication and Session variables



Methods of Maintaining State



READING: Chapters 1
-
4,
Teach Yourself JavaScript in 24 Hours


Session 9


Interaction Design/JavaScript




Introduction to JavaScript



Continue with Shopping Cart



READING: Cha
pters 5
-
8,
Teach Yourself JavaScript in 24 Hours


Session 10


Client Side Scripting/JavaScript OR Float Class




Catch up or move ahead with other JavaScript Topics



Continue with Shopping Cart



READING: Chapters 9
-
12,
Teach Yourself JavaScript in 24 Hours


Session 11


Form Validation/JavaScript




Create a script to validate form input on the order form



Continue with Shopping Cart



READING: Chapters 13 & 14, 21, 23,
Teach Yourself JavaScript in 24 Hours


Session 12

Modularization and site maintenance




Modular
izing code with Cold Fusion custom tags



Create a custom Cold Fusion tag



Create an HTML include



READING


Session 13


ASP & PHP Overview



Active Server Pages overview



Common technologies used with ASP



Recreate the activities update function with ASP



PHP over
view



Common technologies used with PHP



Create surf tournament information page using PHP



READING: Handouts

Session 14


JSP & Perl/CGI Overview




Java Server Pages overview



Technologies associated with JSP



Recreation of member profile update using JSP



Perl

scripting language overview



Recreate order form from site using cgi.pm



Technologies associated with Perl



READING: Handouts




Session 15


XML & Java Servlets Overview




WML & other wireless device markup languages



Next steps to take after this class



Findi
ng Web server space



Certificate project review



Final Q & A



Textbooks


Nicholson, Sean,
Inside Dreamweaver UltraDev 4

(New Riders, 2001)


Forta, Ben,
Teach Yourself SQL in 10 Minutes (2
nd

ed.)

(SAMS 2001)


Moncur, Michael, T
each Yourself Javascript in 2
4 hours (2
nd

ed.)

(SAMS 2001)


Supplemental instructor handouts for each session will be distributed.



Supplementary Reading


Cold Fusion


Forta, Ben,
Cold Fusion 4.0 Application Construction Kit (Cold Fusion 4)

(MacMillan,
1998).


Forta, Ben, et al,
Cer
tified Cold Fusion Developer Study Guide

(MacMillan, 2000).


Bradley, T.C.,
Fast and Easy Cold Fusion Development

(Prima Tech 2000)


XML
-

Extensible Markup Language


Boumphrey, Frank et al,
Beginning XHTML

(Wrox, 2000).


Ray. Erik T.,
Learning XML,

(O’Rei
lly 2001)




CGI Scripting with Perl


Castro, Elizabeth,
Perl and CGI for the World Wide Web: Visual Quickstart Guide

(Peachpit Press, 1998).


Guelich, Scott, et al.,
CGI Programing with Perl, 2
nd

Ed.

(O’Reilly 2000)



Active Server Pages (ASP)


Buser, Dav
id, et al.,
Beginning ASP Databases

(Wrox 1999)


Hillier. Scot & Mezzick, Dan,
Programming Active Server Pages

(Microsoft Press 1997)



Java Server Pages


Bergsten, Hans,
JavaServer Pages

(O’Reilly 2000)



PHP


Meloni, Julie,
PHP Esssentials
, (PrimaTech 2
000)



Interaction Design


Fleming, Jennifer,
Designing Web Navigation

(O’Reilly: 1998).





Sample Files


Sample files will be distributed at the beginning of each class, please bring a 3.5” floppy disk or
Zip disk to each session.



Software


You can pur
chase copies of Dreamweaver UltraDev and other software packages at student
discount from the Rutgers University bookstore at Ferren Mall in New Brunswick (across from
the train station). You will need to obtain a letter from Sharon Raynor (contact her at
sharonra@rci.rutgers.edu

to do this).


You can also purchase software online from a number of online vendors who offer academic
pricing to individuals once you have received the letter from Sharon Raynor confir
ming your
good standing in the program. Two such vendors are www.creationengine.com and
www.outpost.com. Prices and availability will vary from vendor to vendor and you will want to
check their Web sites for details.

Certificate Project/Exam


Students in
this section of Building Data Driven Web Sites will have the
option to take the Scenario Exam to receive their certificate. Details of the
exam will be discussed in class.


Internet Institute Contact Information


Problems with your iti.rutgers.edu account?


Contact Louise Forman via email at
lkforman@cs.rutgers.edu
.


Problems with payment, registration or parking permits??


Contact Jeet Kaur at 748
-
8979.