Training Course:Perl DBI moduleSchool/Trainer:QA Ltd.
Aberdeen, Birmingham, Bristol, Edinburgh, Exeter, Glasgow, Leeds, London, Manchester, Slough, United Kingdom
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' The popular Perl programming language is incredibly versatile. One of its niche uses is in interfacing with databases. Interfaces are available for all the popular Relational Database Management Systems, like Oracle, Sybase, DB2, SQL Server, MySQL, and so on. These are controlled through a common Perl interface, the DBI module.
This course shows how to use the module effectively from Perl.
The course uses Linux with MySQL for practical exercises, but is applicable to other operating systems and databases.
No specific recommendations.
Prerequisites
Experienced Perl 5 developers and support staff who wish to use and support Perl interfaces with database systems.
Delegates must have recent experience of Perl, and some knowledge of SQL.
Delegates will learn how to
Use non-DBI databases
Create databases and tables using Perl DBI
Use SQL statements effectively from Perl
Understand and use the different techniques for fetching data
Write dynamic SQL queries and updates
Handle errors and perform diagnostics
Use the DBI Shell
Extra Information
Perl Reminder
Perl documentation; Perl variables; Context; References; Subroutines; Modules; Perl OO
Perl and databases
Introduction; DBI and DBD; Drivers and data source names; The DBI shell; A test database; dbi:DBM: and dbish
Using database handles
Database handles; Connect and disconnect; Attributes for connect; Manual error checking; Atomic fetching; Batch fetching; Statement shortcut �do; Other database handle methods; Pitfalls
Using statement handles
Life cycle of a statement; Fetching rows; Retrieving result sets; Fetching metadata; Calling a stored procedure; Other statement handle methods
Placeholders
Placeholder syntax ; Repeated statement execution; Dynamic SQL; Bulk substitution; Placeholders with $dbh->do; Data typing with bindparam; Binding output to variables
Transactions
Principles of transaction handling; Database capabilities; Manual transaction control; Error handling ...''
Elements of this syllabus are subject to change.
Please go to the school's official website for training price and schedule:
http://www.qa.com/
Phone:0844 871 2080
School Address:
TEL: 0844 871 2080
E-mail us: info@qa.com
Jobs & Resumes: Aberdeen, Birmingham, Bristol, Edinburgh, Exeter, Glasgow, Leeds, London, Manchester, Slough
Houses & Roommates: Aberdeen, Birmingham, Bristol, Edinburgh, Exeter, Glasgow, Leeds, London, Manchester, Slough
Travel Agencies: Birmingham, Bristol, Edinburgh, Leeds, London, Manchester,
Search other schools for Perl DBI module training resources.
Other training courses offered by QA Ltd.:
oracle database 10g: program with pl/sql
Oracle Database 10g: SQL Tuning
Oracle Forms Developer 10g
oracle reports developer 10g
oracleas discoverer 10g
oracle database 11g
oracle database 11g: program with pl/sql
Advanced Perl with CGI and Web Applications
Perl 5 Object Oriented Programming
Perl
RHCE
Red Hat Enterprise Linux Update
Red Hat Linux Essentials
Red Hat Linux Networking and Security
Red Hat Linux
siebel
siebel essentials
j2ee
Business Component Development with Enterprise JavaBeans Technology
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:
ASKEDU jobs and talents message board can help you find jobs related to your experience in a specific city, or hire somebody in place with particular knowledges. |
|
|
