Objective: This is an newly created,
intensive, fast paced one day mini-course covering everything you need to
know about creating dynamic, interactive web pages, and understanding how
they operate.
This mini-course will start with a quick
overview on the evolution of Dynamic Web Pages from the static web pages
of the early ’90s through Perl-based CGI (Common Gateway Interface) script
and server side include techniques of the mid ’90s, through VB and Java
Scripting. After a quick review of the HTML language basics
including tables, frames and forms, it will then proceed to a discussion
of the client-server three tier networks of the twenty-first century. In
these systems, browsers talk to web servers which in turn request
data from in-house SQL (Structured Query Language) database servers. The
web server running PHP/JSP/ASP is then responsible for formatting up and
presenting this data as dynamic web pages.
PHP is a widely-used, Perl and ‘C’
like-syntax, general-purpose server-side scripting language that is
especially suited for Web development and can be embedded into HTML
documents.
After reviewing the basics that are
applicable in both the Microsoft and Unix environments, this course will
teach Web Technologies services from the rarely taught Unix server point
of view. Unix platforms, rather than Microsoft platforms, are typically
the server of choice for large scalable systems such as “eBay”(r).
This course will introduce Java Script,
maybe touch upon Java Applets and JSP (Java Server Pages), but the focus
is on using SQL within PHP HTML documents running under Apache. PHP, a
Hypertext Preprocessor language, which replacesASP on Unix platforms, will
be examined in detail in the afternoon session where the course, through
demonstrations,will attempt to explain how modern interactive web pages
are designed, and how easy it is to make the contents of databases show up
dynamically as web pages.
Prerequisite: Although the course
will include a very quick review of SQL basics, it is strongly recommended
that individuals not proficient in relational databases, SQL and HTML
enrole in the Structured Query Language (SQL) Lab Crash Course scheduled
for Saturday, October 11, 2003.
Targeted for: Individuals with experience
in web browsing and creating simple web documents by hand, or experience
using a web conversion tool but having some minimal knowledge of HTML.
Some previous experience in any modernstructural programming language is
recommended. This course is for those who would like to develop a better
understanding of web capabilities and understand the bigger picture, how
the whole system works. The course will concentrate on explaining the
fundamentals upon which all web documents and web services are built, with
special focus on using Java Script and PHP to make web sites interactive.
Using demonstrations, the class will develop insight into what is possible
and is not possible on the web using current technology. 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 reviewing and emphasis the concepts taught in the
class, and personal laptop computers can be brought to class for
experimentation.
Handouts: Copies of the course
outline slides will be providedalong with relevant handouts when
appropriate.
For more info: Email to courses@qualware.com
(jeffg@qualware.com)
PRELIMINARY AGENDA:
Morning Session 1: The Evolution of
Dynamic Web Pages and an Introduction to Server Architecture
- Understanding How Server and Browser
Communicate
- Server Process and Server/Document
Root
- Submitting Data to a Server
- Client Browser/Web Server Model and
Protocols
- Common Gateway Interface
- CGI’s Stateless Environment
- 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
- Optional Page Counters, Perl Scripts
- IP Address and DNS, Security and
Performance
Morning Session 2: Basic Browser
Architecture and HTML Language
- URLs, HTML Language Basics, using
images and gifs
- Advanced HTML
- including Frames, Tables and Forms
- Input Objects, Windows and Targets
- Review HTML Tag Operation by
interactively
- creating a class home page
- Example registration form
- Demo Server-Side/Forms/CGI scripts/
- A simple visitor counter
Morning Session 3: Running Applications
Locally on the Browser
- Cascading Style Sheets
- Quick mention of VB Script
- Java Script and the Document Object
Model (DOM)
- Java Script Functions, Events and
Event Handlers
- Controlling the Browser using the
Window Objects
- Demonstration of the added features
using Java Script
- User Interaction and Data Verification
- Pop-up windows and Document.writes
- for creating client-side dynamic html
code
- Keeping Control of your browser
- Overview of Java Applets
- Introduction to using PHP
Lunch Break: 12:15pm - 1:15pm (Lunch not
included)
Afternoon Session 1: Introduction to PHP
- PHP Hypertext Preprocessor
Capabilities and Language Syntax, Compared and Contrasted to Perl
- 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;
Decision Statements and Looping Constructs
- User Defined Functions, Scope and
Lifetime; Predefined Variables and Connecting to the Web Server
Afternoon Session 2: Design Truly
Intelligent Interactive Web Pages
- Using PHP in Forms, or a Simple
Registration Form
- Using Check Boxes, Radio Buttons, Text
Boxes
- Decoding Data Sent to Your CGI Program
- Using Environment Variables
- Quick overview of the SQL Language
- PHP’s interface to SQL and Database
- Database Connectivity using MySQL
- Introduction to MySQL Database
Functionality
- DB Terminology and Constraints,
Supported Data Types
- Class Database Demonstration Exercise
- Creating and Updating Tables,
- Interactive Demo of pets.php
Afternoon Session 3: Web Statistics,
Administration and Management
- Web Server Configurations
- Setting Up Apache, MySQL Service
- PHP Security and Configuring Access
Control
- Restricted Access and Password
Protection
- Demo Apache Access Control of User
Directories
- Database and Security Issues
- Controlling MySQL Database Access
- Hidden Fields, Cookies to retain state
- Demo mysql.php as a generalized
database access script.
- Create a form to inserts info into the
pet dabtabase.
- User Logging and Visitor Information
Data Collection.
Live interactive demo on many of the topics
discussed. This will be a 8:30 am to 5 pm Saturday session with a 12:15 -
1:15 pm lunch break.
Lecturer’s biography: Jeffrey
Goldberg is a long time innovative user of UNIX and Internet services. Mr.
Goldberg currently develops and teaches courses on Unix Fundamentals,
Shelland Perl Programming, Unix System Administration and Security, TCP/IP
NetworkAdministration in a Multi-Platform Environment, Introduction to
Programming, Basic and Advanced Visual Basic Programming incorporating SQL
Database Access, Web Technologies such as VB Script, Java Script, Java,
Visual ‘C’ and ‘C++’, for Worcester Polytechnic Institute and Boston
University. Mr. Goldberg is continually adding new cutting-edge technology
to his curriculum, and accepts requests for customized on-site corporate
training classes. New course available this fall: Development of Dynamic
Web Pages Using Apache, SQL and PHP on a Unix Server. Besides operating
Qualware Instructional Services, Mr. Goldberg is also a principal of
Qualware Consulting Group, which designs electronics for faulttolerant
networks, specialized network adapter hardware and embedded
customizedcontroller cards. Mr. Goldberg has recently form a new company
called Qualware Internet Services specializing in Internet/Intranet
security, application servers, web hosting, and dynamic web applications.
For more information, e-mail to
training@qualware.com or contact Mr. Goldberg at 781-229-1530 or
j.goldberg@ieee.org or
www.consultme.com/qualware