MySQL - Designing an SQL Database System

Designing an SQL Database System - MySQL module S154

Data will be at the heart of your applications. Whilst it is possible to alter data structures later on without losing data, it is much better to get your design right at the start. This module covers the principles of analysing your database-destined data and designing a good structure for it.

This topic is presented on public course MySQL

Examples from our training material

authors.tab	Author table
books.tab	Book table
docdata.sql	Data for design / complex join example
docjoin.sql	Select for design / complex join example
docs.sql	Database and table setup for design / complex join example
just.php	Skeleton application - design / complex join example
pivot.sql	SQL to load book, author and pivot tables
pivots.tab	Pivot table
tabled.php	Display normalised MySQL tables on a web page

Specialist books

Opentalk forum discussions related to this topic

what database should I use
store file names or store files themselves
mysql tables on raw partition
creating relationships
Using foreign Keys
Transform Pivot tables
MyIsam or InnoDB with small database
Limiting number of rows in table
Holding config data in a table
Foreign Keys steps to enable
Entering foreign keys into main table
Database Modelling in UML
Char Varchar or Text

Pictures

We offer MySQL courses as well ...

Background information

Some modules are available for download as a sample of our material or under an Open Training Notes License for free download from http://www.training-notes.co.uk.

Topics covered in this module

Interfacing an SQL interface to applications.
Relational database design.
Data normalisation.
First, second and third normal forms.
Rules for a truly relational database.
Password issues and other security matters.

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.