|
Training, Open Source Programming Languages |
| Home | Accessibility | Courses | The Mouth | Resources | Site Map | About Us | Contact |
| For 2023 (and 2024 ...) - we are now fully retired from IT training. We have made many, many friends over 25 years of teaching about Python, Tcl, Perl, PHP, Lua, Java, C and C++ - and MySQL, Linux and Solaris/SunOS too. Our training notes are now very much out of date, but due to upward compatability most of our examples remain operational and even relevant ad you are welcome to make us if them "as seen" and at your own risk. Lisa and I (Graham) now live in what was our training centre in Melksham - happy to meet with former delegates here - but do check ahead before coming round. We are far from inactive - rather, enjoying the times that we are retired but still healthy enough in mind and body to be active! I am also active in many other area and still look after a lot of web sites - you can find an index ((here)) |
 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 | MySQL module S154
Designing an SQL Database System
Exercises, examples and other material relating to training module S154. This topic is presented on public course MySQL
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. Related technical and longer articles When to denormalise your MySQL dataMapping database rows to objects in a class Replicating servers in MySQL - Why and how Example - PHP form, Image upload. Store in MySQL database. Retrieve. Many to many table mapping (Pivot tables) Examples from our training material
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 [here].
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 Ruby, Lua, 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 700 books on the subjects on which we teach. These books are available for reference at our training centre. |
PH: 01144 1225 708225 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho
PAGE: http://www.wellho.net/resources/S154.html • PAGE BUILT: Sun Oct 11 14:50:09 2020 • BUILD SYSTEM: JelliaJamb