Using the Perl DBI module

1 Day Course
Hands On
Code QAPERLDBI

This course has been retired. Please view currently available Perl Training Courses.

Modules

Hide all

Perl Reminder (7 topics)

  • Perl documentation
  • Perl variables
  • Context
  • References
  • Subroutines
  • Modules
  • Perl OO

Perl and databases (6 topics)

  • Introduction
  • DBI and DBD
  • Drivers and data source names
  • The DBI shell
  • A test database
  • dbi:DBM: and dbish

Using database handles (9 topics)

  • Database handles
  • Connect and disconnect
  • Attributes for connect
  • Manual error checking
  • Atomic fetching
  • Batch fetching
  • Statement shortcut - do
  • Other database handle methods
  • Pitfalls

Using statement handles (6 topics)

  • Life cycle of a statement
  • Fetching rows
  • Retrieving result sets
  • Fetching metadata
  • Calling a stored procedure
  • Other statement handle methods

Placeholders (7 topics)

  • Placeholder syntax
  • Repeated statement execution
  • Dynamic SQL
  • Bulk substitution
  • Placeholders with $dbh->do
  • Data typing with bindparam
  • Binding output to variables

Transactions (4 topics)

  • Principles of transaction handling
  • Database capabilities
  • Manual transaction control
  • Error handling

Prerequisites

Experienced Perl 5 developers and support staff who wish to use and support Perl interfaces with database systems. Delegates must have recent experience of Perl, and some knowledge of SQL.

Course PDF

Print

Sections