Part 1 – Introducing SQL

Bagi anda yang sedang mempelajari atau akan mempelajari MySQL, berikut ini (Klik disini) terdapat Tutorial tentang MySQL dari Keith J Brown , yang berisi tutorial tentang:

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

Part 2 – Structures and Data

CREATE-ing tables and INSERTing data.  

Part 3 – Manipulating Data

UPDATEs, DELETEs and Advanced SELECTs.  

Part 4 – Manipulating Structures

ADDing, ALTERing and DELETE-ing Columns and Tables.  

Part 5 – Joins

Using SQL Statements to retrieve data from multiple tables.  

Part 6 – Adminstration

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

Part 7 – Normalisation

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

Part 8 – Advanced Queries

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

Part 9 – Built-in Functions

Date Functions, Mathmatics Functions, String Functions.  

Part A – Quick Answers

Securing MySQL and using MySQL with MS Access.  

Selamat mempelajarinya, semoga bermanfaat.