I have a CIS degree and work in local Govt = Low $$$ for training. I have learned Visual Basic on my own and would like to find a book that covers the "smart" way to program vs. the "however you can get it to work" way.
For example I am building a set of objects to use for moving and formatting data to/from oracle tables. (beats redeclaring 119 variables each time I write a program to insert data into 1 table!) I know globals are frowned on but wonder how other programmers handle database connections? Is it better to live with some globals than experience a performance loss by passing connections/recordsets all over the place?
So I am looking for a book or site that covers topics such as structured and object oriented programming and performance. Most of the programs I write do not have user interfaces - I use VB because it is quick to write. (we don't have much staff) (something similar in content to the OReilly book "Oracle PL/SQL Programming")