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
"synopsis" may belong to another edition of this title.
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.
"About this title" may belong to another edition of this title.
FREE shipping within United Kingdom
Destination, rates & speeds£ 32.40 shipping from U.S.A. to United Kingdom
Destination, rates & speedsSeller: Bahamut Media, Reading, United Kingdom
Paperback. Condition: Very Good. This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping. Seller Inventory # 6545-9780735626010
Quantity: 2 available
Seller: Goldstone Books, Llandybie, United Kingdom
paperback. Condition: Very Good. All orders are dispatched within one working day from our UK warehouse. We've been selling books online since 2004! We have over 750,000 books in stock. No quibble refund if not completely satisfied. Seller Inventory # mon0007149716
Quantity: 1 available
Seller: AwesomeBooks, Wallingford, United Kingdom
Paperback. Condition: Very Good. MicrosoftAr SQL ServerAr 2008 T-SQL Fundamentals (PRO-Developer) This book is in very good condition and will be shipped within 24 hours of ordering. The cover may have some limited signs of wear but the pages are clean, intact and the spine remains undamaged. This book has clearly been well maintained and looked after thus far. Money back guarantee if you are not satisfied. See all our books here, order more than 1 book and get discounted shipping. Seller Inventory # 7719-9780735626010
Quantity: 2 available
Seller: WorldofBooks, Goring-By-Sea, WS, United Kingdom
Paperback. Condition: Very Good. The book has been read, but is in excellent condition. Pages are intact and not marred by notes or highlighting. The spine remains undamaged. Seller Inventory # GOR004623451
Quantity: 3 available
Seller: medimops, Berlin, Germany
Condition: very good. Gut/Very good: Buch bzw. Schutzumschlag mit wenigen Gebrauchsspuren an Einband, Schutzumschlag oder Seiten. / Describes a book or dust jacket that does show some signs of wear on either the binding, dust jacket or pages. Seller Inventory # M00735626014-V
Quantity: 1 available
Seller: Buchmarie, Darmstadt, Germany
Condition: Good. Buchschnitt leicht verschmutzt. Cover leicht beschädigt. Seller Inventory # 2942228_a61_4x
Quantity: 1 available
Seller: Better World Books, Mishawaka, IN, U.S.A.
Condition: Good. 1st Edition. Used book that is in clean, average condition without any missing pages. Seller Inventory # 4479404-6
Quantity: 2 available
Seller: Better World Books, Mishawaka, IN, U.S.A.
Condition: Very Good. 1st Edition. Used book that is in excellent condition. May show signs of wear or have minor defects. Seller Inventory # GRP102735196
Quantity: 1 available
Seller: Bookbot, Prague, Czech Republic
Condition: Fine. This essential reference is designed for database developers and administrators who need to write queries and develop code using Transact-SQL (T-SQL), the Microsoft implementation of the standard SQL language. Guided by SQL Server guru Itzik Ben-Gan, you'll walk through the steps for writing queries, including retrieving and modifying data, with an overview of programmable objects supported by SQL Server 2008. Rather than focusing just on the syntactical elements of T-SQL, however, this book explains the logic behind the language -- helping you develop a true, core understanding of the elements and how to use them. You will learn to think in terms of sets, and follow real-world best practices for T-SQL programming.To complement the learning experience, the book provides exercises to practice and apply what you've learned. And you'll examine recommended solutions to compare with your own work. Seller Inventory # e90ee576-58af-4039-a18c-488d8b3f2499
Quantity: 1 available
Seller: ThriftBooks-Dallas, Dallas, TX, U.S.A.
Paperback. Condition: Very Good. No Jacket. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less 1.85. Seller Inventory # G0735626014I4N00
Quantity: 1 available