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

(written 2005-11-29 08:22:14)

 A100 - Web Application Deployment - The Components of a Web-Based Solution
  [2099] Should I maintain the programming code on my own website? - (2009-03-23)
  [1496] PHP / Web 2 logging - (2008-01-06)
  [1265] Apache, Tomcat, Jakarta, httpd, web server - what are they? - (2007-07-13)
  [1198] From Web to Web 2 - (2007-05-21)
  [1176] A pu that got me into trouble - (2007-05-04)
  [924] The LAMP Cookbook - Linux, Apache, MySQL, PHP / Perl - (2006-11-13)
  [673] Helicopter views and tartans - (2006-04-06)
  [442] How far away is that server? - (2005-09-10)
  [433] FTP - how to make the right transfers - (2005-09-01)
  [367] Ajax - (2005-07-03)
  [166] Acronyms - (2005-01-02)
  [49] Business is the predominant user of Tomcat, Perl and Tcl - (2004-09-15)
  [34] Linux / LAMP course - (2004-08-31)

G902 - Well House Consultants - Web site techniques, utility and visibility
  [2668] Is it worth it? - (2010-03-09)
  [2569] How to run a successful online poll / petition / survey / consultation - (2010-01-10)
  [2552] Web site traffic - real users, or just noise? - (2009-12-26)
  [2532] Analysing Google arrivals by country of origin - (2009-12-10)
  [2519] Status Page / breaks of service in early December - (2009-11-30)
  [2410] Removal of technical resources from this site - (2009-09-19)
  [2389] Writing with our customers words - (2009-09-01)
  [2341] Koulutus, Open Source tietokone kielillä - (2009-08-09)
  [2340] ldning, Open Source dator språk - (2009-08-09)
  [2339] Opplæring, Open Source datamaskinen språk - (2009-08-09)
  [2338] Uddannelse, Open Source computer sprog - (2009-08-09)
  [2337] Opleiding, Open Source computertalen - (2009-08-09)
  [2336] Formação, Open Source computador línguas - (2009-08-09)
  [2335] Ausbildung, die Open-Source-Sprachen - (2009-08-09)
  [2334] Formazione, Open Source computer lingue - (2009-08-09)
  [2333] Formación, de los lenguajes de código abierto - (2009-08-09)
  [2332] Formation, des langages Open Source - (2009-08-09)
  [2225] How important is a front page ranking on a search engine? - (2009-06-09)
  [2065] Static mirroring through HTTrack, wget and others - (2009-03-03)
  [2056] Web Site Loading - experiences and some solutions shared - (2009-02-26)
  [1982] Cooking bodies and URLs - (2009-01-08)
  [1970] Plagarism - who is copying my pages? - (2009-01-02)
  [1961] Making our things easier to find - (2008-12-26)
  [1955] How to avoid duplicating web page maintainance - (2008-12-20)
  [1888] Find the link - (2008-11-16)
  [1856] A few of my favourite things - (2008-10-26)
  [1833] Web Bloopers - good form design - avoiding pitfalls - (2008-10-11)
  [1797] I have been working hard but I do not expect you noticed - (2008-09-14)
  [1793] Which country does a search engine think you are located in? - (2008-09-11)
  [1756] Ever had One of THOSE mornings? - (2008-08-16)
  [1747] Who is watching you? - (2008-08-10)
  [1711] Rapid growth leads to server move - (2008-07-17)
  [1653] How do Google Ads work? - (2008-05-25)
  [1634] Kiss and Book - (2008-05-07)
  [1630] To provide external links, or not? - (2008-05-04)
  [1610] PHP course dot co, dot uk - (2008-04-13)
  [1554] Online hotel reservations - Melksham, Wiltshire (near Bath) - (2008-02-24)
  [1541] Colour, Composition or Content - (2008-02-16)
  [1534] Where in the world / country is my visitor from? - (2008-02-07)
  [1513] Perl, PHP or Python? No - Perl AND PHP AND Python! - (2008-01-20)
  [1506] Ongoing Image Copyright Issues, PHP and MySQL solutions - (2008-01-14)
  [1505] Script to present commonly used images - PHP - (2008-01-13)
  [1494] A time to update pictures - (2008-01-03)
  [1437] Above the fold with First Great Western - (2007-11-19)
  [1297] Stuffing content into a web page - easy maintainance - (2007-08-09)
  [1237] What proportion of our web traffic is robots? - (2007-06-19)
  [1212] What brought YOU to our web site? - (2007-06-01)
  [1207] Simple but effective use of mod_rewrite (Apache httpd) - (2007-05-27)
  [1186] Two new pages / sites - (2007-05-14)
  [1184] Finding resources - some pointers - (2007-05-13)
  [1177] Sorting out for a site map - (2007-05-05)
  [1104] Drawing dynamic graphs in PHP - (2007-03-09)
  [1055] Above the fold - (2007-01-28)
  [1029] Our search engine placement is dropping. - (2007-01-11)
  [1015] Search engine placement - long term strategy and success - (2006-12-30)
  [994] Training on Cascading Style Sheets - (2006-12-17)
  [976] Santa at the station - (2006-12-09)
  [916] Driving customers away - (2006-11-07)
  [893] Visibility - (2006-10-14)
  [800] Effective web campaign? - (2006-07-12)
  [767] Finding the language preference of a web site visitor - (2006-06-18)
  [757] Horse and Python training - (2006-06-12)
  [732] Where is a web site visitor browsing from - (2006-05-24)
  [718] Protecting images from theft - (2006-05-12)
  [681] Mirroring a dynamic site - (2006-04-12)
  [658] Keeping the visitors happy and browsing - (2006-03-26)
  [649] Denial of Service ''attack'' - (2006-03-17)
  [533] Bigger Box Campaign - (2005-12-18)
  [528] Getting favicon to work - avoiding common pitfalls - (2005-12-14)
  [492] New Navigation Aid - Launch of My Wellho - (2005-11-11)
  [414] Form Madness - (2005-08-14)
  [376] What brings people to my web site? - (2005-07-13)
  [369] CMS - the minefield of Choices - (2005-07-05)
  [348] Graveyard pages - (2005-06-15)
  [347] Frightening and from-friend viruses and spams - (2005-06-14)
  [322] More maps - (2005-05-23)
  [320] Ordnance Survey - using a 'Get a map' - (2005-05-22)
  [314] What language is this written in? - (2005-05-17)
  [311] Growth pains - (2005-05-14)
  [288] Colour blindness for web developers - (2005-04-22)
  [284] The Iconish language - (2005-04-19)
  [278] Cover all the options - (2005-04-13)
  [276] An apology to Mr Boneparte - (2005-04-11)
  [274] Our most popular resources - (2005-04-10)
  [268] Information request forms, cleaning up spam - (2005-04-05)
  [261] Putting a form online - (2005-03-29)
  [259] Responding to spam - (2005-03-27)
  [222] Who are all these visitors? - (2005-02-20)
  [202] Searching for numbers - (2005-02-04)
  [197] Allow for peak traffic on your web site - (2005-02-01)
  [182] Your personal Google ranking - (2005-01-19)
  [179] The hunt for unique words - (2005-01-16)
  [173] Data Mining - (2005-01-09)
  [165] Implementing an effective site search engine - (2005-01-01)
  [142] Colour for access - (2004-12-06)
  [117] A case of case - (2004-11-14)
  [109] URLs - a service and not a hurdle - (2004-11-04)
  [98] No more 'Error 404' pages. Something better. - (2004-10-24)
  [32] Web design platoon - (2004-08-29)
  [23] Skills and responsibilities - (2004-08-22)

