Perl Advanced

This course teaches students the Perl skills needed to rapidly and efficiently develop complex, database-driven Web applications.

After completing this course, students will be able to:

• Develop Faster With CGI.pm Shortcuts
• Remember Users With Cookies
• Web-Enable Your Databases With the DBI Module
• Learn the Ropes of SQL
• Make it Convenient
• Keep it Portable
• Extend it With Modules
  

Target audience

Students should have a good working knowledge of CGI scripting with Perl gained through prior experience or from an attendance on an introductory level course.

Course content

Introduction The Database Used for the Class • A Note About Your Files

Shortcuts with CGI.pm Tired of Printing "Content-type" and HTML Tags? • Object-Oriented vs. Method-Oriented Perl • A More Detailed Example • A Template for Creating Your Own Scripts • Exercise 1: Using CGI.pm Shortcuts

Working with Arrays splice • shift • unshift • push • pop • Mini-Exercise: Practicing with Array Functions

Keep it Portable! The File::Basename Module and $0 • The Cwd Module

Reduce, Reuse, Recycle Avoiding Variable Confusion with my and local • Mini-Exercise: Using use strict and my

Connecting to a Database Server Architecture • A Review of Database Concepts

DBI.pm: the Database Interface Module A Sample CGI Script Using DBI • Exercise 2: Listing Houses from the Database

Error Handling and Prevention Example: Find Agents by Last Name • A More Complete Error-Handling Example • Exercise 3: Error-Protecting a Search Script

Multi-Table Queries

Drill-Down Links A More Sophisticated Example • Exercise 4: Building Drill-Down Links

Inserting Records Building a Dynamic Drop-Down Menu • Exercise 5: Inserting a House into the Database

Updating Database Records Exercise 6: Updating a House Record

Deleting Records Exercise 7: Deleting a House from the Database

Uploading Files with CGI.pm Review: Writing to Files in Perl • Special Features of File Upload Forms • Special Features of the Upload Processing Script • Exercise 8: Uploading House Photos

File Test Operators Example: a Directory Map • Exercise 9: Add Links to House Photos

Working with Cookies An Example Page Using Cookies • Creating Cookies with CGI.pm • Retrieving Cookies with CGI.pm • Assigning Arrays to Cookies and Retrieving Them • Other Parameters that can be Passed to the cookie() Method • Creating Multiple Cookies • Exercise 10: Remembering Visitors with Cookies

Appendix A: Creating a System DSN How to Create a DSN

Appendix B: An Overview of SQL Data Types in SQL • Creating a Table in SQL • Inserting a Row into the Table in SQL • Inserting a Partial Row (or Fields in a Different Order) in SQL • Retrieving Information from the Database via SELECT • Editing Records in the Database with the UPDATE Statement • Removing Records from the Database with the DELETE Statement

Appendix C: Downloading Perl Modules Windows: Perl Package Manager • UNIX: CPAN.pm

Appendix D: Security and Taint Mode Solution: Scrub Your Data with Regular Expressions • Ensuring Data Scrubbing with Taint Mode

Appendix E: Recommended Resources

About Courseware Company :: Instructor-led training courseware :: Self-study solutions :: Buy online today