LinuxQuestions.org
Review your favorite Linux distribution.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 05-01-2008, 05:23 AM   #1
shreks
Member
 
Registered: Aug 2004
Posts: 79

Rep: Reputation: 15
Recommendation of SQL Book?


Though his post may not fit here very well, the user community here usually has better knowledge of computer sciences and technologies. So I am wondering does anyone can recommend some classic SQL books for me to learn and grasp it? Many thanks!
 
Old 05-01-2008, 07:48 AM   #2
duryodhan
Senior Member
 
Registered: Oct 2006
Distribution: Slackware 12 Kernel 2.6.24 - probably upgraded by now
Posts: 1,054

Rep: Reputation: 46
classic I don't know

but I am usually very impressed by the headfirst series ... I haven't seen the Headfirst SQL one but it should be really good.
 
Old 05-01-2008, 07:45 PM   #3
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.10, Centos 7.5
Posts: 17,710

Rep: Reputation: 2520Reputation: 2520Reputation: 2520Reputation: 2520Reputation: 2520Reputation: 2520Reputation: 2520Reputation: 2520Reputation: 2520Reputation: 2520Reputation: 2520
Note that SQL varies depending on the supplier eg Oracle, Sybase, MySQL etc, so best to get a supplier specific book if you need this for serious work.
There is an ANSI SQL (basic) std, but they all add their own proprietary extensions/fns to it.
 
Old 05-03-2008, 10:17 PM   #4
padlamoij
Member
 
Registered: Oct 2002
Location: East Point, GA
Posts: 188

Rep: Reputation: 30
Ya, it really depends on what you are trying to do. Basic SQL is pretty straight forward. It's the fancy stuff and the optimizing that people spend time reading books about. If you're just using mysql with php or something like that just get a book on php/mysql. o'reilly makes a good one called 'Learning PHP and MYSQL'.

You really don't need a whole book to learn basic queries. Just a couple chapters. Unless you are looking for something much more in depth.
 
Old 05-04-2008, 09:35 PM   #5
sundialsvcs
LQ Guru
 
Registered: Feb 2004
Location: SE Tennessee, USA
Distribution: Gentoo, LFS
Posts: 9,078
Blog Entries: 4

Rep: Reputation: 3179Reputation: 3179Reputation: 3179Reputation: 3179Reputation: 3179Reputation: 3179Reputation: 3179Reputation: 3179Reputation: 3179Reputation: 3179Reputation: 3179
I'd start by looking on the web.

And maybe, I'd finish there.

The basic concepts of SQL are extremely simple. Where it gets interesting is when you have to deal with something vendor-specific, but you can do a lot with just the generic stuff.

I also found it helpful to "poke under the hood" just a little bit, to learn more about how SQL queries are converted into an "execution plan" and then actually carried-out. Once again, it's not difficult to understand.

The big picture is the most-important thing to grasp. Grasp it and hold onto it at whatever cost. It's perfectly all right to, when confronted with a detail, choose to ignore it at this time.
 
Old 05-05-2008, 08:53 PM   #6
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.10, Centos 7.5
Posts: 17,710

Rep: Reputation: 2520Reputation: 2520Reputation: 2520Reputation: 2520Reputation: 2520Reputation: 2520Reputation: 2520Reputation: 2520Reputation: 2520Reputation: 2520Reputation: 2520
Of course, if you are going to use MySQL bookmark this: http://dev.mysql.com/doc/refman/5.0/en/
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Book Recommendation no-von Linux - Server 2 03-15-2007 12:08 PM
Book recommendation? cmackay Linux - Newbie 3 01-08-2004 12:25 AM
Book Recommendation jasonmantey Linux - General 9 12-14-2003 02:06 PM
book recommendation? mark_2811 Linux - Newbie 3 09-24-2003 06:39 PM
Book Recommendation yyaron Linux - Networking 1 04-28-2001 03:50 AM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 07:08 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration