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 articlesManagement overview of MySQL - background and PhilosophiesJustification - MySQL v Oracle, Open Source v Commercial
|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 ...
|691||Testing you Perl / PHP / MySQL / Tcl knowledge|
There are some aspects of our work - such as training and helping people specify and plan their systems - that have a positive aura about them and are naturally forward looking. Yes, we celebrate those jobs.
Other aspects, such as support and repair work, start off with a natural "down" - we're called ...
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.