Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your email address or mobile phone number.
SQL Server Interview Questions and Answers: For All Database Developers and Developers Administrators Paperback – October 11, 2011
No Starch Press Brand Page
Check out these featured titles from No Starch Press.
Customers Who Bought This Item Also Bought
If you’re the author, publisher, or rights holder of this book, let ACX help you produce the audiobook.Learn more.
Top Customer Reviews
Although the name contains the word "Interview", this book is much more than just an interview questions guide. As you start reading the book, what you realize immediately is that this small package covers almost everything under the SQL Server umbrella, and caters to multiple audiences of multiple proficiency levels. The book is a ready-reckoner for every SQL Server developer & administrator. When reading the book, I found myself thinking about a concept that I hadn't touched in a while, or which I was not sure about. In such cases, I went over to the reference links at the end of such questions that are available where one can go to for additional information.
With real world questions and practical answers, this is one book you simply cannot afford to miss. Gift yourself a copy today.
(Read my full review here -[...]
demonstrate some deeper understanding of each topic. An interviewer is also likely to be aware of this book and
would dig deeper to test the understanding.
What I enjoyed was: each topic ended with a url for more details on Pinal's blog. This is awesome.
What I didn't dig as much: where a bit more depth was required, they referred the reader to the Joes 2 Pros book.
So I'd recommend to get the Joes2Pros book, or another book.
Regardless of how much you work with SQL Server there are numerous little details that either get forgotten or may not have been acquired in the first place. Pinal and Vimod address a pretty comprehensive list of questions with brief yet thoroughly accurate responses that will increase a candidate's confidence when it comes to the in-depth challenges of a technical interview. In my case, for instance, being able to say that a TRUNCATE command is "minimally logged" as opposed to "unlogged" (a common misconception) separated me from the pack - a detail that was clarified directly from the book.
This book won't make up for any lack of whiteboard skills (such as writing out queries or designing schemas). You still will have to show your stuff on your own there. I was amazed, however, at the sheer number of questions that came directly out of the book. I knew the gist of the answers for the most part on my own, but Pinal and Vimod helped form my responses in a coherent, confident way. If you are serious about preparation for a career in SQL Server, this book should be an arrow in your quiver.
Does not go deep into the answers for some tricky questions. Ideal for 1st or 2nd interview for any aspiring SQL Server DBA/Developer. I mostly gift this book to my students.
The author gave most of the content for free on his blog site but it is so good and I still bought the whole book. I am very satisfied.
Very high quality book.
I have written a detailed chapter-by-chapter review of this book on www DOT i-programmer DOT info, the first and last parts of this review are given here. For my review of all chapters, search i-programmer DOT info for STIRK together with the book's title.
Interviews are the main method used to show your understanding of SQL Server. This book contains commonly asked interview questions together with their answers. Will it help you get a job?
Many of us attend interviews in the hope of getting a job. So potentially this book could prove very helpful in getting you that job, by both identifying the common SQL Server questions asked, and giving you the answers to those questions. I work freelance, having had 13 contracts over the last 18 years, I also regularly interview candidates for SQL Server related roles, so hopefully I'm qualified to say how relevant the questions and answers are.
The book is divided into the following chapters:
*Database concepts with SQL Server
*Common generic questions & answers
*Common developer questions
*Common tricky questions
*Miscellaneous questions on SQL Server 2008
*DBA skills related questions
*Data warehousing interview questions & answers
*General best practices
You can see from the chapter headings the book should be suitable for SQL Server developers, DBAs, and data warehouse specialists...
The book is a good guide to the type of questions you will be asked at a SQL Server interview, and many of the answers given are sufficient, however for some interviews you may need to go a bit deeper, and a few answers need revising. Overall, I think this book will help you get that SQL Server job. Recommended.
Most Recent Customer Reviews
great place to get ideas where to focus your studying if you are learning SQL or want to get an SQL job and need to find your weaknessesPublished 11 months ago by Don Fouts
I honestly have no negative comment about this book. It's the perfect book for anyone; whether you are experienced who is looking to refresh your knowledge or a starter with basic... Read morePublished 14 months ago by bi dev
Best book you can have for interviews, it is just not only for the person giving the interview but also interviewersPublished 14 months ago by ishtiaq
Little above then basic level. Gd enough for db develop interview of exp level 3-5 years. But not sufficient for more experienced. Read morePublished 17 months ago by Gagan Kumarsharma
Very easy language which is extremely useful to understand.Published 20 months ago by Amazon Customer