Solved

Which SQL book?

Posted on 2004-09-10
4
189 Views
Last Modified: 2010-04-06
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
Comment
Question by:apresto
  • 2
4 Comments
 
LVL 15

Expert Comment

by:joeposter649
ID: 12029569
If you already know the basics you should look for one on your specific database.
0
 
LVL 23

Author Comment

by:apresto
ID: 12029642
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
 
LVL 4

Accepted Solution

by:
Neil_Simpson earned 25 total points
ID: 12031034
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
 
LVL 23

Author Comment

by:apresto
ID: 12047414
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
From XSL to Word - How add a page break? 5 29
XSLT 5 41
Owl Carousel 6 171
Clean URL from GET variables 2 93
Most of the sites are being standardized with W3C Web Standards. W3C provides lot of web standard services to the web. They have the web specification, process and documentation for all the web standards. You can apply HTML, CSS and Accessibility st…
Preface This article introduces an authentication and authorization system for a website.  It is understood by the author and the project contributors that there is no such thing as a "one size fits all" system.  That being said, there is a certa…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now