Programming in PERL: Using/Programming the Database Interface

King Training Resources
Littleton, Colorado, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' 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 ...''

Phone:800-252-0652 or 303-798-5727

School Address:

Peggy King
King Training Resources
6341 South Williams Street
Littleton, Colorado 80121-2627 USA


Jobs & Resumes: Littleton
Houses & Roommates: Littleton

Search other schools for Programming in PERL: Using/Programming the Database Interface training resources.

Casegen
CICS Command Level Coding
CICS Program Debugging
IMS/DB Programming
OS/390 Assembler Language
OS Assembler for Applications Programmers
Fundamentals of Unix
Unix System Administration
z/OS UNIX
Programming in PERL

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: If you want to post any message on this website, please do not include your real name, phone number, email address in the message body area. You should enter them in line text boxs respectively, if needed.