SQL Server Interview Questions and Answers: For All Database Developers and Developers Administrators (英語) ペーパーバック – 2011/10/11
Kindle 端末は必要ありません。無料 Kindle アプリのいずれかをダウンロードすると、スマートフォン、タブレットPCで Kindle 本をお読みいただけます。
This book will flow in a "Question & Answer" mode from start to finish to help you grasp concepts faster and get to the point quickly. Once you understand the concepts, it gets easier to see twists using that concept within a scenario and to ultimately solve them. Though each of these chapters are geared towards convenience we highly recommend reading each of the sections irrespective of the roles you might be doing since each of the sections have some interesting trivia about working with SQL Server. In the industry the role of accidental DBA's (especially with SQL Server) is very common. Hence if you have performed the role of DBA for a short stint and want to brush-up your fundamentals then the upcoming sections will be a great review. --このテキストは、ペーパーバック版に関連付けられています。
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.
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.
However there were continual references of "If you wish to learn more, read Joes 2 Pros", so the book came across as more of an advertisement.
Then that turned into simply copy & pastes of his Blog that you can read for free.
I am highly doubtful anyone would be asked these questions during an interview.
I'd have rated it 2 out of 5 if it was not so cheap.