Develop your skills in using Perl's object-oriented modules to access files in web and native applications on UNIX/Linux and MS-Windows.

Course Description

In this course you learn to write Perl scripts in your operating system environment, and apply Perl built-in functions.

You can learn to:

• Edit text with Perl expressions

• Access and manipulate data from multiple files

• Solve problems using Perl's decision operators and built-in functions

• Create code in reusable modules and subroutines

• Create Perl scripts to process Web queries

• Retrieve data to create dynamic Web content

• Connect to a SQL database

• Create and retrieve data from a SQL database

Who Needs to Attend

Anyone involved in database or web site development using Perl, including:

• webmasters

• Linux and UNIX administrators

• Windows support technicians

• software engineers

• business analysts

• network techs

• web developers

• technology auditors

• IT managers

• programmers, coders, etc.

• power users

Prerequisites

Prior  experience with "any C-like language" which includes: C, C#, C++; or awk, php, Java, Perl, csh, bourne shell, sed, classic procedural languages like Pascal, Fortran, assembler, COBOL, less common languages like PostScript, Forth, ladder logic, logo, PL1, algol, macro languages like Excel, Word, PLSQL, Cold Fusion, or Visual Basic, Word Basic, Business BASIC

Knowledge of UNIX regular expressions and scripting tools (e.g. Korn Shell, grep, sed, and awk) is helpful but not required.

Course Content

• Perl History and Context

• Writing Simple Perl Programs in a CLI

• Variables

• Operators and functions

• Conditionals

• Subroutines

• Regular Expressions

• File IO

• More regular expressions

• More functions

• System interaction

• References and data structures

• Perl Style

• Database Theory

• Textfiles as databases

• Relational databases

• MySQL and PostgreSQL

• DBI/DBD modules

• Acme Exercises

• What is CGI

• Generating HTML from Perl

• Processing FORM input

• Security Issues

• Helpful Modules for Web Development

Optional items that will be covered as time permits:

• Win32 modules

• XML modules

• DBIx modules (particularly DBIx::Class with Class::DBI for context)

• Web Frameworks (particularly Catalyst)

• Graphics Programming in Perl

• Bioinformatics (which is naturally perl)

• Intense regular expressions

• Creating Perl Modules for CPAN