SQL / VBA Books

[Sockpuppet]

Ok, so got a new contract doing some sql/vba stuff for a client.

Looking for a good reference book (other than Google!). Not looking to learn SQL or VBA (Excel type vba) but more a ref manual of what the avail functions are.

SQL I can do pretty much most thing just looking for extra help on more complex joins, selecting as a type e.g. as Unixtime() etc.

Any ideas for books?

 

[DBA_bloke]

Ok, so got a new contract doing some sql/vba stuff for a client.

Looking for a good reference book (other than Google!). Not looking to learn SQL or VBA (Excel type vba) but more a ref manual of what the avail functions are.

SQL I can do pretty much most thing just looking for extra help on more complex joins, selecting as a type e.g. as Unixtime() etc.

Any ideas for books?

Secured contract yet not fully versed in the technology? Your CV & blagging skills must be amazingly convincing!

 

[Sockpuppet]

Well the SQL/VBA is only a part of the contract.

There are other parts which is why I got the contract. Besides I though contractors were meant to get a contract they couldn't do and learn on the job. Also SQL/VBA is not like pretending that I know ADA.

 

[RightLaugh]

Excel VBA for Dummies?

 

[MrRobin]

You say you want a book rather than just using Google to be able to understand various functions, instead of actually working your way thru a text to learn, but I say, why bother? A google search or a popular tech forum post (e.g. MrExcel, OzGrid etc) will be far quicker wouldn't it? Grab a complex spreadsheet with inbedded queries and or some stored procedures when you're there and reverse engineer it... I find that is the most efficient way to learn (and remember) new functions and techniques.

R

 

[lilelvis2000]

Ditto. I learn more from searching around and downloading code snippets than by books these days. The only books I buy now are those slim quick reference books.

 

[xoggoth]

"Writing Excel Macros" by O'Reilly is good. I would agree the net is best for something huge with n million classes like vb.net, but for excel VBA that smallish book is all you need really.

 

[thunderlizard]

I used to use this little feller back in the day:
http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764544012.html

For SQL, it really does vary based on which implementation you're using. Maybe look into the little O'Reilly "Pocket Reference" series.

 

[Sockpuppet]

Cheers for the replies guys.