W512 - Web and Intranet - Site Design Aspects
  [2214] Global Index to help you find resources - (2009-06-01)
  [1598] Every link has two ends - fixing 404s at the recipient - (2008-04-02)
  [1353] Mood shots - (2007-09-16)
  [1054] UK legal requirements for your commercial web site - (2007-01-27)
  [1047] Maintainable code - some positive advice - (2007-01-21)
  [918] Databases needn't be frightening, hard or expensive - (2006-11-08)
  [859] Put the answer in context - it may be printed - (2006-09-08)
  [823] An excellent use for a visitor count? - (2006-08-05)
  [795] Remember a site's non-technical issues too - (2006-07-07)
  [556] Colour doesn't have to mean colourful - (2006-01-06)
  [391] One mans pleasure is another mans poison - (2005-07-26)
  [352] Improved mining techniques! - (2005-06-19)
  [345] Spotting a denial of service attack - (2005-06-12)
  [319] Accommodation and landing pages - (2005-05-21)
  [229] A fortunate accident - (2005-02-27)

Back to Snippets from Geekmas

Previous and next or Horse's mouth home

Forward to Domain Forwarding - 2 ways of doing it

Crazy Day-sies
MySQL - JOIN or WHERE to link tables correctly?
Exciting futures - the Well House Manor project
Domain Forwarding - 2 ways of doing it
Dynamic Web presence - next generation web site
Snippets from Geekmas
Comment, please!
Introduction to Object Oriented Programming
What are DHCP and DNS?
Would you steal ... petrol? ... a training course?