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