Microsoft SQL Server 2008 T-SQL Fundamentals [NOOK Book]

Overview

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 ...

See more details below
Microsoft SQL Server 2008 T-SQL Fundamentals

Available on NOOK devices and apps  
  • NOOK Devices
  • NOOK HD/HD+ Tablet
  • NOOK
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac
  • NOOK Study
  • NOOK for Web

Want a NOOK? Explore Now

NOOK Book (eBook)
$22.99
BN.com price
(Save 42%)$39.99 List Price

Overview

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

Read More Show Less

Product Details

  • ISBN-13: 9780735638129
  • Publisher: Pearson Education
  • Publication date: 11/5/2008
  • Series: Developer Reference
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 418
  • Sales rank: 347,237
  • File size: 3 MB

Meet 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.

Read More Show Less

Table of Contents


1 Background to T-SQL Querying and Programming 1
2 Single-Table Queries 25
3 Joins 101
4 Subqueries 133
5 Table Expressions 161
6 Set Operations 193
7 Pivot, Unpivot, and Grouping Sets 213
8 Data Modification 237
9 Transactions and Concurrency 279
10 Programmable Objects 319 App. A Getting Started 359 Index 379
Read More Show Less

Customer Reviews

Average Rating 4.5
( 8 )
Rating Distribution

5 Star

(5)

4 Star

(3)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 8 Customer Reviews
  • Anonymous

    Posted July 1, 2012

    great for all levels

    this is great for introductory and for those wanting to dive further into querying. Doesn't get into building database, which is nice as that is not what I need. Perfect addition to library.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted January 12, 2012

    Highly recommend!

    Great book. Helpful to brush up and realize what you had forgotten about T-SQL. Highly recommend this book for beginners as well as a reference for those who just need something handy to refer to.

    Was this review helpful? Yes  No   Report this review
  • Posted March 30, 2009

    Great book

    This book is an excellent introduction to T-SQL. If you've been working with SQL Server and want to brush up on your T-SQL chops, this is the book for you. I've re-read it twice now and pick up additional nuances each time.

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted February 7, 2011

    No text was provided for this review.

  • Anonymous

    Posted May 18, 2010

    No text was provided for this review.

  • Anonymous

    Posted May 18, 2011

    No text was provided for this review.

  • Anonymous

    Posted June 8, 2010

    No text was provided for this review.

  • Anonymous

    Posted February 14, 2010

    No text was provided for this review.

Sort by: Showing all of 8 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)