Duration: 2 days
• Price: $1180.00 or £720.00 +VAT
(with hotel room), or
$1000.00 or £600.00 +VAT
(without room), •
Venue: Melksham, England
COURSE START DATES
|• Thursday 24 April 2014||• Wednesday 20 August 2014|
|• Wednesday 17 December 2014|
The major part of this course covers the installation and the configuration of
the Apache httpd web server under the Linux operating system. We also have sections on a
number of associated technologies (MySQL, XML, and the Perl, PHP and Python languages) so
that you'll be able to administer web servers running deployed LAMP applications such as
PHPbb, SMB, YaBB, OS-Commerce, or applications you've had specially written.
Basic user and administration knowledge of Linux (as taught on Linux Basics
one day courses). Knowledge of a Unix operating system to a similar level is an
Getting the most from your Well House Consultants course
The Apache httpd web server, installed on Linux, is perhaps the most
often used web server / operating system combination in the world. This
course covers the installation, configuration and maintainance of an
Apache httpd web server within the Linux environment. Regular tasks
include analysing server usage, taking backups, configuring extra
domains, and dealing with security issues and management reports.
|Server Side Technologies (module W603) When do I want to use server side technologies?.
Anatomy of a Web Server.
Web Server Security.
Web Server support for page authors.
Server upload technologies.
FTP / Telnet.
Disk Networking system.
Serverside Interface Methods.
The HTTP standard.
The Common Gateway Interface (CGI).
Server Side Includes.
Active Server Pages.
Your own server.
Other Interfacing methods and a comparison.
Cookies, sessions and shopping carts.
Scale of use.
Further Serverside examples.
|HTML for Web Application Authors (module Q625) Tables.
Element types within a form.
The script used.
Objects and images within a web page.
|HTTP (module A207) HTTP Headers, Heads and Bodies.
GET, POST and other methods.
MIME Types, Cache Controls and other headers.
Uses of Cookies.
|Apache httpd - an overview (module A601) What is Apache?.
Apache httpd capabilities.
Authentication and secure service.
Other Web Servers.
|Apache httpd - Sourcing, Installation, Testing (module A602) Sourcing Apache httpd.
The user account under which to run the web server.
The address of the web site administrator.
Changing the location of files on the web site.
Allowing more than just serving files!.
Allowing individual users their own web sites.
Configuring log files.
Setting up a separate cgi-bin directory.
Changing your error report pages.
Getting server status reports through the web.
Installing and Configuring httpd on Windows.
Testing your installation.
Testing the basic web directory and home page location.
Testing the userŐs home directory web sites are working.
Testing the server status and server info pages.
Testing your error page.
Testing for the presence and operation of a PHP script.
Testing for the presence and operation of server side includes.
Testing the operation of a .cgi program (written in Perl).
Testing the cgi-bin directory.
Testing wider services.
|Further httpd Configuration (module A603) Automatic Start-up.
Name-based Virtual Hosts.
IP-based virtual hosts.
|Introduction to SQL and MySQL (module S151) Information organisations.
The structure of a typical RDBMS.
Accessing a relational database from the Web.
Database access protocols.
Distributions and licenses.
Component parts of MySQL.
Versions of MySQL.
When should I choose MySQL?.
|SQL Primer as Used in MySQL (module S152) The structure of a database as seen by SQL.
Hello SQL World.
Initial administration and error handling.
Field types and modifiers in MySQL.
Floating point (real) numbers.
Whole (Integer) numbers.
One or more values from a pre-defined list.
Dates and Times.
A note on reserved words.
Commands to enter new rows of data.
The INSERT command.
The REPLACE command.
The LOAD command.
Returning table report information.
Commands to modify existing rows of data.
The UPDATE command.
The DELETE command.
Commands to modify the metadata.
The ALTER Command.
The DROP command.
The SHOW command.
On limiting selection.
Joining tables when selecting rows.
Extra use of SELECT.
Some more advanced SQL.
Loading data from file.
More on joining.
A regular "join".
A left join.
Joining across databases?.
|Sourcing, Running and Configuring MySQL (module S153) Overview.
A potted installation procedure.
For use on our training systems.
Installing MySQL onto your laptop.
Install the Perl DBD and DBI modules.
Testing your Installation.
Running the MySQL daemon.
Programs for the user and administrator.
Using the mysqladmin program.
Using the mysql client program.
Managing user accounts and privileges.
Adding an account.
Adding Additional privileges on a per-database basis.
Additional access on a per-host, per table and per-column basis.
Disk structure of data held in a MySQL database.
The data directory.
Setting up security and levels of access.
O/S level and web-level access.
Log in access to MySQL.
Four levels of access within MySQL.
Backing up your database.
Dumping by table.
Accessing mysqld from around your network.
|XML, DTD, XSLT, XHTML and More (module A301) What is XML?.
The structure of an XML document.
Examples of XML documents.
Alternatives to XML.
When to choose XML and when to use a database.
Defining data types with DTD and XML schema.
Parsing XML - SAX and DOM.
SAX code example.
DOM code example.
Formatting XML data with XSLT descriptors.
Accessing XSLT from programs.
|Web Application Design and Deployment (module A211) Planning your application.
The store front page.
Under the hood.
Adding to the shopping cart.
The final phase.
Complete carter.php4 file.
|Secure Service and Credit Cards (module A212) Using a secure server for credit card details.
What is SSL and https?.
How can you use https?.
Programming implications for using a secure service.
Programming to use an electronic payment system.
Credit card agreements.
|Introduction (module P201) What is Perl?.
Perl is a computer language.
What does Perl cost?.
What is Perl used for?.
What computer do I need to run Perl?.
Is Perl loaded onto my computer?.
Perl on Unix (including Solaris and Mac OS X).
Perl on Linux.
Perl on Windows.
How do I find what version I have?.
Macintosh OS X.
Windows 98 / Windows 2000 / Windows NT / Windows XP.
Macintosh OS 9 and earlier.
Loading Perl (Windows XP).
Examples of Perl in use.
Screen locator and counter.
A changing web page.
|Perl on the Network (module P252) Network structure.
Programming for networks.
Providing your own client.
Providing your own server.
Providing your own service.
Building in to an existing service - email.
Building in to an existing service - the web.
|The Common Gateway Interface (module P403) The mechanism of the web.
The need for Server Side Programming.
The structure of the server.
Your first CGI program.
Use perl -c.
Check with your ISP.
|Introduction to PHP (module H101) What is PHP?.
What hardware and software do I need?.
Linux and Unix.
Windows (98, NT, 2000, Millennium, XP).
What does PHP cost?.
|A First PHP Web Page (module H102) Writing and uploading.
The structure of a PHP page.
Sequences of statements.
|Designing PHP-Based Solutions: Best Practice (module H115) Thinking through your design.
Tools to help you design.
Designing a smaller application example.
A note on using PHP in a Web environment.
Writing maintainable code.
Use of functions and include files.
And all the languages in one file?.
Writing code for different databases.
Error handling and software testing.
Expect the unexpected and check everything.
Error numbering and handling.
Data validation, sessions, XML/XSLT, SQL.
|Introduction to Python (module Y101) What is Python?.
Running Python from the command line.
Running Python from a file - "Hello Python World".
Obtaining and installing Python.
Downloading from www.python.org.
Downloading from ActiveState.
Downloading from Plone.
What is Python good for?.
Where did the Python name come from?.
|Commercial and Legal Aspects (module A213) Why discuss this on a technical course?.
Data Protection Act, 1998.
Freedom of Information Act, 2000.
Privacy and credit card security.
Unsolicited commercial emailing and mailing lists.
Other content issues.
Who is the publisher?.
Registration agencies - the shady dealers.
Backups and security.
Ease of use.
Marketing and visibility.
TUTOR and COURSE AUTHOR
Graham Ellis - firstname.lastname@example.org
] [about Graham
, England. A taxi transfer can be arranged if you'll be arriving by air
from United States.
can be arranged on site in your country.
Public courses run at
Well House Manor
- our own
purpose fitted training centre and business hotel / conference centre in
• Download Melksham Map - [pdf file (750k)
] • Google Map - [Link
|| 2 students
|| 3 students
|| For 4 or more students
from the same company,
please consider a private course.
| With hotel room
($1416.00 inc VAT) or
(£864.00 inc VAT)
($1200.00 inc VAT) or
(£720.00 inc VAT)
| With hotel rooms
($2712.00 inc VAT) or
(£1608.00 inc VAT)
($2280.00 inc VAT) or
(£1320.00 inc VAT)
| With hotel rooms
($4008.00 inc VAT) or
(£2352.00 inc VAT)
($3360.00 inc VAT) or
(£1920.00 inc VAT)
• Multiple discount applies to bookings for second and subsequent delegates on the same running of a course, and on same order.
• Hotel rooms are available for arrival the night before the course starts, for departure after the end of the course on the last day.
This course covers the deployment of applications written in Perl, PHP or Python,
and possibly using MySQL and XML, on Linux Web servers with the Apache httpd web server.
If you'll be writing your own applications or you'll be maintaining code, you might also
want to consider our programming courses such as Learning to program in Perl
, PHP Programming
, Python Programming
Upon completion of your course, you'll have online access to the source code of
all the examples from the course, and you'll have access to the
"Ask the Tutor" forum
where you can raise questions. We also encourage you to email the tutor, and
to visit us again to use our library as appropriate.
Certification? - [Link
FOR FURTHER INFORMATION
Public (scheduled) courses
For more information about our public courses in general, such as class size, course times, materials provided, special requests, accommodation list, finding our centre, etc.
Terms and Conditions
Covering topics such as delegate substitution, payment, cancellation policy and other matters.