PHP/SQL 3: Seamless Web 2.0 Integration

Estimated Release: 09/15/2008

 

Course Details and Syllabus

 Enroll
Course: PHP/SQL 3: Seamless Web 2.0 Integration
Tuition: $398
Time Frame: Due to our monthly lab fee system, this course is completely self-paced. You can expect to work approximately 40 hours on this course.
Technical Requirements: As long as you have a web browser and internet connection, you can take this course from anywhere in the world.
CEUs: 4 Continuing Education Units with official letter from the University of Illinois Office of Continuing Education.
Software: The web-based Learning Sandbox® provided for you will contain all your lessons, projects, quizzes, account files, editors, and programming tools necessary to build your skills from beginning to end, even beyond coursework. In addition, you'll be provided with a mySQL account that can be accessed through the Sandbox or, if you prefer, any normal SSH program. No other software is needed.
Instructor: You will have one instructor throughout the course who will evaluate your projects and quizzes, hand them back for improvement when necessary, and coach you throughout your skills advancement.
Book: All required course materials and software are included online within the Learning Sandbox®. However, within a few weeks of enrolling, you'll receive the free book Web 2.0: A Strategy Guide as a complimentary reference from O'Reilly.
Certificates: Completion of this course counts toward the PHP/SQL Certificate Series.
Prerequisites: Introduction to PHP, PHP/SQL 1: Introduction to Database Programming, and PHP/SQL 2: Relational Theory and Logical Design, or equivalent skills in PHP and SQL. This course is meant for the intermediate or advanced database programmer.
Syllabus:
  • PHP/SQL 3 Lab 1 -- Introduction and Review
    • How to Learn using OST Courses
    • Understanding the Learning Sandbox
    • Using the PHP DBI, Revisited

  • PHP/SQL 3 Lab 2 -- The Client Side
    • The Evolving Web Experience
    • Seeing through a User's Eyes
    • Rules of Thumb for Web-Based UIs
    • Validating Forms

  • PHP/SQL 3 Lab 3 -- The Server Side
    • PHP Traps
    • Ensuring Reusability
    • Ensuring Portability
    • php.ini and .htaccess
    • Rules of Thumb for Software Design

  • PHP/SQL 3 Lab 4 -- The Third Tier
    • The Web as a Melting-Pot for Technology
    • System Calls
    • What are APIs?
    • Parsing XML
    • HTTP REST Calls
    • AJAX, JavaScript and Other UI Enhancements

  • PHP/SQL 3 Lab 5 -- The User's Environment
    • Platform Consistency
    • Cookies and Sessions
    • Firewalls, Popup Blockers, and Spam Filters

  • PHP/SQL 3 Lab 6 -- Making Money Online
    • Choosing the Right e-Commerce Direction
    • Privacy and Security
    • Processing Credit Cards
    • Generating PDF Invoices

  • PHP/SQL 3 Lab 7 -- Preventing Fraud
    • IP Suppression
    • Image Code Generation
    • Ensuring Form Data Integrity
    • AVS and CCID
    • In the Future...

  • PHP/SQL 3 Lab 8 -- Know Thy User
    • Tracking User Activity
    • When does Membership Make Sense?
    • Dynamic Customization
    • Preventing User Turn-Off

  • PHP/SQL 3 Lab 9 -- Planning a Web 2.0 Project, part 1

  • PHP/SQL 3 Lab 10 -- Planning a Web 2.0 Project, part 2

  • PHP/SQL 3 Lab 11 -- Planning a Web 2.0 Project, part 3

  • PHP/SQL 3 Lab 12 -- Planning a Web 2.0 Project, part 4

  • PHP/SQL 3 Lab 13 -- FINAL PROJECT: Your Web 2.0 e-Commerce Site
Enroll
Learn and Achieve - Enroll Now

Earn a Certificate

for Professional Development from the University of Illinois' Office of Continuing Education upon completion of a selected series of courses.

Illinois