Exercises, examples and other material relating to training module P308. This topic is presented on public courses
MySQL,
Perl Programming,
Perl for Larger Projects
The MySQL Relational database - Structure, Installation, Administration, Database Design and Programming through SQL
This course introduces you to the ... http://www.wellho.net/course/mqfull.html [course] |
Learning to program in Perl / Perl Programming - Programming Perl - for newcomers to the language
This course introduces you to the Perl programming language.
... http://www.wellho.net/course/ppfull.html [course] |
Learning to Program in Perl / Perl Programming - Learning Perl - whether you're new to programming or 'converting'.
This course covers programming in the ... http://www.wellho.net/course/lpfull.html [course] |
Perl for Larger Projects - Objects, huge data, SQL databases, XML, efficiency and other topics.
This advanced course takes the Perl programmer through
... http://www.wellho.net/course/plfull.html [course] |
We're becoming a serious MySQL resource, with many technical articles, examples, forum posts and blog entries answering those difficult-to-resolve issues ... http://www.wellho.net/mouth/515_MySQL-an-FAQ.html [short article] |
At the core of MySQL is mysqld , the database engine daemon which handles connections and requests via a TCP port - typically post no. 3306. Provided ... http://www.wellho.net/solutions/mysql-in ... ngine.html [longer article] |
We have just come to the end of a solid 12 days of training ... and we are just getting ready for the next week, with delegates arriving this evening. ... http://www.wellho.net/mouth/1904_Rub ... notes.html [short article] |
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 |
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.
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 700 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.