Exercises, examples and other material relating to training module Q916. This topic is presented on public course Ruby on Rails
|Articles and tips on this subject
|Delegate Question - defining MySQL table relationships as you create the tables
Q - Can define how tables are linked (joined together) when you set them up in MySQL, rather than having to specify the join each time that you SELECT data from the tables?
What a great (and logical) idea, but it's not straightforward / automatically available. The current / default system in the ...
|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 ...
|Oops - I got my initial database design wrong
Just once in a while a question comes up on our Opentalk Forum that's so good and of such general interest that a longer answer is worthwhile. Such a question came up yesterday ... and elegantly asked and worded too, so it was a delight to read and answer.
You want a simple database application? Great ...
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
Why use a database?
Designing your table structure.
The Structured Query Language - SQL.
How to keep your data robust.
Normalising your data.
Server and integrated database handlers
SQLite and MySQL.
Oracle, SQL Server, Access, PostGREsql and others.
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.