Fall 2014
Lectures
Week No |
Topics/Activities
Programming the World Wide Web, 8th Ed, Code Examples, Robert W. Sebesta |
Date |
|
1 |
*8/26 Echo 360
Recorded Lecture 1 *8/28 Echo 360 Recorded Lecture 2 *Lecture Note # 1 - Overview of the course, Discussion of Systms, Web systems, and other related topics ** Lecture Note 1 Web Systems Infrastructure and Protocols (1 of 2), 8/26-28 |
8/26, 28 |
|
2 |
* 9/2 Echo 360
Recorded Lecture 3 * 9/4 Echo 360 Recorded Lecture 4 **Lecture Note # 2 - Web Systems Infrastructure and Protocols (2 of 2) **Lecture Note 3 - Introduction to HTML & XHTML, 9/4 |
9/2, 4 |
| 3 | * 9/9 Echo 360
Recorded Lecture 5 * 9/11 Echo 360 Recorded Lecture 6 ** Chapter 2 Into to HTML/XHTML (PPT file from the text book), 9/9 ** Chapter 2 Code Examples ** e-Book - Building Web Applications with HTML, by Paul I-Hai Lin **** Chapter 8. Cascading Style Sheets: An Introduction, http://www.etcs.ipfw.edu/~lin/CECourses/2_HTML/Lectures/8CCStyle.html ** Chapter 3 Casecading Style Sheets (PPT file from the text book), 9/11 |
9/9, 11 |
| 4 |
* 9/16 Echo 360
Recorded Lecture 7 ECMAScript Language Specification Edition 5.1 (June 2011) WWW JavaScript Web APIs JavaScript Language Reference - Internet Explorer 10 e-Book: Developing Advanced Web Applications Using JavaScript, by Prof. Paul Lin Ch 1. Javascript Basics Ch 2. JavaScript System Objects and Methods 9/18 * 9/18 Echo 360 Recorded Lecture 8 Ch 3. JavaScript Keywords, Variables and Operators Ch 5. The Document and Window Objects Ch 7. Dynamic Pages with Date and Time |
9/16, 18 |
| 5 |
* 9/23 Echo 360
Recorded Lecture 9 ** Review Exam 1 coverage topics e-Book: Developing Advanced Web Applications Using JavaScript, by Prof. Paul Lin Ch 4. JavaScript Functions Ch 9. JavaScript Arrays Ch 6. JavaScript Forms and Events Ch 8. Using Cookies 9/25 - Exam 1, 3:00-3:50 PM |
9/23, 25 |
| 6 |
* 9/30 Echo 360
Recorded Lecture 10 * 10/2 Echo 360 Recorded Lecture 11 ** More on HTML 5 and, Javascripts features ** Text Book: Chapter 7 Introduction to XML ** W3C XML Technology: XML Essentials, Schema, Security, Transformation, Query, Components, Processing, Internationalization, Publishing *** W3C XML Schema Definition Language (XSD), http://www.w3.org/TR/2008/REC-xml-20081126/ *** xtensible Markup Language (XML) 1.0 (Fifth Edition), 2008/11/06, http://www.w3.org/TR/2008/REC-xml-20081126/ *** W3C XML Schema 1.1, http://www.w3.org/XML/Schema e-Book: XML and Enterprise Application Integration, by Prof. Paul Lin Ch 1. Enterprise Application Integration (EAI) - an Overview Ch 3. XML Fundamentals Ch 4. XML Document Type Definition (DTD) Ch 5. XML Schema * 10/2 Text book Chapter 7: Introduction to XML, PPT Note ** Chapter 7 XML code examples ** More XML Examples for Fall 2013, Meeting No. 24 *** Examples (data exchange, data analysis): *****Xtensible Business Reporting Langauge (XBRL) *****Electronic Business Specification (ebXML) *****Commerce XML (cXML) *****HL7 (Health Level 7 Standard: XML Implementation Technology Specification) *****IHE (Integrating the Healthcare Enterprise), IHE Domains *****CDISC (Clinical Data Interchange Standards Consortium) ***** List of XML Markup Languages *****SAS (A company provides business analytic software & services) |
9/30, 10/2 |
| 7 |
10/7 Echo 360
Recorded Lecture 12 10/9 Echo 360 Recorded Lecture 13 Oct. 7: Topics of Discussion Introduction to PHP * PHP Documentation, http://php.net/docs.php * PHP Language Reference, http://php.net/manual/en/langref.php * 10/7 Lecture note on PHP * Lin PHP Scripts Examples * Chapter 9. Introduction to PHP; Text book PHP code examples Oct. 8: Topics of Discussion * Starting XAMPP Web Server Platform, Lecture note * XAMPP Support Forum W3C CGI: Common Gateway Interface, www.w3.org/CGI/ Apache Tutorial: Dynamic Contet with CGI, http://httpd.apache.org/docs/2.2/howto/cgi.html Programming with Perl/CGI (Prof. Lin's e-Book) **Chapter 1. Web Server abd CGI/Perl Programming **Chapter 3. CGI Environmental Variables **Chapter 7. Processing and Analyzing Data * Text Book: Chapter 9 Intro to PHP (continue) * More examples |
|
| 8 |
Oct. 14 - Fall Break 10/16 Echo 360 Recorded Lecture 14 Oct. 16: Topics of Discussion Introduction to Ajax: Lin's Lecture note Chapter 10 Intro to Ajax, Author's PPT slide. Examples: popcornA.html pocornA.js getCityState.php shirt.html shirt.js Examples from Ch. 16 Ajax - Enabled Rich Internet Applications with XML and JSON, by P. Deitel, H. Deitel, and A. Deitel, published by Pearson |
|
| 9 |
Oct. 21 Echo 360
Recorded Lecture 15 Oct. 21 Topics of Discussion - Web-based Database Chapter 13 - Database Access through the Web, PPT file: Sections 13-1, 13-2 ** Relational Databases ** Databases and SQL References *** SQL, http://en.wikipedia.org/wiki/SQL *** ANSI SQL Standards, http://docs.oracle.com/cd/B13789_01/server.101/b10759/ap_standard_sql001.htm ** MySQL, http://www.mysql.com/ ** Java DB Reference, http://www.oracle.com/technetwork/java/javadb/documentation/index.html ** Oracle Database, http://www.oracle.com/us/products/database/overview/index.html ** IBM DB2, http://www-01.ibm.com/software/data/db2/ ** Microsoft SQL Server, http://www.microsoft.com/sqlserver/en/us/default.aspx ** Microsoft LINQ (Language Integrated Query), http://msdn.microsoft.com/en-us/library/vstudio/bb397926.aspx Oct. 23 Echo 360 Recorded Lecture 16 Oct. 23 Topics of Discussion - Web-based Database *Lecture Note on MySQL/XAMMP Adminstration, OBDC; MySQL Workbench, http://dev.mysql.com/downloads/workbench/ *Chapter 13 - Database Access through the Web, PPT file (continue: Text book Ch 13.4, 13-5, 13.6) *Chapter 9. Java Database Connectivty (JDBC), of the e-book, Java Application for for C/C++ Programmer, by Paul Lin Previous Presentations ** Developing Web-based Database Using Java Technology: A Tutorial, by Paul Lin and Melissa Lin, 2002 IBM International DB2 User Group Conference |
|
| 10 |
Oct. 28 Echo 360
Recording Lecture 17 10/28 Topics of Discussion: ** Exam 2 (open book exam) - scheduled on Nov. 6 (Thursday) 3:00-4:00 PM. **Discussion of Hw 8 - Web System Design Activities **Process Explorer v16.04, 2014/9/11, http://technet.microsoft.com/en-us/sysinternals/bb896653.aspx **How to determine which program uses or blocks specific TCP ports in Windows, http://support.microsoft.com/kb/281336 ** Web Based Point of Sale System, Spring 2014, CPET 491 Senior Design Project Presentation, by Jeremiah Bauer, Course Instructor Paul Lin, Project Advisor Gary Steffen Oct. 30 Echo 360 Recording Lecture 18 10/30 Topics of Discussion ** Exam 2 coverage *** Reviewed Chapater 5 - JavaScript and HTML Documents (see Echo recording) **Database Driven Rebate Tracking (DDRT), Spring 2012 CPET 491 Senior Design Project Presentation, by Aaron Egbert and Chris Rottinger, Course Instructor Paul Lin, Project Advisor Gary Steffen |
|
| 11 |
Nov. 4 Echo 360
Recorded Lecture 19 Nov. 4 Topics of Discussion: * Exam 2 Reviewed: Ch 6 Dynamic Documents with JavaScript, Ch 7 Introduction to XML, Ch 8 Intro to PHP Final Projects - Hw 8 Report amd Discussion Topics * CPET 499 Web Systems ** FormMail Application for ASP.NET, Alex Gust, http://thegustfactor.blogspot.com/2014/11/aspx-formmail-script-for-windows.html **** Alex Gust Project Web site ** Simulated Ecommerce Site, Don Ohlwine ** Clash of Clans WiKi Page, Adam Flagg * ITC 250 Web Systems ** Lawn Care Web Site Demonstration, Drew Baumgartner ** Resume Builder Web Site, Ben Pugh ** Game of Hangman, Chris Scott ** Overman Telephone Service Website, David Rash and Chris Meisner ** Web Site for Matt's Nintendo Repair and Trade, Matt Jordan ** Database Utilization in Web Systems, Tim Wages Nov. 6. Exam 2 (No Lecture) |
|
| 12 |
Nov. 11, Echo 360
Recorded Lecture 20 *Chapter 13 - PHP and MySQL Database Access through the Web, PPT file * PHP MySQL functions: *** mysqli_connect(), mysqli_query(), mysqli_num_rows(), mysqli_num_fields(), mysqli_fetch_assoc(), *** mysqli_connect_errno() * A PHP-MySQL Example carsdata.html access_card.php access_cars2.php Nov. 13, Echo 360 Recorded Lecture 21 *Computer & Web Technology Trend: Technology Trends, Live chat, Web conference/Webinar platform; Data and Analytics *E-Commerce & Business: An Introduction |
|
| 13 |
Nov. 18, Echo 360
Recorded Lecture 22 *E-Commerce & Business: An Introduction (continue) ** Facebook Innovations and IPO ** E-commerce, E-business, M-business * Web Server and Application Servers Integration: in PDF, or HTML ** HTTP/1.1, 1999, rfc2616; HTTP/1.1 RFC 7230-7237, June 2014 ** CGI: RFC3875 Nov. 20, Echo 360 Recorded Lecture 23 Nov. 20 Lecture Note in PDF, or HTML * Final Report update and due dates * HTTP Apache Status Code * CGI Standards, Variables, and Implementation on various Web servers and Apps * CGI Scripts Examples: Perl, PHP |
|
| 14 |
Nov. 25, Echo 360
Recorded Lecture 24 Nov. 25 Lecture Note in PDF, or HTML * Web Server Configuration ** Apache web server directives ** Virtual Hosts ** IPv6 ** Server Side Includes * Review and Discussion of Web System Final Project (Progress Report): Software Coding and Integration, due 11/20 (Thursday) before 3 PM Nov. 27 - Thanksgiving Break |
|
| 15 |
Dec. 2, Echo 360
Recorded Lecture 25 Dec. 2 Lecture Note in HTML, or PDF * Web Services, Cloud Computing, Amazon Web Services, Microsoft 365, Service-Oriented Architecture, Enterprise Service Bus Dec. 4. Echo 360 Recorded Lecture 26 Dec. 4. Topics of Discussion * Web Services and Cloud Computing ** Lecture on NIST Computing Defintion, Standards & Roadmap, Security and Privacy Guideline, Lecture note
CPET 491 Senior Design Projects CPET 581 E-Commerce Technology Projects CPET 598 M.S. Directed Projects |
|
| 16 |
Dec. 9, Echo 360
Recorded Lecture 27 Dec. 9 Topics of Discussion * Review and discussion of the Final Project Reports and PPT slide * End of Class review |