Using Perl's DBI module to do database programming allows one to write
generic database-access programs that can interface with any of the
popular database management systems (Oracle, Sybase, MySQL, etc.).
This allows the same program to be used with different underlying databases,
which obviates the need to rewrite the program when the database changes.
This course provides a brief overview of the SQL query language,
and then a detailed description of the use of DBI for creating,
updating, accessing, and deleting database records.
The instructor will offer recommendations about "best practices", and point out common blunders that students should try to avoid.
Hands-on experience will be provided in numerous supervised lab sessions.
Who Should Attend
Students should be
experienced Perl programmers who are comfortable handling Perl references.
It is also beneficial for students to have a
basic understanding of relational databases and the construction
of SQL queries.
Author & Instructor
Colin Meyer has worked as a professional Perl programmer
for over six years, for companies ranging from
small Seattle concerns to members of the Fortune 500.
He has designed, implemented, and maintained large database
and CGI applications
on corporate intranets as well as extremely high-profile web sites,
including those for
US West/Qwest
(http://www.uswest.com)
and the
Winter 2002 Olympics
(http://www.saltlake2002.com).
In his capacity as Group Leader,
he has enjoyed mentoring many programmers from their beginning stages with Perl
through their design and development of full-fledged professional-grade applications.
CONSULTIX
instructors are
renowned for their ability
to communicate complex concepts in simple terms and to make the study of dry technical material enjoyable.
Sample Topics
Intro. to DBI/DBD
Review of SQL
The DBI API
Connecting to Databases
Executing SQL Queries
Managing Errors
Using Transactions
Handling BLOBS
Handling Dates
DBD::CSV
Using DBI with CGI
Using DBI with Templates
�
Other Courses
We have courses on many other
Perl
and
UNIX/Linux
topics!
�
Database Programming with Perl
�(�3�days�)
