Microsoft® SQL Server® 2008 T-SQL Fundamentals (Anglais) Broché – 22 octobre 2008
|Neuf à partir de||Occasion à partir de|
Description du produit
Présentation de l'éditeur
Master the foundations of T-SQL with the right balance of conceptual and practical content. Get hands-on guidance—including exercises and code samples—that show you how to develop code to query and modify data. You’ll gain a solid understanding of the T-SQL language and good programming practices, and learn to write more efficient and powerful queries.
Discover how to:
Apply T-SQL fundamentals, create tables, and define data integrity Understand logical query processing Query multiple tables using joins and subqueries Simplify code and improve maintainability with table expressions Explore pivoting techniques and how to handle grouping sets Write code that modifies data Isolate inconsistent data and address deadlock and blocking scenarios
Biographie de l'auteur
Itzik Ben-Gan is a mentor and cofounder of SolidQ. A Microsoft MVP for SQL Server since 1999, Ben-Gan teaches and consults internationally on T-SQL querying, programming, and query tuning. He is the author of Microsoft SQL Server T-SQL Fundamentals and coauthor of Inside Microsoft SQL Server: T-SQL Querying and Inside Microsoft SQL Server:T-SQL Programming. 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.
Aucun appareil Kindle n'est requis. Téléchargez l'une des applis Kindle gratuites et commencez à lire les livres Kindle sur votre smartphone, tablette ou ordinateur.
Pour obtenir l'appli gratuite, saisissez votre numéro de téléphone mobile.
Détails sur le produit
Si vous vendez ce produit, souhaitez-vous suggérer des mises à jour par l'intermédiaire du support vendeur ?
Commentaires client les plus utiles sur Amazon.com
This book is not a good one to use as a base to learn SQL. It should be looked at as a supplement for someone that has a basic understanding and wants a beginning look "under the hood". It covers sections very quickly, is very text bookish while reading and is short in length. Looking through the summary prior to purchase, I was excited to see so many different topics to be covered. Once I arrived, it was disappointing to find these topics condensed to a couple of pages, with much of that filled with SQL code examples. It's brilliant, but left me wanting more on each topic consistently.
I yearn for the author that can write a guide on SQL in the same manner that Wheelan wrote on economics in Naked Economics, clear, easy to understand and engaging.
For me, this has been one of those rare reads, where I can see where the topic is going but it is never dull because I either learn something new about the subject or the presentation clarifies what I already knew. I especially like how the book continually reinforces how T-SQL is built on set theory and predicate logic.
Great read and reference. I highly recommend it.
Kudos to the author.
Itzik Ben-Gan is a wonderful author, who really understands how to teach a subject. Instead of just throwing code out there at you for a specific result, he often goes through it line by line letting you know exactly what each step is accomplishing. One of the greatest things about this book is the time taken to emphasize the order in which things are processed in SQL Server. This may seem trivial, but after knowing this I can honestly say 90% of the coding errors I ever suffered where due to not knowing the processing order.
The bottom line is, I would recommend this book to anyone who is interested in knowing T-SQL.
I've been a SQL System Administrator for many years, but never needed to understand the queries, just how to protect, backup and recover the databases. Thank goodness my husband was able to translate for me! For this reason I give it a 1.5 star rating for new users but a 4.5 rating for T-SQL administrators. Once I was able to understand what he was trying to say, and reference the […] website to break the queries into manageable bites, the lights came on.
I have now purchased a few other T-SQL books and without a doubt, this unique reference will become my master. However I couldn't do this without taking the first lessons in more introductory material. Can't wait to be a guru and actually understand this beast of a book!
Rechercher des articles similaires par rubrique