Training, Open Source computer languages

PerlPHPPythonMySQLhttpd / TomcatTclRubyJavaC and C++LinuxCSS

Search our site for:
Home Accessibility Courses Diary The Mouth Forum Resources Site Map About Us Contact

Related technical and longer articles
Copying databases and tables in MySQL
MySQL joins - using left join and right join to find orphan rows
MySQL SELECT - JOIN versus UNION, WHERE versus HAVING, GROUP etc.
Left Joins to link three or more tables
When to denormalise your MySQL data
MySQL Extras
Solution Centre - all article listing
Solution Centre - all article listing
Tips and short articles on this subject
MySQL joins revisited
Outputting numbers as words - MySQL with Perl or PHP
MySQL - the order of clauses and the order of actions
Helicopter views and tartans
Key facts - SQL and MySQL
Saving a MySQL query results to your local disc for Excel
Giving the researcher power over database analysis
Combining similar rows from a MySQL database select
An occasional chance, and reducing data to manageable levels
MySQL - an FAQ
MySQL - JOIN or WHERE to link tables correctly?
SELECT in MySQL - choosing the rows you want
MySQL - a score of things to remember
Matching in MySQL
Getting a list of unique values from a MySQL column
MySQL - Optimising Selects
MySQL - LEFT JOIN and RIGHT JOIN, INNER JOIN and OUTER JOIN
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
More MySQL Commands - module S157


This topic is presented on public course MySQL

Examples from our training material
agents   SQL statements for Agent and Property demo
agents.tab   Estate agent details - Trowbridge, Melksham, etc
homes.tab   Houses for sale - Trowbridge, Melksham, etc
Specialist books

Opentalk forum discussions related to this topic
THREE WAY JOINS with subqueries amp groups
A Really easy project but need help
Subtraction one set from anothe set in MySQL
Multiple users and data integrity
Microsoft Excel to Mysql
Loading a table from data in a text file
How to write an INNER JOIN QUERY in Mysql
Foreign Keys steps to enable
Does a table exist Oracle and MySQL check
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 http://www.training-notes.co.uk.
Topics covered in this module
Revision.
Complex joins.
Left right and straight join.
Aliases.
Inner and outer joins.
Indexes.
Unique and regular indexes.
Multiple field indexes.
Fulltext indexes.
Optimising queries.
Join order and what to index.
Selection efficiency.
Transactions.
Locking issues.
Commit and Rollback.
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 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 600 books on the subjects on which we teach. These books are available for reference at our training centre. Also available is the Opentalk Forum for discussion of technical questions.



WELL HOUSE CONSULTANTS LTD.: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 0800 043 8225 or 01225 708225 • FAX: 0845 8382 405 or 01225 707126 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho