SQL / VBA Books

Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!

You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:

You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

Sockpuppet replied

12 September 2007, 01:52
Cheers for the replies guys.
Leave a comment:
thunderlizard replied

11 September 2007, 23:06
I used to use this little feller back in the day:
http://www.wrox.com/WileyCDA/WroxTit...764544012.html

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

11 September 2007, 16:27
"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.

Last edited by xoggoth; 11 September 2007, 16:31.
Leave a comment:
lilelvis2000 replied

11 September 2007, 11:01
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.
Leave a comment:
MrRobin replied

11 September 2007, 10:30
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
Leave a comment:
RightLaugh replied

11 September 2007, 10:12
Excel VBA for Dummies?
Leave a comment:
Sockpuppet replied

11 September 2007, 10:06
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.
Leave a comment:
DBA_bloke replied

11 September 2007, 09:56
Originally posted by Sockpuppet View Post

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!
Leave a comment:
Sockpuppet started a topic SQL / VBA Books

11 September 2007, 09:39
SQL / VBA Books

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?
Tags: None