Using SQL Databases from Perl

Perl module P308

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 - training course - Structure, Installation, Administration, Database Design and Programming through SQL

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 - training course - Programming Perl - for newcomers to the language

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 - training course - Learning Perl - whether you're new to programming or 'converting'.

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 - training course - Objects, huge data, SQL databases, XML, efficiency and other topics.

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]

MySQL - an FAQ

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]

Interfacing applications to a MySQL database engine

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]

Ruby, Perl, Linux, MySQL - some training notes

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.