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]

Custom course - training course - Custom course

Custom course - Custom course Custom course This is a custom course that will be tailored to your trainee's needs and based on their current knowledge ...

http://www.wellho.net/course/ccfull.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]

The future of MySQL

MySQL has grown from a very neat little open source database 10 years ago into a very powerful and widespread database that's not always fully open source ...

http://www.wellho.net/mouth/2561_The ... MySQL.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

Review - flat databases.
Relational databases through SQL.
Setting up the DBI and DBD modules.
Connecting to an SQL server.
Issuing an enquiry and reading back the results.
Amending information in a database via SQL.
Creating new tables.
Database support including mySQL, Oracle, Sybase, Infomix.
Interfacing Perl to the Access database.
Using Tie to access a table as if it was a Perl Hash.

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.