Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 198
  • Last Modified:

Which SQL book?

Hi,

I am looking around for a book on SQL, im not an SQL beginner but im not a complete dunce, i know the basics (SELECT, UPDATE, DELETE), its stuff like Joins, Alias and unions that i owuld like to master - basically the more advanced, helpful features of SQL.

can anyone recommend a book that can cater for this?  
0
apresto
Asked:
apresto
  • 2
1 Solution
 
joeposter649Commented:
If you already know the basics you should look for one on your specific database.
0
 
aprestoAuthor Commented:
think is i knwo the basics (of the language) and i have been using access, but i thought that the syntax and language in general was the same for both sql server and access - If i want to learn sql server would this differ from what i know already?
0
 
Neil_SimpsonCommented:
SQL differs slightly from application to application, the general principles are the same though.

If you are quite competent already you'd be best using an O'Reilly book for reference like http://www.oreilly.com/catalog/sqlnut2/. You might also look for an O'Reilly cookbook for efficient solutions to common problems.

If you are keen to learn SQL before attempting any task rather than as you go you might want to try a tutorial book such as SAMS Teach Youself SQL in 24 hours (http://www.amazon.com/exec/obidos/tg/detail/-/067231245X/103-9641790-2630201?v=glance)
0
 
aprestoAuthor Commented:
Thanks alot, im gonna go with the SQL in a nutshell, i have vb.net in a nutshell and that is a good book, both for learning and for a quick reference so i assume the sql version will be the same
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now