MySQL Databases and the SQL Language

MySQL Databases and the SQL Language

Welcome to my set of tutorials on MySQL. While there are loads of tutorials on MySQL (usually in combination with a scripting language) on the Net aimed at building applications etc, there are very few that want to use MySQL to teach the SQL syntax and with it a bit about databases for the novice. Thus these workshops are simply about that… seeing how a simple database can be created and manipulated by typing SQL statements. Knowledge of what is going on ‘underneath’ user friendly interfaces is pretty good to know in my opinion.

The workshops themselves are in themed parts, but it is intended that the reader work their way through each, building up SQL knowledge and understanding along the way. They are also meant to be a simple, if fairly comprehensive, introduction to MySQL and to SQL in general however the MySQL Documentation Site is still the best place to go for uptodate information and advanced features and techniques.

If you are not comfortable setting up a server or need more robust environment then you’ll need a good host. webhostingsearch.com asked if I would recommend them and having checked out their site it seems a whole lot better then scrambling around trying to find hosts and compare them yourself – so why not start there…

Part 1 – Introducing SQL

This Workshop introduces MySQL, explains a little bit about conventions and starts constructing simple SELECT SQL statements. Read On>>

Part 2 – Structures and Data

CREATE-ing tables and INSERTing data. Read On>>

Part 3 – Manipulating Data

UPDATEs, DELETEs and Advanced SELECTs. Read On>>

Part 4 – Manipulating Structures

ADDing, ALTERing and DELETE-ing Columns and Tables. Read On>>

Part 5 – Joins

Using SQL Statements to retrieve data from multiple tables. Read On>>

Part 6 – Adminstration

CREATE-ing databases, creating users, managing permissions and backing up data. Read On>>

Part 7 – Normalisation

A look at database theory that aims to be accessible for the novice developer. Read On>>

Part 8 – Advanced Queries

Aliasing and referencing, Self-Joins, Temporary Tables, Full Text Searches. Read On>>

Part 9 – Built-in Functions

Date Functions, Mathmatics Functions, String Functions. Read On>>

Part A – Quick Answers

Securing MySQL and using MySQL with MS Access. Read On>>