VBA and SQL book recommendations
Bara medlemmar i LibraryThing kan skriva.
Denna diskussion är för närvarande "vilande"—det sista inlägget är mer än 90 dagar gammalt. Du kan återstarta det genom att svara på inlägget.
We mainly use VBA for Excel and SQL in our work (please don't laught at me - it's the company's tools of choice *sigh*). I'm reasonably good at Googling when I'm not quite sure how to do what I need to, but sometimes even working out what term I need to Google for is difficult. So if anyone has any good suggestions for reference texts on either subject, I'd be most grateful. The kind of thing that I can flick through when I need to know how to get Excel doing something funky with Outlook or what I should be looking for the next time I need to programatically mess around with Pivot Tables would be really helpful. If it has hints and tips on writing more efficient VBA, that would also be really good.
I've got the O'Reilly SQL Pocket Guide sitting in my desk drawer, which is very useful when trying to remember exactly how something I don't use regularly works, but is there a big book equivalent to it that I could invest in? We use Teradata SQL, which is faily ANSII compliant (except when it isn't...) so one of the general SQL texts usually gives me a starting point, at least.
All recommendations will be gratefully received.
If you search on VBA Excel in either of those, you will get hits.
New books cost $40 or more, but you can get used books for $5 or so. Just be sure to email the sellers BEFORE purchasing to verify that the CDs are in the book. I prefer the older books to the latest books because the latest books don't go into the deep technical information that the older books did. Also, I prefer having the CD in my hands to having to download it. It's quite reasonable that you will need to reference material three or four years from now, and if you have the book, you've got the CD. The URLs will probably be obsolete in a year or two, so you'll have to download the whole website.
Amazon will let you look at the covers, which usually explain what level of expertise the book is aimed at, and also the Tables of content will let you see what's in the books.