- Taschenbuch: 442 Seiten
- Verlag: Microsoft Press; Auflage: 1 (15. Juli 2012)
- Sprache: Englisch
- ISBN-10: 0735658145
- ISBN-13: 978-0735658141
- Größe und/oder Gewicht: 18,5 x 2,5 x 22,6 cm
- Durchschnittliche Kundenbewertung: 3 Kundenrezensionen
- Amazon Bestseller-Rang: Nr. 100.323 in Fremdsprachige Bücher (Siehe Top 100 in Fremdsprachige Bücher)
Microsoft SQL Server 2012 T-SQL Fundamentals (Englisch) Taschenbuch – 15. Juli 2012
|Neu ab||Gebraucht ab|
Wird oft zusammen gekauft
Kunden, die diesen Artikel gekauft haben, kauften auch
Es wird kein Kindle Gerät benötigt. Laden Sie eine der kostenlosen Kindle Apps herunter und beginnen Sie, Kindle-Bücher auf Ihrem Smartphone, Tablet und Computer zu lesen.
Geben Sie Ihre Mobiltelefonnummer ein, um die kostenfreie App zu beziehen.
Über den Autor und weitere Mitwirkende
Itzik Ben-Gan is a principal mentor and a founder of SolidQ. A Microsoft MVP for SQL Server since 1999, Itzik teaches and consults internationally on T-SQL querying, programming, and query tuning. He has written numerous articles for SQL Server Magazine and MSDN, and speaks at industry events such as Microsoft TechEd, DevWeek, PASS, and SQL Server Connections.
Welche anderen Artikel kaufen Kunden, nachdem sie diesen Artikel angesehen haben?
Ich habe es nach vielen Jahren der Arbeit mit SQL gelesen und Dinge gelernt, die ich vorher nie so in der Tiefe verstanden hatte. Nahezu jeder Programmierer verwendet SQL irgendwie, weil er ein paar SELECTs gesehen hat, aber auch keiner meiner Kollegen kannte die Dinge so in der Tiefe wie hier beschrieben. Schon das Kapitel über NULL Werte zeigt, warum in vielen Programmen oder ETL Prozessen noch nach Monaten des Live Betriebs merkwürdige Dinge auftreten.
Style s a bit heavy but still readable. You will go slowly. Examples are excellent.
Teilweise wurde auf gewisse Eigenheiten der Befehle nicht ausreichend eingegangen auch wenn versucht wurde, alles von Grund auf zu erklären. z.B. gibt es da die Group By und Having Statements, die zwar dargestellt wurden, aber letztlich nur sehr oberflächlich. Wenn man es dann selbst versucht, verhält es sich anders und man findet im Buch auch nicht die passende Erklärung dazu. Man kriegt es dann durch Versuch und Irrtum. Im Grunde erwarte ich mir von einem doch recht dicken Buch, dass ich nicht alles dann auf "Stackoverflow" nachsehen muss.
Irgendwie vermittelt das Buch nicht so recht das, was es vermitteln soll. Dabei gäbe es so viele Beispiele und Fragen zu Datenbanken in Internetforen, man müsste ja nur darauf eingehen und strukturiert in ein Buch verpacken. Es ist irgendwie weder eine gescheite Einführung noch eine Vertiefung, irgendwie furchtbar.
Die hilfreichsten Kundenrezensionen auf Amazon.com (beta)
The book relies on a dummy database that you should create on SQL 2012 and each chapter uses that code to elaborate all the concepts.
Each chapter ends with few exercises so if you already created the dummy database, you can (and should) start writing T-SQL code right away and validate what you read while learning how to think in sets during the process.
One of the things I like most of this book is that while this is a T-SQL book, Itzik keeps it vendor neutral (or tries to) so when the code deviates of the SQL standard, he warns you about it. That's good, because in case you need to start writing code for MySQL, Oracle or any other vendor, you are already aware of those differences or you wrote code that does not deviate too much of the regular SQL ANSI standard.
Do I recommend this book? Yes, I do, no doubt about it, but only if you do not own the SQL 2008 version. Otherwise, I see no point on getting this one. To be honest, It is basically the same book with the SQL 2012 title on it; the only difference I've seen so far is references to Window Functions, which are briefly covered on Chapter #7. Besides that, it is basically a reprint of the same nice book, but with different title.
First off, to address the order, he introduces right away in chapter 1 and chapter two concepts that I would not introduce until much later for a beginning TSQL class. Foreign Key relationships and Windowing functions are not beginning concepts, for instance, and thus should be introduced much later in the book in my opinion. Cross Joins are the first join type introduced in Chapter 2; this is a 'special' type of join used to create data or build lists, and is not used that often in the business world. A much better replacement might be the SELECT INTO, which is introduced way in the back of the book in a later chapter. There are other examples-my point is that for the beginner, the order here needs to be looked at more closely. It doesn't make sense a lot of the time.
Second, explanations and the use of drawings, pictures, or diagrams are lacking or non-existent. As an example, when I teach joins, I draw pictures on a whiteboard with minimal data to introduce concepts in a clear and concise manner; he has none of these. Many of the examples don't allow a student the opportunity to let the concepts 'hit home' because other ideas are introduced at the same time. Building from 'small to large', as it were, is for me a great method to use when explaining difficult concepts, but he does not use this methodology in the book.
Examples could be better. Right away I found that the examples in the chapter are not abundant, while the exercises are too far away from the examples, difficulty-wise. One reason is that his "TSQL2012" database could be better. I would use the AdventureWorks databases, which offer the ability to create more examples and questions at all levels of difficulties.
I could go on with more, but I think you get the idea of what I am trying to relay here...it's a good book, but I've seen better. As far as a book for someone who has never opened SSMS, or programmed and has no idea of the programming constructs, it leaves room for improvement as either a high school or jr. college textbook.
I base this review on my 13 years experience as an instructor at the jr. college level, so at this point I think I have a pretty good idea of how students handle TSQL concepts and the order of assimilation of these concepts. Using this book I find that I bounce around quite a bit, and leave many concepts out altogether. Do not walk away here with idea here that I'm flaming the book or the author, but rather critiquing the book based on how I am using the contents of the book. To me, it is evident that his first try at a beginner book has some fundamental flaws in a number of areas.
Maybe I'll write my own book one day...
It explained differences between T-SQL and ANSI SQL in situations that called for it in a non-biased way. He uses both.
The author comes across as an expert that really knows the SQL trade, he should he has been doing it for a long time and is valued peer in the SQL community.
If you know nothing about sql get it.
If you know a some sql get it.
If you know a lot about sql programming get it and give it to someone that bugs you too much about SQL.
If you want to learn a good writing style for technical learning subjects get it.
This book is one of my all time favorites on programming etc.
The best book on fundamentals period, whether you are a beginner or advanced. There is something for all developers.
There is a lot of misinformation in the various online blogs/forums but THIS TEXT provides you with a TECHNICAL GOSPEL for SQL programmers. I would say an interested beginner could absorb this material alone and qualify for entry level position. Experienced programmers will likely be provided insight and confirmation regarding their current skills and actually add more new techniques and understanding.
One other thing: I bought the hard copy and quickly realized that the ebook was going to work much better for me so I purchased that as well. I have the Kindle PC reader at home and at work. The reader presents the text in a very easy to read manner and if I make notes in the text, they follow me from work to home. Perfect for study! I don't think I will ever buy another hard copy of a technical manual if I can read and annotate the ebook version everywhere in a Kindle reader.