consultix small logo

Consultix


Home
About
News
Documentation
Debug
Courses
Database Programming with Perl - 3 days

Database Programming with Perl  ( 3 days )


Next Public Offering:  TBA; Help Us Schedule! 
Description
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!  


© Tim Maher  1995-2003     Comments?

© Copyright 1995-2003 Pacific Software Gurus, Inc.. All Rights Reserved.