Microsoft® SQL Server® 2008 T-SQL Fundamentals
Publisher: Microsoft Press
Released: October 2008
Pages: 418
Description
Product Details
About the Author
Recommended for You
Recently Viewed
Microsoft® Office SharePoint® Server 2007 Best Practices
By Ben Curry, Bill English
July 2008
Ebook: $47.99
Print & Ebook: $65.99
Print: $59.99
Windows® Internals, 5th Edition
By Mark E. Russinovich, David A. Solomon, Alex Ionescu
June 2009
Ebook: $55.99
Introducing Microsoft® Silverlight™ 2, Second Edition, 9780735625396
By Laurence Moroney
June 2008
Ebook: $27.99
Customer Reviews

REVIEW SNAPSHOT®

by PowerReviews
oreilly Microsoft® SQL Server® 2008 T-SQL Fundamentals
 
4.3

(based on 3 reviews)

Ratings Distribution

  • 5 Stars

     

    (1)

  • 4 Stars

     

    (2)

  • 3 Stars

     

    (0)

  • 2 Stars

     

    (0)

  • 1 Stars

     

    (0)

100%

of respondents would recommend this to a friend.

Pros

  • Accurate (3)
  • Concise (3)
  • Easy to understand (3)
  • Helpful examples (3)

Cons

    Best Uses

    • Intermediate (3)
    • Novice (3)
    • Student (3)
      • Reviewer Profile:
      • Developer (3)

    Reviewed by 3 customers

    Sort by

    Displaying reviews 1-3

    Back to top

     
    4.0

    Good book teaches the basics

    By fooschamp

    from San Diego, ca

    About Me Designer, Developer

    Verified Reviewer

    Pros

    • Accurate
    • Concise
    • Easy to understand
    • Helpful examples
    • Well-written

    Cons

      Best Uses

      • Intermediate
      • Novice
      • Student

      Comments about oreilly Microsoft® SQL Server® 2008 T-SQL Fundamentals:

      I thought it was very well written and especially liked chapter 3 that covers joins, and chapter 7 that covers PIVOT. If you become a DBA chances are you will use most of the basics that are taught here on a day to day basis.

       
      5.0

      Great T-SQL Book for Beginners

      By gfmann or Gay Farace-Mann

      from San Diego

      About Me Developer

      Verified Reviewer

      Pros

      • Accurate
      • Concise
      • Easy to understand
      • Helpful examples

      Cons

      • None

      Best Uses

      • Great Reveiw book
      • Intermediate
      • Novice
      • Student

      Comments about oreilly Microsoft® SQL Server® 2008 T-SQL Fundamentals:

      I used this book to brush on my old T-SQL skills.
      Clean and concise explainations.
      Great examples and hands on problems with answers to do.

      What wasn't great... I didn't get meet the author in person. Would love to meet him!

       
      4.0

      A good reference and and a good read

      By James

      from San Diego, CA

      About Me Developer

      Pros

      • Accurate
      • Concise
      • Easy to understand
      • Helpful examples
      • Well-written

      Cons

        Best Uses

        • Intermediate
        • Novice
        • Student

        Comments about oreilly Microsoft® SQL Server® 2008 T-SQL Fundamentals:

        This eBook was provide to me by the San Diego Tech Immersion Group.

        Overview
        T-SQL Fundamentals is an excellent book. The text is direct and easy to understand. Complex subjects are conveyed well. The organization is clear and logical. I highly recommend this book.

        Comments on Organization
        • This book is a "good read" straight through. Subjects are presented in a logical sequence.
        • It is also a good reference book. Specific information is easy to find and can be read out of context.
        • I like the mixture of theory and command references. I have another T-SQL book that basically just lists the commands and their options. But that presentation is very dry and does not invite the reader to greater understanding
        • The examples help illuminate the descriptive text. It is often easier to understand via an example.
        • I found the exercises beneficial in cementing my understanding.
        • I loved the practical tips and tricks provided. I employed two of those tricks straight away
        o Computing First and last day of a month
         I used this trick in an SSIS job to transfer data on a monthly basis without ever needing to specify date parameters
        o Cross-Join to normalize related data columns (e.g. phone1, phone2, phone3)
         We have several occurrences of such column groupings
         I was able to create several views to present the data in a normalized fashion as appropriate for some applications

        Content I Enjoyed
        • Background to T-SQL Querying and Programming
        o This introductory section provides a great background
        o I particularly enjoyed the section about Set Theory.
        • Elements of the SELECT Statement in Single-Table Queries
        o This section helps explain why T-SQL behaves the way it does and why it has certain limitations.
        • Pivot & Unpivot
        o These commands still seem kind of clunky to me
        o But at least I understand them better
        • Set Operations
        o I usually only deal with basic operations like union
        o Good to know that there are several other operations available out of the box

        Content Lacking from My Perspective
        • I wished there had been more coverage of User-defined Functions and Stored Procedures
        o There are short sections on both in Chapter 10
        o But we use SPs and UDFs extensively in our environment
        o I would have appreciated more tips and tricks, usage examples, limitations & gotchas, workarounds, etc.
        • I would have liked to see more information about database tuning and monitoring
        o More about setting up indices and key relationships
        o More about monitoring tools
        o More about debugging tools available
        • More details about working with SQL Server Management Studio would have been helpful
        o I realize that not all database developers use SSMS
        o But, I know that it has many capabilities of which I am unaware.

        Displaying reviews 1-3

        Back to top

         
        Buy 2 Get 1 Free Free Shipping Guarantee
        Buying Options
        Save a Tree - Go Digital  what is this?
        Ebook: $39.99
        Formats: APK, DAISY, ePub, Mobi, PDF
        Print & Ebook: $54.99
        Print: $49.99