Perl Training Australia - Database Programming with Perl

Trainers:	Paul Fenwick Jacinta Richardson
Length:	2 days
Notes:	Course notes
Target Audience:	Perl programmers who are familar with Perl's data structures, references, and subroutines, and who wish to use Perl to interact with databases.

This course covers using simple databases with Perl before covering how to use Perl's DBI module to interface with relational databases. Further topics include transactions, exception handling, database security, database abstraction with Class::DBI, debugging, profiling, and encrypting remote connections.

You will learn:

why we use databases;
how to interface to Berkley DB files and their limitations;
basic SQL;
how to use Perl's DBI to connect and disconnect to the database; insert, update, delete data and select data with and without filters;
how to use transactions with DBI and how to use exception handling to ensure that program errors also cause database rollback;
how to avoid SQL injection attacks and turn data tainting on for the database;
how to use Class::DBI to abstract away the database and SQL;
how to use DBI's trace method for debugging and how to profile your database application;
how to bind variables to placeholders for input and output;
how to move passwords out of your program and into configuration files or environment variables;
how to make remote connections to your database and how to use encryption for this connection;
some ways to make connections persistent if required;