Duration: 2 days • Price: £720.00 +VAT (with hotel room), or £600.00 +VAT (without room), • Venue: Melksham, Wiltshire

---

• Thursday 28 August 2008

• Wednesday 10 December 2008

This course is offered under our options program. Early booking is recommended. 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 and Linux Administration one day courses). Knowledge of a Unix operating system to a similar level is an acceptable alternative.

Getting the most from your Well House Consultants course [Link] 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) CGI and fast CGI. ASP, JSP and PHP. Servlets. Apache modules, Jserv, Jrun, Tomcat, etc. VBScript, JavaScript, PerlScript. Perl, C, Tcl, Java and others. Cookies, sessions and shopping carts.

HTML for Web Application Authors (module Q625) Frames and Images. Style Sheets. Applets and other Objects.

HTTP (module A207) HTTP Headers, Heads and bodies. GET, POST and other methods. MIME Types, Cache Controls and other headers. Maintaining State. Hidden fields and Cookies. Use of Cookies.

Apache httpd - an overview (module A601) What is "Apache" and what does it do? Other web servers. Versions of Apache.

Apache httpd - Sourcing, Installation, Testing (module A602) Downloading Apache. Selecting a user account under which to run Apache. Initial mandatory configuration. Testing your installation. Running apache as a daemon.

Further httpd Configuration (module A603) Available Modules and turning them on and off. Assosciating file extensions with modules.

Introduction to SQL and MySQL (module S151) Information organisations. What is a relational database? What are the parts of a relational database? What relational databases are there? MySQL, MySQL-Max and MySQL-GUI. What is MySQL? Why choose it?

SQL Primer as Used in MySQL (module S152) The structure of a database as seen by MySQL. SQL introduction. "Hello SQL World". Databases, tables, fields, rows and columns. Field types and modifiers. Initial administration and error handling. Commands to enter and edit rows of data - Insert, replace and load. Enquiry (select) commands. Conditional clauses and writing conditions. Command to modify and delete rows. DROP, SHOW and others.

Sourcing, Running and Configuring MySQL (module S153) Sources of SQL. The mysqld daemon process. How MySQL fits into your scheme - stand-alone clients. How MySQL fits into your scheme - Web users. The mysqladmin and mysql client programs. Managing user accounts and priviledges. Backing up your database. Table types MyIsam, Isam, Hash, InnoDb and BDB. Accessing mysqld from around your network.

XML, DTD, XSLT, XHTML and More (module A301) What is XML? When should it be used? Structure of an XML document. Alternatives to XML.

Web Application Design and Deployment (module A211) Choosing the right technologies. Server side and client side elements. Design principles - design for the customer. Development server, test server, live server. How on line payment applications work.

Secure Service and Credit Cards (module A212) Why use a secure server. Getting a secure server certificate. Sharing a secure server certificate. Security issues not addressed by a secure server.

Introduction (module P201) What is Perl? What computers does Perl run on? Is Perl loaded on my computer (and if not, where do I get it?) Versions of Perl. Examples of Perl in use.

Perl on the Network (module P252) How Perl can be used on a network. Network structure. Programming for networks. Server embedded applications. Client side applications. Data Munging for the Web.

The Common Gateway Interface (module P403) The mechanism of the Web. The need for server-side programming. Web server structure. Your first CGI program. Error handling. Checking with your ISP or webmaster. Forms. URL encoding. Encoding the returned page.

Introduction to PHP (module H101) What is PHP? What hardware and software do I need? Examples of PHP in use. Whys use PHP rather than the alternatives? When and where is PHP available? Versions of PHP (3 v 4).

A First PHP Web Page (module H102) How do I enter and edit a PHP script? Adding PHP within an HTML page. How do I run a PHP Script? First Script - including the day of the week in a web page. Sequences of statements. Editing and debugging your PHP. Commenting your PHP. Debugging techniques.

Designing PHP-Based Solutions: Best Practice (module H115) Analysing the requirement and designing the Application. The batchlet model and multi-task PHP scripts. Writing maintainable code. Error checking and data integrity in a multiuser environment. Good use of functions and include files. Separating HTML from script from SQL. Keeping databases, directories and shopping carts tidy. Portability issues (databases, operating systems, PHP releases and installation). Futureproofing. Backups.

Introduction to Python (module Y101) What is Python? Running Python from the command line. Running Python from a script file. Hello Python World. Sourcing and installing Python.

Commercial and Legal Aspects (module A213) Why discuss this on a technical course? Data Protection. Privacy and credit card security. Unsolicited commercial emailing and mailing lists. Accessability. Marketing and visibility.

Graham Ellis - graham@wellho.net [email]  [about Graham] Melksham, Wiltshire
Public courses run at Well House Manor - our own purpose fitted training centre and business hotel / conference centre in Melksham.
• Download Melksham Map - [pdf file (750k)] • Google Map - [Link]

1 student	2 students	3 students	For 4 or more students from the same company, please consider a private course.
With hotel room £720.00 (£846.00 inc VAT) Without room £600.00 (£705.00 inc VAT)	With hotel rooms £1340.00 (£1574.50 inc VAT) Without rooms £1100.00 (£1292.50 inc VAT)	With hotel rooms £1960.00 (£2303.00 inc VAT) Without rooms £1600.00 (£1880.00 inc VAT)
Notes: • 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 / Perl Programming, PHP Programming, Python Programming and MySQL.

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 "Opentalk" forum where you can raise questions. We also encourage you to email the tutor, and to visit us again to use our library as appropropriate.

Certification? - [Link] Public (scheduled) courses -- http://www.wellho.net/course/ctc.html
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 -- http://www.wellho.net/net/terms.html
Covering topics such as delegate substitution, payment, cancellation policy and other matters.