Archive - Originally posted on "The Horse's Mouth" - 2005-11-29 08:22:14 - Graham Ellis
Ostensibly, I'm giving a MySQL course. A client who has a large and complex data base and needs many staff to be able to make ad-hoc enquiries. Server is Linux, and regular (standard) enquiries will be via a browser fed by a PHP Page from a web server.
In other words L-A-M-P or LAMP. Linux, Apache, MySQL and PHP.
Four very new technologies to their team who are much more from a mainframe and / or windows background.
Everyone's requirement is unique ... but such uniqueness if often related more to the flavour and the balance of the technologies rather than them being totally different. It stuck me yesterday, and over the weekend at Geekmas, just how many skills we have here at Well House Consultants - how we'll swap back and forth between all those technologies. We already offer a LAMP Deployment course ... but we have more scope too. Now sure how we would structure a public course as there are too many variables but as a private course, elements could be taken:
Building a Dynamic Web Presence
* HTML and more than HTML (XHTML, DHTML, form design)
* Virtual pages through mod_rewrite and other techniques
* Changeable content with PHP
* HTML - CSS - SQL - Image libraries
* Advertising Standards, Disability Discrimination
* Acceptable User Policies
* Data Mining to provide the visitors each with correct content
* Using your own and other search engines in your site
* Remembering visitors
* Locating visitors by their countries of origin and interest
* Search Engine Placement and optimisation
* Browser recognition; Javascript, AJAX
* Injection attacks, denial of service attacks and other security issues
* Avoiding 404 errors - making the URL work for the user
* Reading and analysing log files and trends
* Mobile Phone Users and making the site good for them
* Sessions
* Avoiding multiple logins.
* Booking and ordering systems
* Wiki and other content management systems.
* Easily maintaining your content - MVC model and others
* MT, Yabb, SMF, OSCommerce, Plone etc.
* Perl - Python - XML ...
* Code re-use and standards.
Amazing thing is ... give me an enquiry for a private course to cover a selection of almost any of these subjects and we've already got all the resources in place to do it!
Update - September 2008 - I have added a simple Ajax Example here, and Ajax is now covered on our PHP Techniques Workshop