 Trade In this Item for up to £11.00
Get an extra £5 when you trade in books worth £10 or more until June 30, 2012. Trade in Microsoft SQL Server 2008 T-SQL Fundamentals (PRO-Developer) for an Amazon.co.uk gift card of up to £11.00, which you can then spend on millions of items across the site. Trade-in values may vary (terms apply). Find more products eligible for trade-in.
|
Frequently Bought Together
Product details
|
More About the Author
Product Description
Product Description
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
About the Author
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.
Inside This Book
(Learn More)
Tags Customers Associate with This Product(What's this?)Click on a tag to find related items, discussions, and people.
|
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
What Other Items Do Customers Buy After Viewing This Item?
Customer Reviews
Most Helpful Customer Reviews
14 of 14 people found the following review helpful
Format:Paperback
I teach SQL Server for a living, and even though I've been talking about the subject for ten years and working with the product for longer, there are things I've picked up from this book. Please don't be deterred by the use of the word "fundamentals" in the title: this is not just a book about the "select" statement - far from it!
Inside you'll find the essentials, like select, insert, update, delete, join and so on, but you'll also find coverage of aggregate functions, subqueries, XML functionality, and a lot of hugely useful information on the new code in SQL 2008. If you're an end user, this book isn't really aimed at you, but if you need to write Transact-SQL and want to leverage the new features of SQL 2008, this should be on your shelf.
Highly recommended!
Peter Lee (MCT, MCITP)
Inside you'll find the essentials, like select, insert, update, delete, join and so on, but you'll also find coverage of aggregate functions, subqueries, XML functionality, and a lot of hugely useful information on the new code in SQL 2008. If you're an end user, this book isn't really aimed at you, but if you need to write Transact-SQL and want to leverage the new features of SQL 2008, this should be on your shelf.
Highly recommended!
Peter Lee (MCT, MCITP)
10 of 10 people found the following review helpful
Format:Paperback
I purchased T-SQL Fundamentals after reading Peter Lee's review and I was not misled; it is an excellent book. But I believe some additional information may be helpful.
If your interest is data extraction and manipulation then, whatever your existing knowledge, I do not see how you can go wrong with this book. It starts at a very basic level but by the end you will be tackling extremely difficult exercises with confidence. If you are a developer, this book will be a useful addition to your library but it only covers enough on create database, table etc. to enable you to understand data extraction and manipulation. It mentions filegroups and partitions, for example, but not the T-SQL to create and manage them.
I have only one significant criticism: Appendix A should be Chapter 1. Appendix A tells those who have no access to Sequel Server at work how to install it on their home computer so they can try out the exercises. I did not notice Appendix A until after I had messed up my first installation.
A lesser criticism is that the book recommends installing Sequel Server Enterprise Edition on a 120 day free trial. What do you do at the end of the free trial? Enterprise Edition is the fullest and most expensive edition. Developer Edition is a lot cheaper, is also available on free trial and the only minus is its functionality is limited by license to a development environment. However, I chose Express Edition which is free forever. OK, it is limited but it is more than adequate for a training environment. Once you have built up your knowledge, you can upgrade to the appropriate fuller edition.
Tony Dallimore
If your interest is data extraction and manipulation then, whatever your existing knowledge, I do not see how you can go wrong with this book. It starts at a very basic level but by the end you will be tackling extremely difficult exercises with confidence. If you are a developer, this book will be a useful addition to your library but it only covers enough on create database, table etc. to enable you to understand data extraction and manipulation. It mentions filegroups and partitions, for example, but not the T-SQL to create and manage them.
I have only one significant criticism: Appendix A should be Chapter 1. Appendix A tells those who have no access to Sequel Server at work how to install it on their home computer so they can try out the exercises. I did not notice Appendix A until after I had messed up my first installation.
A lesser criticism is that the book recommends installing Sequel Server Enterprise Edition on a 120 day free trial. What do you do at the end of the free trial? Enterprise Edition is the fullest and most expensive edition. Developer Edition is a lot cheaper, is also available on free trial and the only minus is its functionality is limited by license to a development environment. However, I chose Express Edition which is free forever. OK, it is limited but it is more than adequate for a training environment. Once you have built up your knowledge, you can upgrade to the appropriate fuller edition.
Tony Dallimore
3 of 3 people found the following review helpful
Format:Paperback|Amazon Verified Purchase
This book is great! Easy to understand as it starts with very basic stuff but then it gets harder and harder. So even if you have some experience with sql, you'll still find this book helpful. The only draw back is that the author recommends you install a trial version for 120 days - when you can get a limited version of the server for free....
Would you like to see more reviews about this item?
Were these reviews helpful?
Let us know
Most Recent Customer Reviews
This is not for Beginers.
This is not a beginers book to learn T-SQL.
For Example:
If you're trying to teach a principle, and give examples, the basic requirement should surely be that the... Read more
For Example:
If you're trying to teach a principle, and give examples, the basic requirement should surely be that the... Read more
Published 3 months ago by Peterob1
T-SQL Fundamental - Well worth the purchase
Indepth concise, slightly more than an introduction to T-SQL, I found this to be great value for money. Read more
Published 7 months ago by Daniel
Excellent Intro to T-SQL
This book does exactly what it says on the tin. A really clear and well written introduction to T-SQL. Read more
Published 21 months ago by Dan
Basic - very
This is OK - but it is a very basic book. Large writing and not enough depth for my liking. Good for beginners but that's it. Read more
Published on 24 July 2009 by M. Sear
Listmania!
Look for similar items by category
- Books > Computing & Internet > Databases > Applications > Microsoft SQL Server
- Books > Computing & Internet > Databases > Applications > SQL > Microsoft SQL Server
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > Database Theory
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Programming > Microsoft Windows > SQL Server
- Books > Computing & Internet > Web Development > Web-server Software > Microsoft
Look for similar items by subject
Feedback
- Would you like to update product info or give feedback on images?
- I am the Author, and I want to comment on my book.
- I am the Publisher, and I want to comment on this book.
|
