SQL Queries Joes 2 Pros: SQL Query Techniques For Microsoft SQL Server 2008
    Share

    SQL Queries Joes 2 Pros: SQL Query Techniques For Microsoft SQL Server 2008 (English, Paperback, Jessica Brown, Irina Berger, Rick A. Morelan, Tom Ekberg)

    SQL Queries Joes 2 Pros: SQL Query Techniques For Microsoft SQL Server 2008  (English, Paperback, Jessica Brown, Irina Berger, Rick A. Morelan, Tom Ekberg)

    4
    2 Ratings & 1 Reviews
    719
    799
    10% off
    Sold Out
    This item is currently out of stock
    Highlights
    • Language: English
    • Binding: Paperback
    • Publisher: SQLAuthority
    • ISBN: 9781439253182, 1439253188
    • Edition: 2009
    • Pages: 542
    Services
    • 10 Days Replacement Policy
      ?
    Description
    Once you know the basics of the SQL language, it's time to take the next step toward specialization: query writing! All objects in SQL support the need to get data in and out of databases, and writing queries is the key to capturing the data you want. "SQL Queries Joes 2 Pros" shows you a proven roadmap that has helped many beginning SQL students get their certifications and launch their careers. If you want to get ready for MCTS certification, this is the second book of the Joes 2 Pros series. This book is totally focused on providing a fun, hands-on experience as it evolves your basic SQL skills and amps up your level of query writing expertise. This is Volume II of the Joes 2 Pros certification track designed to prepare you for the 70-433 SQL 2008 exam. If you are a total beginner, we recommend you first become familiar with the material in the "Beginning SQL Joes 2 Pros."

    Table Of Contents
    • Data, Information and Tables
    • Query Options
    • Null, Expression, and Identiry Fields
    • Aggregating Data
    • Aggregation Strategies
    • Top Records
    • Ranking Functions
    • Multiple Query Operators
    • Common Table Expressions (CTE)
    • Data Recursion
    • Using Subsequeries
    • Table Data Actions
    • The Merge Statement
    • The Output Clause
    • Common System Functions
    • Next Steps for Aspiring SQL Pros
    • Index
    Read More
    Specifications
    Book Details
    • Publication Year
      • 2009
    Contributors
    • Author
      • Rick A. Morelan
    Dimensions
    • Width
      • 7.00 inch
    • Height
      • 1.10 inch
    • Weight
      • 930 g
    Ratings and Reviews
    4
    2 Ratings &
    1 Reviews
    • 5
       1
    • 4
       0
    • 3
       1
    • 2
       0
    • 1
       0
    3

    Good Book for beginners

    lot of good points mentioned. Thanks for writing such an amazing book. Each chapter in this book has at least few points which is not known to me till date. It will really help guys who have started learning sql server 2k8 in detail.
    READ MORE

    vishal dobariya

    Certified Buyer

    26 Jul, 2012

    1
    0
    Report Abuse
    Have doubts regarding this product?
    Safe and Secure Payments. Easy returns. 100% Authentic products.
    Back to top