SQL Queries Joes 2 Pros: SQL Query Techniques For Microsoft SQL Server 2008
    Share
    Facebook
    Twitter
    Email
    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
    Features
    • Language: English
    • Binding: Paperback
    • Publisher: SQLAuthority
    • ISBN: 9781439253182, 1439253188
    • Edition: 2009
    • Pages: 542
    Services
    • 10 Days Replacement Policy
      ?
      ValidityCoversType Accepted
      10 days from deliveryDamaged, Defective, Item not as describedReplacement

      If you have received a damaged or defective product or if it is not as described, you can raise a replacement request on the Website/App/Mobile site within 10 days of receiving the product.

      Successful pick-up of the product is subject to the following conditions being met:

      • Correct and complete product (with the original brand/product Id/undetached MRP tag/product's original packaging/freebies and accessories).
      • The product should be in unused, undamaged and original condition without any scratches or dents.

      Know more about the Return Policy here

    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
    4
    2 Ratings
    1 Reviews
    • 5
       1
    • 4
       0
    • 3
       1
    • 2
       0
    • 1
       0
    Most Helpful 
    Positive 
    Most Recent 
    By Certified Buyers 
    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
    Safe and Secure Payments. Easy returns. 100% Authentic products.
    Back to top