|
| Home | Accessibility | Courses | Diary | The Mouth | Forum | Resources | Site Map | About Us | Contact |
 Related technical and longer articles Mapping database rows to objects in a classExample - PHP form, Image upload. Store in MySQL database. Retrieve. When to denormalise your MySQL data Many to many table mapping (Pivot tables) Replicating servers in MySQL - Why and how Tips and short articles on this subject Database design for a shopping application (MySQL)MySQL - table design and initial testing example Code quality counts Display an image from a MySQL database in a web page via PHP Databases needn't be frightening, hard or expensive Database design - get it right from first principles MySQL - an FAQ MySQL - a score of things to remember Oops - I got my initial database design wrong Binary Large Objects or bars MySQL - Pivot tables Well House Consultants
You are on the site of
Well House Consultants
who provide
Open Source Training Courses
and business
hotel accommodation. You are welcome to browse and use
our resources subject to our copyright statement and to add in links from your pages to ours.
Other subject areas - resources
Java ResourcesWell House Manor Resources Perl Resources Python Resources PHP Resources Object Orientation and General topics MySQL Resources Linux / LAMP / Tomcat Resources Well House Consultants Resources Extras Resources C and C++ Resources Ruby Resources Tcl/Tk Resources Web and Intranet Resources | 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
Specialist books Opentalk forum discussions related to this topic what database should I usestore 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 database to applications.
Interfacing to SQL via PHP. Other Clients. Relational database design. Database normalisation. Principles of a relational database. CoddÕs Rules for a Truly Relational Database System. Hiding passwords in client programs. 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. |
PH: 01144 1225 708225 • FAX: 01144 1225 707126 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho