Course Description
This course studies structures of database management systems; applications of data structures; network, relational and hierarchical data models; application program development; query systems; file security; and the role of database administrators. Course uses a database management system to create the database and other software necessary for a system upgrade. (Requirement: Successful completion of a programming language course and enrollment in University Alliance.)
Course Objectives
Upon completion of this course, students should be able to
- Provide a broad understanding of Internet application construction and development
- Identify and examine the various technologies involved in rich Internet application development including XML, JavaScript, Ajax, PHP, ASP, and Flash
- Create and implement dynamic Internet applications through both client-side and server-side scripting
Week 1
Lecture: Introduction
Lecture: Introduction to Web 2.0 Development
Lecture: Usability
Outcomes
- Recognize the goals of both users and developers when creating Internet applications
- Discuss Web 2.0
- Identify how dynamic sites are created
- Discuss how usability affects web development
- Identify basic visual components such as layout, color, and text, and how they influence usability
- Explain the limits and demands of response time and how important it is to the user experience
- Identify common web interface conventions
Week 2
Lecture: Foundations: Getting Started with Rich Internet Applications
Lecture: Introducing XML and XHTML
Outcomes
- Explain what a rich Internet application is
- Identify the strengths and weaknesses of using RIAs
- Discuss the technologies involved in construction of a typical RIA
- Establish a server for testing web technologies
- Explain the concept of XML
- Explain how XHTML evolved
- Discuss the importance of DTDs
- Explain how to validate XML/XHTML markup
- Explain how XML/XHTML differ from HTML
Week 3
Lecture: Foundations CSS
Lecture: Foundations JavaScript
Outcomes
- Discuss CSS and how it affects websites
- Explain CSS attributes and properties
- Implement a basic CSS and apply it to a page
- Explain JavaScript and how it developed
- Explain the common uses for JavaScript
- Discuss JavaScript syntax
- Implement basic JavaScript functionality on a page
Week 4
Lecture: Introduction to Ajax
Lecture: Ajax Forms
Outcomes
- Explain Ajax and its technologies
- Explain the benefits of Ajax
- Discuss the importance of XMLHttpRequest
- Identify the steps of a typical Ajax request
- Implement a basic Ajax program
- Gain a deeper understanding of Ajax programming
- Implement a dynamic Ajax form
- Examine the detailed steps in the Ajax send/receive mechanism
- Identify Ajax libraries to aid in form processing
Week 5
Lecture: Ajax Effects and Animation
Lecture: Databases and MySQL
Outcomes
- Discuss the Script.aculo.us library
- Implement several Ajax effects and animations
- Implement an Ajax “Drag and Drop” effect
- Discuss MySQL and its use in RIAs
- Create a MySQL database
- Use phpMyAdmin to administer databases, tables, and fields
- Create a table using SQL
- Add new data to a table using SQL
- Update records using SQL
Week 6
Lecture: PHP
Outcomes
- Explain PHP
- Implement a basic PHP program
- Discuss the syntax and structure of PHP
- Establish a working environment for PHP web page development
Week 7
Lecture: Active Server Pages
Outcomes
- Explain what ASP is
- Compare and contrast ASP with markup and scripting languages
- Identify the strengths and weaknesses of using ASP
- Identify tools needed for developing ASP applications
Week 8
Lecture: Introduction to Ruby on Rails
Lecture: Adobe Flash
Outcomes
- Explain Ruby on Rails (RoR)
- Identify the strengths and weaknesses of RoR
- Configure a RoR environment
- Explain Adobe Flash and how it relates to RIAs
- Explore the Flash interface
- Explain keyframes and timelines
- Identify ActionScript
The course description, objectives and learning outcomes are subject to change without notice based on enhancements made to the course.