Prerequisite:

No prior experience is required, but attendees would benefit from prior programming experience or knowledge of a modern-day structured programming language. Familiarity with Web browsing and Windows 98/NT/2000/XP graphical user interface would also be helpful.

Class Description:

Dynamic Web Server-Side Technologies Overview. This is an newly created, fast paced, detailed introduction to everything you need to know about creating dynamic,  interactive web pages, and understanding how they operate.

This mini-course will start with a quick teach/review of HTML language basics including tables, frames and forms, cascading style sheets and XML, and then proceed to a  discussion of the client-server three tier networks. In these systems, 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 bigger picture 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.  Although this is not a lab course, the 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.

PRELIMINARY DETAILED AGENDA:

Session 1-  Introduction to HTML

    Introduction to HTML tags

            Code example of a homepage

            Using head, meta, body, breaks, image and anchor tags

            Common (list, escape, formatting) HTML tags

            Additional HTML tags including details on:

            Using fonts, colors, transitions

            Using lists, tables, borders

            Using links, anchors, mailto

            Using images and gifs

    Advanced HTML:

            Forms and input objects

            Frames, windows and targets

            Introduction to scripts

            Example registration form

            Basic form HTML tags

            Advanced form HTML tags

Session 2-  XML and Cascading Style Sheets

    Cascading Style Sheets

            Style properties

            Style types (inline, global, linked)

            How and why you implement them

            Introduction to XML

            Basic XML

            Clients reading XML documents as source of data

            Overview of Capabilities of Java Script without programming details

Session 3-  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 4-  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 5-  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 6-  Web Access of Databases, Server Customization and Control

    Pro grammatic 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 Varables*

            Overview of Session Management and Browser Considerations

            Hidden Fields, Cookies to retain state

            Sessions, Browser Caching

            wrap-up.         

Handouts:

Copies of the course outline slides will be provided along with relevant handouts when appropriate.

For more info:

email to jeffgieee@qualware.com or call 781-229-1530 x2.

Lecturer’s biography:

An honor graduate of Tufts University, Jeffrey M. Goldberg has served the engineering and academic community in various roles from principle design engineer/project leader to senior consultant and trainer at companies such as Hewlett Packard, Siemens, Picturetel, 3Com, IBM, NMS, and EMC. Mr. Goldberg is a long-time innovative user of UNIX and Internet services.  He currently develops and delivers public seminars and customized corporate training classes along with very flexible scheduling, to avoid project disruption, in the fields of IT operations, operating system and computer languages. Specialties include UNIX Fundamentals, Perl and Shell Scripting, Linux/Solaris/UNIX System Administration and TCP/IP Networking, Web Technologies such as Visual Basic, Delphi, Java Script, PHP Apache, C/C++, Java and SQL Database Access, Computer and Network Security.  For more information, please contact Jeff Goldberg at 781-229-1530 x2, jeffg@qualware.com or just visit http://www.consultme.com/training (or www.qualware.com this fall). 

Decision (Run/Cancel) Date for  this Courses is Monday, October 24, 2005

Course Fee Schedule:

On-line Registration and Payment

This course has been cancelled.  Please contact office if you have any questions.

Copyright © 2004 IEEE Boston Section. All rights reserved.
Maintained by R M Stelting

Updated Thursday June 28, 2007