MySQL

{| style="width:100%; background-color:transparent;"
 * style="width:50%; padding-right:1.2em;" valign="top" |

Tutorial

 * &radic;we SQL Introduction
 * MySQL Overview
 * MySQL - Getting started
 * Basic commands | Answers
 * Using Help | Answers
 * Flatfile (Single table) Database
 * First Database: Heights
 * Tasks: Create simple Flat file databases
 * Some SQL Theory
 * SQL Components | Backus-Naur Form
 * Data Definition Language (DDL) | Data types
 * Data Manipulation Language (DML)
 * Relational Database (dbHire): Sales, Hire and Repair Company
 * dbHire: System Analysis - Sale/Hire/Repair Company
 * dbHire - Database
 * dbHire - Business table (Business)
 * dbHire - Accounts tables (Client, Transaction)
 * SQL Theory: Data Query Language (DQL) - SELECT
 * Joins
 * SQL Theory: Join examples
 * dbHire - Human Resource tables (Staff, Timesheet)
 * Task: Joins and Relations
 * SQL Theory: Summarising (aggregating) data (SELECT-ORDER/GROUP)
 * Hire tables (Client, Equipment, Hire)
 * Stock tables
 * Repair tables
 * SQL Theory: DDL & DML


 * style="width:50%; background:#F6F9ED; border-left:1px solid #AAAAAA; padding-left:1.2em;" valign="top" |

Issues

 * Data Integrity
 * Performance - Indexing

Support

 * Data types
 * Installation | Windows Local installation | MySQL in WAMP
 * Windows/Apache/MySQL/PHP
 * Help Desk | Interactive Help Desk
 * MySQL Console tricks

Test Repository

 * DipICT. DB500 - Database management systems
 * }