Home Accessibility Courses Twitter The Mouth Facebook Resources Site Map About Us Contact
 
Python, Lua and Tcl - public course schedule [here]
Private courses on your site - see [here]
Please ask about maintenance training for Perl, PHP, Java, C, C++, Ruby, MySQL and Linux / Tomcat systems
 

Well House Consultants
You are on the site of Well House Consultants who provide Open Source Training Courses and business 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
Java Resources
Well House Manor Resources
Perl Resources
Python Resources
PHP Resources
Object Orientation and General topics
MySQL Resources
Linux / LAMP / Tomcat Resources
Well House Consultants Resources
Extras Resources
C and C++ Resources
Ruby Resources
Tcl/Tk Resources
Web and Intranet Resources
MySQL module S050
MySQL - General
Exercises, examples and other material relating to training module S050. This module is presented on Private Courses and Specially Run Courses only

Background
MySQL is a relational database system - a system that's used for updating and extracting data from a series of linked tables so that the data can be stored uniquely, efficiently, and without conflict when several users require concurrent access.
Related technical and longer articles
Left Joins to link three or more tables
Management overview of MySQL - background and Philosophies
MySQL Extras

Articles and tips on this subjectupdated
3361Blowing our own trumpet - MySQL resources
From my mailbox .... Hello,   I was able to (finally) learn the many to many relationships from your tutorial! It is written very well, thank you for it :)   Are there any resources or practical tutorial packs that you sell like an ebook or something?   For example things that intermediate ...
2011-07-19
 
2861MySQL and Java - connectivity past, present, and future thoughts
MySQL has migrated from MySQL AB (1995 to 2008) to Sun (2008 to 2010) to Oracle (from 27 Jan 2010) wizard:java graham$ /usr/local/mysql/bin/mysql -uwellho -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.1.48 MySQL Community ...
2010-07-09
 
2567Extra 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. This ...
2010-01-09
 
2561The 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 ...
2010-01-03
 
2559Moving the product forward - ours, and MySQL, Perl, PHP and Python too
I have just posted a "steady as she goes" message, welcoming the new decade but reassuring our customers that we're carrying on offering very much the same high quality courses, and the same high quality hotel rooms. But things can't stand totally still - they would stagnate, courses would get out ...
2010-01-01
 
2426Which version of MySQL am I running?
Oh be careful - that is a VERY dangerous question. Do you mean "what version is my MySQL server" or "what version of the mysql client program am I running?" I'll show you how to find answers to both questions. What version is my MySQL server? Use the select command, and run the version function within ...
2009-09-26
 
2240How do I query a database (MySQL)?
From my mailbox ... "What are the different ways of queries in databases? Could u pls explain each way in more detail? thanks" The term "query" means something a little bit different in the term "SQL" to it does in regular English usage - the dictionary definition is to ask for information / pose a ...
2009-06-22
 
2085MySQL - licensing issues, even with using the name
MySQL is a really good database and it's been available for a very long time under an open source license - indeed this piece of text will be stored in a MySQL database when I've added it to our web site using the Movable Type software , and pulled back from there using both Movable type software (here), ...
2009-03-17
 
2053What a difference a MySQL Index made
If you add an index to a column in a MySQL table, you provide a very quick way of looking up a row or set of rows based on the value in a certain column, but at the expense of additional disc space and a bit more internal management. Here's an example in which I look up a record (by URL) in a table ...
2009-02-25
 
Examples from our training material
sample_mysql_table   Create a table with duplicate records to remove as an exersize
Background information
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
What is MySQL?
What is MySQL used for?
Is MySQL right for me?
Complete learning
If you are looking for a complete course and not just a information on a single subject, visit our Listing and schedule page.

Well House Consultants specialise in training courses in Ruby, Lua, Python, Perl, PHP, and MySQL. We run Private Courses throughout the UK (and beyond for longer courses), and Public Courses 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.


You can Add a comment or ranking to this page

© WELL HOUSE CONSULTANTS LTD., 2018: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01225 708225 • FAX: 01225 793803 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho

PAGE: http://www.wellho.net/resources/S050.html • PAGE BUILT: Mon Feb 8 18:55:24 2016 • BUILD SYSTEM: WomanWithCat