|
|
MySQL Databases and the SQL Language
These guides 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.
Part 1 - Introducing SQL
This part introduces MySQL, explains a little bit about conventions and
starts constructing simple SELECT SQL statements.
Get Started . . .
Part 2 - Structures and Data
CREATE-ing tables and INSERTing data.
Get Started . . .
Part 3 - Manipulating Data
UPDATEs, DELETEs and Advanced SELECTs.
Get Started . . .
Part 4 - Manipulating Structures
ADDing, ALTERing and DELETE-ing Columns and Tables.
Get Started . . .
Part 5 - Joins
Using SQL Statements to retrieve data from multiple tables.
Get Started . . .
Part 6 - Adminstration
CREATE-ing databases, creating users, managing permissions and backing up
data.
Get Started . . .
Part 7 - Normalisation
A look at database theory that aims to be accessible for the novice developer.
Get Started . . .
Part 8 - Advanced Queries
Aliasing and referencing, Self-Joins, Temporary Tables, Full Text Searches.
Get Started . . .
Part 9 - Built-in Functions
Date Functions, Mathmatics Functions, String Functions.
Get Started . . .
Part A - Quick Answers
Securing MySQL and using MySQL with MS Access.
Get Started . . .
|