Microsoft SQL Server 2012 T-SQL Fundamentals et plus d'un million d'autres livres sont disponibles pour le Kindle d'Amazon. En savoir plus


ou
Identifiez-vous pour activer la commande 1-Click.
ou
en essayant gratuitement Amazon Premium pendant 30 jours. Votre inscription aura lieu lors du passage de la commande. En savoir plus.
Amazon Rachète votre article
Recevez un chèque-cadeau de EUR 11,32
Amazon Rachète cet article
Plus de choix
Vous l'avez déjà ? Vendez votre exemplaire ici
Désolé, cet article n'est pas disponible en
Image non disponible pour la
couleur :
Image non disponible

 
Commencez à lire Microsoft SQL Server 2012 T-SQL Fundamentals sur votre Kindle en moins d'une minute.

Vous n'avez pas encore de Kindle ? Achetez-le ici ou téléchargez une application de lecture gratuite.

Microsoft SQL Server 2012 T-SQL Fundamentals [Anglais] [Broché]

Itzik Ben-Gan

Prix : EUR 51,36 Livraison à EUR 0,01 En savoir plus.
  Tous les prix incluent la TVA
o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o o
Il ne reste plus que 6 exemplaire(s) en stock (d'autres exemplaires sont en cours d'acheminement).
Expédié et vendu par Amazon. Emballage cadeau disponible.
Voulez-vous le faire livrer le mardi 5 août ? Choisissez la livraison en 1 jour ouvré sur votre bon de commande. En savoir plus.

Formats

Prix Amazon Neuf à partir de Occasion à partir de
Format Kindle EUR 18,74  
Broché EUR 51,36  
Vendez cet article - Prix de rachat jusqu'à EUR 11,32
Vendez Microsoft SQL Server 2012 T-SQL Fundamentals contre un chèque-cadeau d'une valeur pouvant aller jusqu'à EUR 11,32, que vous pourrez ensuite utiliser sur tout le site Amazon.fr. Les valeurs de rachat peuvent varier (voir les critères d'éligibilité des produits). En savoir plus sur notre programme de reprise Amazon Rachète.

Description de l'ouvrage

15 juillet 2012

Gain a solid understanding of T-SQL—and write better queries

Master the fundamentals of Transact-SQL—and develop your own code for querying and modifying data in Microsoft SQL Server 2012. Led by a SQL Server expert, you’ll learn the concepts behind T-SQL querying and programming, and then apply your knowledge with exercises in each chapter. Once you understand the logic behind T-SQL, you’ll quickly learn how to write effective code—whether you’re a programmer or database administrator.

Discover how to:

  • Work with programming practices unique to T-SQL
  • Create database tables and define data integrity
  • Query multiple tables using joins and subqueries
  • Simplify code and improve maintainability with table expressions
  • Implement insert, update, delete, and merge data modification strategies
  • Tackle advanced techniques such as window functions, pivoting and grouping sets
  • Control data consistency using isolation levels, and mitigate deadlocks and blocking
  • Take T-SQL to the next level with programmable objects

Offres spéciales et liens associés


Produits fréquemment achetés ensemble

Microsoft SQL Server 2012 T-SQL Fundamentals + Microsoft SQL Server 2012 High-Performance T-SQL Using Window Functions + Microsoft SQL Server 2012 Internals
Acheter les articles sélectionnés ensemble


Descriptions du produit

Biographie de l'auteur

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.


Détails sur le produit


En savoir plus sur l'auteur

Découvrez des livres, informez-vous sur les écrivains, lisez des blogs d'auteurs et bien plus encore.

Quels sont les autres articles que les clients achètent après avoir regardé cet article?


Commentaires en ligne 

Il n'y a pas encore de commentaires clients sur Amazon.fr
5 étoiles
4 étoiles
3 étoiles
2 étoiles
1 étoiles
Commentaires client les plus utiles sur Amazon.com (beta)
Amazon.com: 4.6 étoiles sur 5  38 commentaires
39 internautes sur 42 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 The best intro book for T-SQL, period! 3 septembre 2012
Par Jose - Publié sur Amazon.com
Format:Broché
This book is a masterpiece. It teaches you the fundamentals of T-SQL, while showing you the logic and set theory behind. A good approach, in my opinion, because T-SQL is based on set theory; ignoring that, makes developers to write T-SQL code in a programatic way, causing horrible performance issues and long running queries that take an eternity to finish. As a DBA, I've seen this over and over again, usually from developers that do not know how to think in sets.

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.
20 internautes sur 23 ont trouvé ce commentaire utile 
3.0 étoiles sur 5 Good resource - not a college text for an introductory course 12 septembre 2013
Par Raymond L Everest - Publié sur Amazon.com
Format:Broché|Achat vérifié
The author, an expert in the field, publishes his first introductory book on TSQL, and although the title 'T-SQL Fundamentals' is representative of the content, the use of the book for a college textbook leaves room for improvement. I used this book for a 3-hr IT credit course this semester at a local community college...the book does have good information. The problems are in that 1) the order of introduction is not optimal, 2) the explanations via pictorials or diagrams for a pure beginner are lacking, and 3) the example code could be better.

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...
6 internautes sur 6 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 it does everything it does well 19 janvier 2013
Par forrest - Publié sur Amazon.com
Format:Broché
I think it did everything that it did very well.
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.
4 internautes sur 4 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 Itzik Ben-Gan is the Master 6 août 2013
Par John Grove - Publié sur Amazon.com
Format:Broché
This introductory book does what no other does. It explains set theory, predicate logic, relations, propositions, normalization, SQL Server architecture, windows functions, pivoting data and laying the foundation strongly before explaining T-SQL. And when it gets to that, as the mafiosos say forget about it.

The best book on fundamentals period, whether you are a beginner or advanced. There is something for all developers.
2 internautes sur 2 ont trouvé ce commentaire utile 
5.0 étoiles sur 5 Excellent for SQL 27 juin 2013
Par Ashwin - Publié sur Amazon.com
Format:Broché|Achat vérifié
Good book for SQL fundamentals. Recommended for any professional who's work needs good knowledge of SQL. Book worth the money.
Ces commentaires ont-ils été utiles ?   Dites-le-nous

Discussions entre clients

Le forum concernant ce produit
Discussion Réponses Message le plus récent
Pas de discussions pour l'instant

Posez des questions, partagez votre opinion, gagnez en compréhension
Démarrer une nouvelle discussion
Thème:
Première publication:
Aller s'identifier
 

Rechercher parmi les discussions des clients
Rechercher dans toutes les discussions Amazon
   


Rechercher des articles similaires par rubrique


Commentaires

Souhaitez-vous compléter ou améliorer les informations sur ce produit ? Ou faire modifier les images?