PHP/SQL 3: Seamless Web 2.0 Integration

In this course, you will learn advanced User Interface techniques using PHP and SQL, and will learn to build a dynamic website as a whole, using efficient and reusable code and seamlessly integrating Web 2.0 design patterns, object-oriented PHP, and other technologies and techniques.

Upon completion of this course, you will be able to:

• Demonstrate knowledge of the major Web 2.0 concepts: Web as a Platform, Data as the “Intel Inside,” Collective Intelligence, Customer Self-Service, Folksonomy, and Lightweight Programming Models.
• Build back-end code that demonstrates reusability, extensibility, safety, and portability.
• Create a front-end user interface that employs consistent navigation, customization, and professional use of online real estate.
• Implement object-oriented PHP elements such as classes, objects, scope, inheritance, polymorphism, magic methods, encapsulation, and access control.
• Develop a full-fledged Web 2.0 web site from scratch.

From beginning to end, you will learn by doing SQL-based projects and submitting them for instructor feedback.  These projects, as well as the final project, will add to your portfolio and will contribute to certificate completion.

This course counts toward the PHP/SQL Programming Certificate Series.

Prerequisites: PHP/SQL 2: Relational Theory and Logical Design, or equivalent skills.  This course is meant for the intermediate or advanced database programmer.

90 Clock-hours  6 CEUs  $398.00 $278.60

Course Details and Syllabus

Course:	PHP/SQL 3: Seamless Web 2.0 Integration
Tuition:	$398 $278.60
Time Frame:	This course is online and self-paced. You can expect to work approximately 90 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:	6 Continuing Education Units with official letter from O’Reilly Media.
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 e-book Web 2.0 A Strategy Guide as a reference resource 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 How to Learn using O’Reilly School of Technology Courses Understanding the Learning Sandbox Logical Design Review Translating Design into SQL PHP/SQL 3 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 PHP/SQL 3 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 PHP/SQL 3 Lab 4 — The Back End: Safety and Portability Safety Through Organization Portability Through Abstraction PHP/SQL 3 Lab 5 — The Back End: Reusability Reusability Through Libraries Extensibility Through Public APIs Utilizing PHP Configuration Directives PEAR: Collaboration Through User-Contributed Repositories PHP/SQL 3 Lab 6 — The Front End: User Interface Consistent Navigation Detection and Customization Keeping Above the Fold PHP/SQL 3 Lab 7 — Web 2.0 Principle: Customer Self-Service Member Self-Reliance User Self-Governance Making Political Judgments PHP/SQL 3 Lab 8 — Object-Oriented PHP Classes, Properties, and Methods Object Instantiation and Class Scope Interitance and Polymorphism Object Types PHP/SQL 3 Lab 9 — Advanced Concepts in Object-Oriented PHP Constructors and Magic Methods Encapsulation Through Access Control Modifiers Advanced Access Control: Abstract, Final, and Static PHP/SQL 3 Lab 10 — Incorporating OO Design into Web 2.0 Principles Web 2.0 Principle: Folksonomy Back-End Tag Capability Web 2.0 Example: An Object-Oriented Tag Cloud Incorporating Tag Clouds in User-Generated Content PHP/SQL 3 Lab 11 — Web 2.0 Concept: Lightweight Programming Models RSS and XML Using XML as a Communication Tool Reading RSS Feeds for Remixability PHP/SQL 3 Lab 12 — FINAL PROJECT: Your Own Web 2.0 Site