in reply to
my best read it is not present in your list: Perl Cookbook was for me and by far the more precious font of inspiration.
Then, and cosider me still a student, because we are in 2012, search something named Modern Perl and stress your scripts with Criticism.
Remember also that the wheel was invented yet and you can find last models of it at cpan.
If you survived, start writing program similar to your real needs (DBI recipes and CGI manual for the mentioned 'medium' term goal) and for every problem that block you do a Super Search at perlmonks.
If you get stucked in the learning curve, seriously consider the option to hire me... ;=) as medium level teatcher or a brick-layer coder..
there are no rules, there are no thumbs..