Training, Open Source computer languages

PerlPHPPythonMySQLhttpd / TomcatTclRubyJavaC and C++LinuxCSS

Search our site for:
Home Accessibility Courses Diary The Mouth Forum Resources Site Map About Us Contact

Related technical and longer articles
Interfacing applications to a MySQL database engine
Tips and short articles on this subject
Object Relation Mapping (ORM)
Answering ALL the delegate's Perl questions
Using a MySQL database from Perl
MySQL - an FAQ
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 Resources
Well 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
Using SQL Databases from Perl - module P308
Perl accesses information held in relational databases through the DBI module, with additional modules (known as DBD modules) used to provide the specific code for individual database products such as MySQL. This module covers the sourcing and downloading of the DBI and DBD modules, and the use of DBI from within Perl. You don't use DBD directly, which ensures that your Perl code is very portable.

This topic is presented on public courses MySQL, Perl Programming, Perl for Larger Projects

Examples from our training material
aclog2table   Set up database for web access log records
aggy   Connecting Perl to a MySQL database
dbdhash.pm   Tie a Perl hash to a MySQL table through DBI
edbi   Example using many database access methods from DBI
fifthdbi   Perl DBI - display contents of MySQL table
firstdbi   Simple Perl DBI Query
hellosql   Accessing and SQL database with DBI and DBD modules
orange.pl   DBI used in a CGI script as a GUI to a table
sqlping   Using DBI and DBD to establish a connection and list available tables
tie_main   Exercise - main program to die hash to database
trains.sql   Data to create and populate train table for other examples
traintimes   Connect to an SQL database of train times
Specialist books


Opentalk forum discussions related to this topic
DBI module missing
Connecting to MySQL over an unreliable network
Perl Database
Is this a hash in an SQL insert statement
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
Flat databases.
Relational databases through SQL - Setup.
Checking that your relational database is available.
Installing the database independent module (DBI).
Install the Database Dependent drivers for MySQL.
Using DBI to access a MySQL database.
A further example.
Other databases.
Course links
The following web pages are used as references / examples in this module

[Link] CPAN
(at http://cpan.hambule.co.uk/)

We check these links from time to time with a spider written in PHP. Latest full check was on Saturday, 12th June 2004. Titles are extracted from the web pages listed.

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.


© WELL HOUSE CONSULTANTS LTD., 2008: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01144 1225 708225 • FAX: 01144 1225 707126 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho