Course: PHP/MySQL 3: Web Integration

Software: The web-based Learning iway 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 iway 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 iway .Within a week of enrolling, you'll receive the free book Web 2.0: A Strategy Guide as a complimentary reference.

Certificates: Completion of this course counts toward the PHP/MySQL Certificate.

iway: Life long account on the iway, where you can download reference material and ebooks for life.
One Domain, 1GB web space, 2 Email id's @ your domains free as per policy. 

Fees: Rs 8000/-

Prerequisites: Basic 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:

• Lab 1 -- Introduction

  • Understanding the Learning iway

  • Logical Design Review

  • Translating Design into SQL

• Lab 2 -- Introduction to Web 2.0, Part 1

  • Web 2.0 Example: A Social Bookmarking Site

  • Web 2.0 Concept: The Web as a Platform

  • Service-Based vs. Packaged Software

• Lab 3 -- Introduction to Web 2.0, Part 2

  • Web 2.0 Concept: Data as the 'Intel Inside'

  • User-Generated Content

  • Web 2.0 Concept: Harnessing Collective Intelligence

• Lab 4 -- The Back End: Safety and Portability

  • Safety Through Organization

  • Portability Through Abstraction

• Lab 5 -- The Back End: Re-usability

  • Re-usability Through Libraries

  • Extensibility Through Public API

  • Utilizing PHP Configuration Directives

  • PEAR: Collaboration Through User-Contributed Repositories

• Lab 6 -- The Front End: User Interface

  • Consistent Navigation

  • Detection and Customization

  • Keeping Above the Fold

• Lab 7 -- Web 2.0 Principle: Customer Self-Service

  • Member Self-Reliance

  • User Self-Governance

  • Making Political Judgments

• Lab 8 -- Object-Oriented PHP

  • Classes, Properties, and Methods

  • Object Instantiation and Class Scope

  • Inheritance and Polymorphism

  • Object Types

• Lab 9 -- Advanced Concepts in Object-Oriented PHP

  • Constructors and Magic Methods

  • Encapsulation Through Access Control Modifiers

  • Advanced Access Control: Abstract, Final, and Static

• Lab 10 -- Incorporating OO Design into Web 2.0 Principles

  • Web 2.0 Principle

  • Back-End Tag Capability

  • Web 2.0 Example: An Object-Oriented Tag Cloud

  • Incorporating Tag Clouds in User-Generated Content

• Lab 11 -- Web 2.0 Concept: Lightweight Programming Models

  • RSS and XML

  • Using XML as a Communication Tool

  • Reading RSS Feeds for Remix-ability

• Lab 12 -- FINAL PROJECT: Your Own Web 2.0 Site