SQL Book

Question

Post reply

SQL Book

jagirdba

SSC Rookie

Points: 45
More actions
November 20, 2010 at 9:48 am

#228906

Hi Folks,
I am currently preparing for SQL DBA job interview. Can somebody please suggest a good book to study.
I would really appreciate it.
Thank you

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

I'll be blunt, if you don't know the area and have an upcoming interview, a book is not going to help much.

Relax

Don't overstate your skills

Don't be afraid to say 'I don't know'

As for a book, a book on what? SQL's a wide field and there are hundreds of books from introductory admin up to deep internals, development, BI as well as tonnes of very specific books.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Sachin Nandanwar SSCertifiable Points: 7699 More actions · Answer 2

jagirdba (11/20/2010)
Hi Folks,
I am currently preparing for SQL DBA job interview. Can somebody please suggest a good book to study.
I would really appreciate it.
Thank you

I am appearing for an interview of neurosurgeon.Can anyone suggest me a book to study?:-D

--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server

jagirdba SSC Rookie Points: 45 More actions · Answer 3

Dear Mr Sachin,

First of all if you are preparing for a neurosurgeon what are you doing in SQL Server central? In that case you appear to have problem with your brain your self. Secondly if I was a neurosurgeon I would surely suggest a good book.

Thanks for wasting your useless time.

jagirdba SSC Rookie Points: 45 More actions · Answer 4

jagirdba

SSC Rookie

Points: 45

November 21, 2010 at 5:22 am

#1253484

Thanks Gail.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

jagirdba (11/21/2010)
In that case you appear to have problem with your brain your self. Secondly if I was a neurosurgeon I would surely suggest a good book.
Thanks for wasting your useless time.

That was uncalled for. Insults are unnecessary and are unprofessional. An apology from you would be appropriate at this point.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Carl Federl One Orange Chip Points: 25384 More actions · Answer 6

Out of the 50 some database books that I own and another 50 that I have read, here are the books that I consider essential. I do not work with OLAP, Integration Services, or Reporting Services, so I have not included any books on these topics.

Theory:

Databases, Types and the Relational Model ISBN-13: 978-0321399427 by C. J. Date and Hugh Darwen

Data and Databases: Concepts in Practice ISBN-13: 978-1558604322 by Joe Celko

Database Design

HANDBOOK OF RELATIONAL DATABASE DESIGN ISBN 0-201-11434-8 by C. C. Fleming and Barbara von Halle

The Data Modeling Handbook : A Best-Practice Approach to Building Quality Data Models by Michael Reingruber, and William W. Gregory ISBN: 0471052906;

Data and Databases: Concepts in Practice ISBN-13: 978-1558604322 by Joe Celko

SQL

SQL for Smarties ISBN-13: 978-0123820228 by Joe Celko

Microsoft SQL Server 2008 T-SQL Fundamentals ISBN-13: 978-0735626010 by Itzik Ben-Gan

Inside Microsoft SQL Server 2008: T-SQL Querying ISBN-13: 978-0735626034 by Itzik Ben-Gan, Lubor Kollar , Dejan Sarka , and Steve Kass

Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL ISBN-13: 978-0123741370 by Joe Celko

Trees and Hierarchies in SQL for Smarties ISBN-13: 978-1558609204 by Joe Celko

SQL Server

Microsoft SQL Server 2008 Bible ISBN-13: 978-0470257043 by Paul Nielsen, Uttam Parui

Microsoft SQL Server 2008 Internals ISBN-13: 978-0735626249 by Kalen Delaney

SQL Server 2008 Query Performance Tuning Distilled ISBN-13: 978-1430219026 by Grant Fritchey and Sajal Dam

SQL = Scarcely Qualifies as a Language

Jeff Moden SSC Guru Points: 1003851 More actions · Answer 7

GilaMonster (11/21/2010)
jagirdba (11/21/2010)
In that case you appear to have problem with your brain your self. Secondly if I was a neurosurgeon I would surely suggest a good book.
Thanks for wasting your useless time.
That was uncalled for. Insults are unnecessary and are unprofessional. An apology from you would be appropriate at this point.

Nah... the OP was just returning the favor. 😉

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)