Capt. Horatio T.P. Webb
MIS 4372 Transaction Processing II
Parks -- Sprign 2009
Version 1 -- Last Updated 12:00 PM 1/21/2009
NOTICES:
  • Final exam (here) Due 5:30 PM Fri May 8, 2009
  • Midterm exam answers (here)
  • Visual Web Developer (here). Visual Web Developer 2008 is a free download from Microsoft. SQL Server Express is also available on the same page.
  • Get WS_FTP at http://www.wsftp.com/ (then click the "DOWNLOAD" tab for an evaluation copy)
  • Your Resume needs top be posted on the new Bauer Career Gateway. Go to the Bauer Career Center web site (here). We hope to use this system as the Bauer College's primary resume depository.  If you plan to graduate spring, summer or fall, be sure you are registered with the University Career Center. Most of the firms use the University Career Center (here) to setup interviews for both internships and full time employment.  So, get registered at BOTH of the locations ASAP.
  • We will be using MS Visual Studio for program develoment. How to obtain your own student version will be discussed in class.
  • Assignments 1, 2 and 3 will only be evaluated on the final exam (these will not be graded separately).
  • Server accounts will be assigned after the 12th class day
    • COURSE SUMMARY: This course is the second part of a two course sequence on transaction processing in the clent-server environment. This second course concentrates on server-side processes involving submission and processing transaction information across the Internet. The primary technologies employed are: HTML, XML, XSL, WSH, Microsoft's Visual Studio and ASP.NET 3.5 (VB.NET and C#), Microsoft SQL Server emphasizing XML. We will also examine the LINUX and PHP alternatives.

    The course will discuss two major technologies. In the first half the course will present server side scripting options and the second half will discuss Microsoft's server-side ASP.NET 3.5 and Visual Studio technologies.

    TEXTS: We will not start using this textbook until FEB 23.
    Beginning ASP.NET 3.5: In C# and VB by Imar Spaanjaars
    Wrox (Wiley)
    ISBN: 978-0-470-18759-3
    March 2008
    OFFICE HOURS: MW 1-2:30 MW 280E Melcher Hall
    or
    by appointment 713-743-4729
    GRADING: There is one in-class exam (MON MAR 30). There will also be a take-home exam 2 that will be distributed in class on MON MAY 4 and be due MON MAY 8 at 5:30 PM. All grading issues are handled in-person during office hours. Do not send e-mail to the instructor regarding any grading issue. Grades assigned for drops after MON FEB 2 (last day to drop without receiving a grade) will be based on your current class grade. If you have a failing grade at the time of the drop, you will receive an F otherwise a W.
    Exam 1 35%
    Exam 2 40%
    Programming Assignment #1 5%
    Programming Assignment #2 10%
    Programming Assignment #3 10%
    DATE
    TOPIC
    Assignment
    ASP.NET 3.5 Textbook Chapter
    WED JAN 21 Introduction to the Transaction Processing in the Client/Server Environment
    MON JAN 26 Traditional ASP and SQL -- Part I
    WED JAN 28 Traditional ASP and SQL -- Part II
    MON FEB 2 Server Processes: How your NT Server accounts and SQLServer DSNs are created (word doc)
    Request Variables servar.asp (see asp code servvar.htm)
    MON FEB 2 Last Day to Drop without receiving a grade
    WED FEB 4 Object Models Overview (reference)
    MON FEB 9 Traditional asp template example ( source code)
    SQL Server and ADO Fundamentals ( reference)
    Traditional ASP Examples -- Column #1 only
    UDA is: ADO/RDS/OLEDB/ODBC
    Universal Data Access site at Microsoft
    WED FEB 11 Command Parameters (source) and Error Collection (source)
    Audit Controls
    MON FEB 16 Text File Processing
    Dave Whalen's Cookie FAQ
    Client-Side Cookie examples (write,read,kill in both VBScript and Javascript)
    Sample assignments
    WED FEB 18 XML in traditional ASP:
    The XML DTD
    Receiving and Displaying XML on the Client
    Creating XML on the Client (this is AJAX see here)
     . IE Example AJAX for GL Account Query
     . Cross Browser Example AJAX for GL Account Query
    Receiving and Creating XML on the Server
    Sending XML from the Server to the Client
    Boatwright & Higdon's Complete XML example
    Walking the XML tree
    Computerworld 10/30/2000 XML--tree vs. relational tables
    Example AJAX for GL Account Query
    RSS Examples
    MON FEB 23 .NET 2 Framework
    Visual Studio Introduction
    Simple ASPX Examples (see the C# and VB.NET columns)
    		 Chaps 1,2,3
    WED FEB 25 .NET Languages at MSDN
    VB.NET Language
    C# Language     		Chaps. 4 and 5
    MON MAR 2 ASP.NET Pages Chap. 6
    WED MAR 4 Server Controls Chaps. 7,8,9

    Assignment 1 should be finished
    MON MAR 9 Web Forms I Chap 10
    WED MAR 11 Web Forms II Chap 11
    MON MAR 16
    Spring Holiday
    		 Chap 12
    WED MAR 18
    MON MAR 23 ADO/XML in .NET
    Data Binding
    Visit your database restore page ( source code)
    Updating SQL in .NET
    XML in .NET
    Web Applications     		Chaps 18 and 19
    WED MAR 25 Exam Review
    MON MAR 30
    Exam 1 in class (scripting)
    Sample midterm exams:
    Spring 2008 Midterm, Fall 2008 Midterm, Spring 2008 Midterm, Fall 2007 Midterm, Fall 2000 Midterm, Fall 2001 Midterm, Fall 2002 Midterm, Fall 1999 Midterm, Spring 2001 Midterm, Spring 2002 Midterm
    Assignment 2 should be complete
    WED APR 1 Post-exam Review Chap 23
    MON APR 6 Security
    SQL Injections -- Part I (here)
    Injections and other Nasties-- Part II (here)
    Regular Expressions
    A Simple Encrypt/Decrypt VBScript Security
    .NET Collections
    Server Controls
    Web Services
    NOTE: Last day to Drop (TUE APR 7 Last Day to Drop)
    WED APR 8 XML with MS Server 2000 Introduction
    FOR XML RAW
    FOR XML AUTO ELEMENTS     		ADO/XML
    MON APR 13 XML/HTTP
    WED APR 15 ASP PHP Comparison (here)
    Email using CDONT (here)
    MON APR 20 Web Crawling (here)
    WED APR 22 OpenXML
    .net graphics
    MON APR 27 COBIT (see MIS 4373)
    WED APR 29 COSO/ERM and ITIL (see MIS 4373)
    MON MAY 4 EXAM 2 -- districuted in class
    Due back to Room 280E MH 5:30 PM FRI MAY 8

    Sample Exams:
    Spring 2009, Fall 2008, Spring 2008, Fall 2007, Spring 2007, Fall 2006, Spring 2006, Fall 2005 Final, Spring 2005, Fall 2004 Final -- Part 1, Fall 2004 Final -- Part 2, Fall 2003 Final -- Part 1, Fall 2003 Final -- Part 2, Spring 2003 Final -- Part 1, Fall 2002 Final -- Part 1, Fall 2002 Final -- Part 2, Spring 2002 Final -- Part 1, Spring 2002 Final -- Part 1 answer, Spring 2002 Final -- Part 2, Fall 2000 Final -- Part 1, Fall 2000 Final -- Part 2, Spring 1999 version 1, Spring 1999 version 2, Fall 1999 version 1, Fall 1999 version 2, Fall 1998, Spring 1998 version 1, Spring 1998 version 2, Spring 1998 version 3 Spring 1998 version 4

    		3rd Assignment (All assignments should be complete and ready for take-home exam

    Take-home Exam due back to the instructor's office (280E MH) by 5:30 FRI MAY 8

    IMPORTANT DATES
    MON FEB 2 Last Day to Drop without receiving a grade.
    MON-FRI MAR 16-20Spring Holiday
    MON MAR 30 Exam 1 (in class)
    TUE APR 7 Last Day to Drop or Withdraw
    MON MAY 4 Final Exam (pick up in class, return Friday MAY 8, 5:30PM)