Course Description

Most applications need to store persistent data in some form. And many of those applications will use a database as that storage. For many years Perl has had a powerful database interface layer called DBI, but your Perl database programming will be even simpler if you use DBIx::Class on top of DBI.

In this one-day course we will introduce DBIx::Class and explain how it can help you get your job done more quickly.

Intended Audience

This course is aimed at intermediate Perl programmers who what to interact with databases using Perl. In order to get the most out this course you should be familiar with using references in Perl and with installing and using CPAN modules. You should also be comfortable using SQL.

Key Skills

At the end of this course you will be able to:

  • Interact with databases using Perl and DBIx::Class
  • Create schema classes to represent your database tables
  • Carry out basic CRUD operations
  • Use some advanced DBIx::Class facilities

Course Content

  1. Introduction to relational databases
  2. Introduction to databases and Perl
    • DBI
    • ORMs
  3. Schema classes
    • Creating manually
    • DBIx::Class::Schema::Loader
  4. Basic DB operations
    • Creating
    • Reading
    • Updating
    • Deleting
  5. Advanced queries
    • Ordering & Paging
    • Joins
    • Grouping & Aggregating
    • Chaining Resultsets
  6. Extending DBIC
    • Components
    • Inflation & Deflation
    • Adding Methods
    • Resultset Classes
  7. Useful Extensions
    • Deploying Schemas
    • Upgrading Schemas
    • Replication
  8. Using DBIC With Moose
  9. Further Information

Leave a Reply

Your email address will not be published. Required fields are marked *