Home Accessibility Courses Twitter The Mouth Facebook Resources Site Map About Us Contact

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 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, MySQL, 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 articles
Management overview of MySQL - background and Philosophies
Justification - MySQL v Oracle, Open Source v Commercial

Articles and tips on this subjectupdated
3928Storing 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 ...
2012-11-24
 
3269Files 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, ...
2011-04-29
(longer)
2786Factory 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, ...
2010-06-02
 
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
 
2134Oracle 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 ...
2009-04-22
(short)
924The 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 ...
2009-01-01
 
84MySQL - 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 ...
2008-05-10
 
918Databases 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 ...
2006-11-12
 
515MySQL - 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 ...
2006-06-09
 
591Key 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 ...
2006-06-09
 
691Testing 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 ...
2006-06-05
 
Pictures
MySQL training, on site in Oxford
Public MySQL course, Southern England
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
Information organisations.
Plain files.
Directory structure.
Table.
Relational database.
Relational databases.
The structure of a typical RDBMS.
Accessing a relational database from the Web.
Database access protocols.
SQL.
MySQL.
Distributions and licenses.
Component parts of MySQL.
Versions of MySQL.
Production Version.
Development Version.
MySQL- Max.
When should I choose MySQL?.
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., 2017: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 793803 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho

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