Welcome to Perl Training Australiaβs Database Programming with Perl training module. This is a
two day training module in which you will learn how to interact with databases through Perl.
Course outline
β’ Accessing the database
β’ Programming with DBI
β’ SQL::Abstract
β’ Transactions
β’ Database security
β’ Class::DBI
β’ Removing passwords from your programs
β’ Working with remote connections
Assumed knowledge
This training module assumes the following prior knowledge and skills:
β’ Intermediate Perl fluency, including a familiarity with Perl variable types and references, file
input/output, system interaction and using Perl modules. Some experience of using Perl objects
would be useful.
β’ Basic Unix fluency, including logging in, moving around directories, and editing files
Module objectives
β’ Understand what a database is and why we use them
β’ Understand basic SQL commands
β’ Be able to use the database shell to access the database
β’ Understand why Perlβs DBI exists
β’ Use DBI to add, update, delete and select data in the database.
β’ Understand and use content from extra material.