Schedule today!Call Peggy at
  (800) 252-0652
Contact Us

More UNIX

Related Courses

Programming in PERL: Using/Programming the Database Interface

Recommended Duration:
2 Days
Version
SUN Solaris (V7-V10), IBM AIX V4.3, 5L (V5.1 and V5.2), HP-UX (V11 and V11i), and SGI IRIX V6.5, Linux (Red Hat * SuSe)
Benefits
This course teaches both the programming interface and the techniques that can be used to write procedures in PERL (Practical Extraction and Report Language) to demonstrate methods of data persistance. These include a number of PERL extensions, and the DBI interfaces to commercial databases such as Oracle, Sybase, and mySQL. Each student will be able to use PERL techniques and commands to write scripts to perform various methods of database interactions.
Audience
Experienced PERL Developers needing to increase their Perl skills.
Prerequisites
Completion of the "Programming in PERL: Basic/Intermediate" or equvalent experience is assumed. A basic understanding of object oriented techniques (in PERL) is useful but not mandatory.
Major Topics
  • Overview of Data and Databases
  • Usage on various types of systems
  • Historical interfaces
  • Role of PERL in data acquisition and access
  • Non-DBI Databases
  • Traditional storage techniques
  • PERL extensions to manipulate complex structures: file storage, network access
  • Flat file databases
  • Concurrent access and lock mechanisms
  • MLDBM (multi-level database) extension
  • Relational Databases and SQL overview
  • Datatypes
  • Querying data
  • Creating and destroying tables
  • Modifying data in tables
  • PERL Database Interface Extensions
  • Obtaining necessary files
  • Extending PERL with DBI
  • DBI architecture (within PERL)
  • Programming the PERL DBI
  • Handles
  • Data Source Identifiers
  • Database connection / disconnection
  • Error handling
  • Miscellaneous utility methods
  • Simple queries
  • Non-SELECT statements
  • Binding Parameters and Output Columns
  • The do( ) and prepare( ) methods
  • Attributes and metadata
  • Transaction locking
  • ODBC and the Database Interface
  • Using the DBD and Win32 extensions
  • DBI Shell and Proxy Databases
  • dbish distribution
  • Database Proxy Architecture
Exercises
There are several hands-on machine exercises. All five Unix platforms will be available for lab exercises.