SQL Primer as Used in MySQL

SQL Primer as Used in MySQL - module S152

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 MySQL, Deploying Java Applications on Linux / Unix, Deploying LAMP - Linux, Apache, MySQL, Perl/PHP, Linux Web Server

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

More web pages on this subject

Regular Expressions in MySQL

Opentalk forum discussions related to this topic

THREE WAY JOINS with subqueries amp groups
Edit Script not working
4 characters in mysql
date comparisons in sql
On limiting selection
MySQL query to a text file
MySQL as Case Sensitive
LEFT JOIN
Joining tables
How to write this query
How to write an INNER JOIN QUERY in Mysql
Finding the key of a row just added
Finding out about columns
Does a table exist Oracle and MySQL check
Changing column values
Are MySQL enquiries case sensitive

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 SQL.
SQL introduction.
Hello SQL World.
Initial administration and error handling.
Field types and modifiers in MySQL.
Floating point (real) numbers.
Whole (Integer) numbers.
Text Strings.
One or more values from a pre-defined list.
Dates and Times.
Blobs.
Other Modifiers.
Example.
Indexes.
Other matters.
A note on reserved words.
Commands to enter new rows of data.
The INSERT command.
The REPLACE command.
The LOAD command.
Enquiry commands.
Conditional Clauses.
Returning table report information.
Commands to modify existing rows of data.
The UPDATE command.
The DELETE command.
Commands to modify the metadata.
The ALTER Command.
The DROP command.
Other commands.
The SHOW command.
On limiting selection.
Joining tables when selecting rows.
Extra use of SELECT.
Other commands.
Some more advanced SQL.
Loading data from file.
More on joining.
A regular "join".
A left join.
Joining across databases?.

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.