SQL Primer as Used in MySQL

MySQL module S152

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

MySQL - 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 ...

http://www.wellho.net/mouth/158_MySQ ... -JOIN.html [short article]

Left Joins to link three or more tables

div class= introsubheads MANY-TABLE JOINS IN MYSQL - BACKGROUND BR /div Data held in SQL tables should be b normalised /b - in other words, held ...

http://www.wellho.net/solutions/mysql-le ... ables.html [longer article]

The MySQL Relational database - training course - Structure, Installation, Administration, Database Design and Programming through SQL

The MySQL Relational database - Structure, Installation, Administration, Database Design and Programming through SQL This course introduces you to the ...

http://www.wellho.net/course/mqfull.html [course]

Deploying LAMP - Linux, Apache, MySQL Perl / PHP / Python - training course - Installing and supporting applications under Open Source technologies

Deploying LAMP - Linux, Apache, MySQL Perl / PHP / Python - Installing and supporting applications under Open Source technologies This course is intended ...

http://www.wellho.net/course/alfull.html [course]

Linux Web Server - training course - Using your Linux system as a Web server with LAMP

Linux Web Server - Using your Linux system as a Web server with LAMP The major part of this course covers the installation and the configuration of the ...

http://www.wellho.net/course/lwfull.html [course]

Deploying Java applications on Linux and Unix - training course - Learn to install and support applications under Linux/Unix with Apache, Tomcat and MySQL

Deploying Java applications on Linux and Unix - Learn to install and support applications under Linux/Unix with Apache, Tomcat and MySQL This course is ...

http://www.wellho.net/course/ajfull.html [course]

NULL in MySQL

NULL is not a value - it's a condition. So if you try and write something "= NULL" you'll get an empty set rather than the results you're looking for. ...

http://www.wellho.net/mouth/270_NULL-in-MySQL.html [short article]

MySQL joins - using left join and right join to find orphan rows

If you re joining several tables together, you can do so in such a way that you show only the combined results, or in such a way that you can also (or ...

http://www.wellho.net/solutions/mysql-my ... -rows.html [longer article]

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.

This topic is presented on public courses Deploying LAMP - Linux, Apache, MySQL, Perl/PHP, Linux Web Server, MySQL, Deploying Java Applications on Linux / Unix

Examples from our training material

joiner.sql	Create two tables, link them with left join
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
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 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. Also available is the Opentalk Forum for discussion of technical questions.