Course Description

Course Name:	Introduction to LAMP: PHP and MySQL
Time & Date:	6:15PM - 9:30PM, Thursdays, Nov 11, 18, Dec 2, 8, 16 (note Dec 8 is a Wednesday)
Location:	Holiday Inn Select Hotel, 15 Middlesex Canal Park Rd., Wobrun, MA
Speaker:	Jeffrey Goldberg, Qualware Instructional Services
Text:	Sams Teach Yourself PHP, MySQL and Apache All in One (4th E) by Julie C. Meloni (Author) List Price: $39.99

Prerequisite:

None. Attendees would benefit from some prior programming experience and/or exposure to a modern-day structured programming language. Also experience performing system administration tasks in the UNIX/Linux environment would be helpful.

Course Description:

The combination of Linux, Apache, MySQL, and PHP provide a very powerful, flexible, cost effective solution to a number of business problems. These four open-source technologies, collectively known as LAMP, have proven to be one of the fastest-growing ways to develop enterprise-level dynamic web-based applications. As such, LAMP is increasingly showing up in enterprise-level solutions as well as many embedded products.This course will assist you in taking full advantage of the combined power of LAMP, walking you through all the steps required to set up Linux with Apache web server, and integrate PHP and MySQL. If you’re new to all of this, you’ll quickly get to where you need to be to start developing and deploying the higher-level pieces of your web application. Even if you have experience with one or all of these technologies, this course may quick-start you on your way to setting up and/or fine-tuning your LAMP system.

This course can also serve as a fast paced, detailed introduction to everything you need to know about creating and hosting dynamic, interactive web pages, and understanding how they operate. The course will start with a quick teach/review of client-server three tier networks, in which browsers talk to web servers which in turn request data from in-house SQL (Structured Query Language) database servers. A web server running PHP/JSP/ASP is then responsible for formatting up and presenting this data as dynamic web pages.

An introduction to PHP and SQL will then follow. PHP is a widely-used, Linux/UNIX based, general-purpose modern server-side scripting language that is especially suited for Web development and can be embedded into HTML documents. It shares many of the modern constructs found in C/C++, Java, and Perl languages.

This course will also focus on using SQL within PHP HTML documents running under Apache. The course will wrap up with tips about server configurations, security, and a demonstration of how easy it is to include the contents of a SQL database within dynamically generated web pages.

Targeted for:

Individuals who would like to gain insight into the biggerpicture of how multi-tier dynamic web systems operate.The course will start by explaining the fundamentals upon which all web documents and web services are built, with special focus on using server side programming in PHP and SQL that are used to make web sites interactive. The material in this courses is appropriate for individuals maintaining pages on a provider’s server as well as those interested in setting up their own personal or company information server. This class is structured to be as interactive as possible by making use of live demonstrations that emphasis the concepts taught in the class, and personal laptop computers can be brought to class for experimentation.

OUTLINE

Session 1 - Dynamic Web and Submitting Data to a Server

Submitting Data to a Server Concepts

Client Browser/Web Server Model and Protocols

Understanding and Using Uniform Resource Locators (URL)

Server Side Includes, HTML Forms with CGI

Basic Data Passing Methods

Gets vs Post, Actions, Encoding, etc

Workload Division, Interactive Web Methods

Home Page Installation

Keeping Track of Your Web Page Visitors

Sample PHP Script

Session 2 - Introduction to Server Side PHP

PHP and Example Script

How PHP Differs and What It Can Do

Features, Parsing and Advanced Escaping

Variables and Primitive Data Types

Strings and Quoting Options

Limited Casting

PHP Arrays

Math Operator and Assignment Precedence

Comparison and Logical Operators

Conditional Branching, Decision Statements and Looping Constructs

User Defined Functions, Scope and Lifetime

Predefined Variables and Connecting to the Web Server

Simple PHP Form

Session 3 - Summary Review, Exercises and Demos

Finish up and review topics requested by attendees.

If necessary, quick overview of HTML language, tags and forms.

If necessary, quick overview of Cascading Style Sheets.

If necessary, quick overview of Linux and System Administration tasks.

If requested, will discuss installation and Configuration procedures

for Apache Web Server, MySQL, PHP

Plan exercises that demonstrate covered topics.

Session 4 - Database Connectivity using MySQL

Database Models

Introduction to MySQL Database Functionality

DB Terminology and Constraints, Supported Data Types

Setting Up MySQL Service

SQL Language Components

Controlling MySQL Database Access

MySQL Command Line Interface

Performing a Query with Select*

SQL Aggregate and Scalar Functions

Creating and Updating Tables, Interactive Demo of pets.php

Proprietary Show Command Syntax

Session 5 - Web Access of Databases, Server Customization and Control

Programmatic Access of MySQL Database Connectivity

Forms that insert information into the database tables.

Apache PHP MySQL, Browser & Network Consideration

Some Global Security and Access Control (httpd.conf, php.ini)

Apache Access Control of user directories with .htaccess

PHP track_vars feature enabled makes $HTTP_XXX_VARS available.

PHP’s Super Global Variables and new variable constructs.

Overview of Session Management and Browser Considerations

Hidden Fields, Cookies to retain state

Sessions, Browser Caching

Wrap up with question and answer session.

Lecturer’s biography:

An honor graduate of Tufts University, Jeffrey M. Goldberg has served the engineering and academic community in various roles from principal design engineer / project leader to senior consultant and educator at companies such as HP, Siemens, Picturetel, 3Com, IBM, Openwave, EMC, Harvard/MIT.Mr. Goldberg is a long-time innovative user of UNIX and networked services.He currently provides IT solution consulting (largely to 24x7 data centersthat are attempting to simplify maintenance and virtualize their servers) and delivers public seminars and on-site professional training classes, flexibly scheduled to avoid project disruption, on cutting-edge technologies, IT operations and programming languages.Specialties include Perl and Shell Scripting, Linux/Solaris/UNIX System Administration, TCP/IP Networking, Web Technologies such as Visual Basic, Delphi, JavaScript, PHP Apache, C/C++, Java/JSP and SQL Database Access, Computer and Network Security. For more information, please visit http://www.qualware.com/training or contact Jeff Goldberg at 781-229-1530 x2.copywrite 2010 Qualware Instructional Services and Jeff Goldberg.

Decision (Run/Cancel) Date for this Courses is Tuesday, November 2, 2010

FEES

Payment received by October 29: IEEE Members $395

Payment received by October 29: Non-members $435

Payment received after October 29: IEEE Members $435

Payment received after October 29: Non-members $455