For 2021 - online Python 3 training - see ((here)).
Our plans were to retire in summer 2020 and see the world, but Coronavirus has lead us into a lot of lockdown programming in Python 3 and PHP 7.
We can now offer tailored online training - small groups, real tutors - works really well for groups of 4 to 14 delegates. Anywhere in the world; course language English.
Please ask about private 'maintenance' training for Python 2, Tcl, Perl, PHP, Lua, etc.
Well House Consultants
You are on the site of
Well House Consultants
Open Source Training Courses
hotel accommodation. You are welcome to browse and use
our resources subject to our copyright statement and to add in links from your pages to ours.
Other subject areas - resources
Well House Manor Resources
Object Orientation and General topics
Linux / LAMP / Tomcat Resources
Well House Consultants Resources
C and C++ Resources
Web and Intranet Resources
MySQL module S151
Introduction to SQL and MySQL
Exercises, examples and other material relating to training module S151. This topic is presented on public courses Deploying LAMP - Linux, Apache, MySQL, Perl/PHP
, Linux Web Server
, Technology Background for PHP
, Deploying Java Applications on Linux / Unix
For many applications, relational databases provide an excellent tool for managing data. Modern relational databases use the Structured Query Language (SQL) to provide applications with access to the data. One such relational database is MySQL.
Related technical and longer articlesJustification - MySQL v Oracle, Open Source v CommercialManagement overview of MySQL - background and Philosophies
|Articles and tips on this subject||updated|
|3928||Storing your intermediate data - what format should you you choose?|
Many applications require data to be held at intermediate stages - stored. What format should be used? ... HUGE subject.
1. If there is already an industry standard / draft standard way of doing it, think very carefully before going for anything else. The standard will have been designed with ease ...
|3269||Files or Databases? MySQL, SQLite, or Oracle?|
Are plain files a bad idea? Should you use a database instead?
Plain text files are a great way of saving data in some circumstances ... but in other circumstances they have "issues":
1. If you're saving columns of data in a plain text file, you need to have some sort of separator between the columns, ...
|2786||Factory methods and SqLite in use in a Python teaching example|
I've just uploaded a neat little example - [here] from last week's Python course - it's amazing what you can do in a very few lines of code.
The application scenario is that we have a database of customers - some are residents at our hotel and others are delegates on our courses. Being mercenary folks, ...
|2567||Extra MySQL course dates (2 day course, UK)|
We've added a MySQL course into our calendar - on Saturday and Sunday 20th and 21st February, at Well House Manor. The course includes a general introduction to SQL, with a slant towards the MySQL flavor, and the principles of database design too ... as well as the installation and configuration of MySQL.
|2561||The future of MySQL|
MySQL has grown from a very neat little open source database 10 years ago into a very powerful and widespread database that's not always fully open source any longer today. The MySQL company was bought out by Sun a couple of years back (January 2008), and in turn Oracle are now buying Sun. This deal ...
|2134||Oracle take over Sun who had taken over MySQL|
The newspaper tells me that Oracle is buying Sun Microsystems. Since Sun Microsystems bought MySQL about a year ago, this means that Oracle now owns MySQL. I wonder what they will do with it.
I am reminded of FrameMaker being taken over by Adobe, and attempts to move the customer base to PageMaker ...
|924||The LAMP Cookbook - Linux, Apache, MySQL, PHP / Perl|
It all started on Friday as we came back from the pub. I was describing how we've been, twice, on Neil Bauman's Geek Cruises but never been asked to talk or lecture, even in a "lightning session" on them. A little wistfully, maybe, as I'm a "wannabe" - I would love to get up and deliver a talk just ...
|84||MySQL - nuggets|
I had great pleasure in listening to David Axmark and Monty Widenius talking about MySQL this morning. When I take up a new subject, I always feel a little apprehensive - am I presenting it as its authors intended? Who are the authors anyway - are they nice, sensible guys? Great news - Monty and David ...
|918||Databases needn't be frightening, hard or expensive|
Have you written a web site using plain old HTML (perhaps with style sheets and images) and then extended it to more interactive content using a little PHP, JSP, Perl, cgi or similar? Are you keeping the data associated with your PHP - your on line programs - in plain text files? If you are, that ...
|515||MySQL - an FAQ|
We're becoming a serious MySQL resource, with many technical articles, examples, forum posts and blog entries answering those difficult-to-resolve issues you may have come across. You might like to bookmark (or link to) this page.
Eleven recent articles on MySQL ...
Flashbulb moments - facts that ...
|591||Key facts - SQL and MySQL|
Some quick ways to remember your SQL; here are some "flashbulb moments" for newcomers and occasional users of MySQL and other SQL databases.
A database daemon is a process that looks after a number of DATABASES each of which comprises a number of TABLES each of which comprises data arranges in ROWS ...
|85||Present and future MySQL|
An almost too-crowded schedule. Yesterday morning, the founders of MySQL, and I have posted more fully about their talks elsewhere on the site - here and here. In the afternoon, a talk by Brian Aker who's their director of architecture, which I found a useful approach to some other aspects of MySQL, ...
PicturesMySQL training, on site in Oxford
Public MySQL course, Southern England
Some modules are available for download
as a sample of our material or under an Open Training Notes License
for free download from [here]
Topics covered in this module
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?.
If you are looking for a complete course and not just a information on a single subject, visit our Listing and schedule
Well House Consultants specialise in training courses in
. We run
throughout the UK (and beyond for longer courses), and
at our training centre in Melksham, Wiltshire, England.
It's surprisingly cost effective to come on our public courses -
even if you live in a different
country or continent to us
We have a technical library of over 700 books on the subjects on which we teach.
These books are available for reference at our training centre.