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 S152
SQL Primer as Used in MySQL
Exercises, examples and other material relating to training module S152. This topic is presented on public courses Deploying LAMP - Linux, Apache, MySQL, Perl/PHP, Linux Web Server, MySQL, Deploying Java Applications on Linux / Unix

The Structured Query Language provides the application programmer interface that allows data to be entered into, edited, and selected from most relational databases. It also provides users with suitable authorisation with the ability to create and edit the structures that hold the data.

Related technical and longer articles
MySQL joins - using left join and right join to find orphan rows
Left Joins to link three or more tables

Articles and tips on this subjectupdated
4007Which database should I use? MySQL v SQLite
Which SQL Database would I advise newcomers with a new application to use? Five years ago, MySQL would have been the obvious choice in many circumstances. But these days, MySQL has grown into a much bigger product and there are very serious licensing and other commercial issues that need to be considered; ...
2013-02-16
 
158MySQL - LEFT JOIN and RIGHT JOIN, INNER JOIN and OUTER JOIN
In a database such as MySQL, data is divided into a series of tables (the "why" is beyond what I'm writing today) which are then connected together in SELECT commands to generate the output required. I find when I'm running MySQL training, people often get confused between all the join flavours. Let ...
2011-01-01
 
3061Databases - why data is split into separate tables, and how to join them
If you're travelling from Chippenham to London by train, you may want to grab a quick coffee at the station before you set off - and where better than Steamers? And if you were traveling to Plymouth, Bristol, Southampton, Llandrindod Wells or Cheltenham, you would use Steamers too. Let's assume I'm ...
2010-12-04
 
3060INSERT, DELETE, REPLACE and UPDATE - changing the content of SQL tables
Most enquires of an SQL database are SELECTs - most database are "Read Mostly" and writes are limited to a small proportion of accesses (though there are exceptions). And SELECTs are much more complex that things that insert or change data too. However, I found myself writing en example on yesterday's ...
2010-11-19
 
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
 
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
 
502SELECT in MySQL - choosing the rows you want
The SELECT command in MySQL allows you to examine rows in a table (or more than one table if you like). Good news - but sometimes there's an awful lot of data and you just want rows chosen by particular criteria, or just the first (so many) rows. The WHERE clause on your select allows you to write a ...
2006-06-05
 
Examples from our training material
joiner.sql   Create two tables, link them with left join
linked.sql   Two tables ... an illustration of the different joins
loader.sql   Loading data from csv files
make_dvd.sql   Create a database and table for a DVD collection
pop_dvd.sql   Insert rows into sample dvd table
seeds.mysql   MySQL example - table joins
sql_demo.sql   Adding and amending data in a database table
tab1   First table for advanced join demos
tab2   Second table for advanced join demos
Pictures
MySQL training
Training for Oxford University Computer Services
Background information
You may download this module as a sample of our material
Topics covered in this module
The structure of a database as seen by MySQL.
SQL introduction.
"Hello SQL World".
Databases, tables, fields, rows and columns.
Field types and modifiers.
Initial administration and error handling.
Commands to enter and edit rows of data - Insert, replace and load.
Enquiry (select) commands.
Conditional clauses and writing conditions.
Command to modify and delete rows.
DROP, SHOW and others.
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/S152.html • PAGE BUILT: Mon Feb 8 18:55:24 2016 • BUILD SYSTEM: WomanWithCat