Higher Ed. and Vocational >> Engineering and Computer Science >> Computer Science >> Computer Science


Effective SQL: 61 Specific Ways to Write Better SQL

Effective SQL:   61 Specific Ways to Write Better SQL

Author(s):
  • John L. Viescas
  • Douglas J Steele
  • Ben G Clothier
  • Author: John L. Viescas
    • ISBN:9789352865086
    • 10 Digit ISBN:9352865081
    • Price:Rs. 529.00
    • Pages:352
    • Imprint:Pearson Education
    • Binding:Paperback
    • Status:Available


    Be the first to rate the book !!

    Effective SQL brings together the hands-on solutions and practical insights students need to solve a wide range of complex problems with SQL, and to design databases that make it far easier to manage data in the future. Leveraging the proven format of the best-selling Effective series, it focuses on providing clear, practical explanations, expert tips, and plenty of realistic examples.

     

    Table of Content

    "Foreword xiii
    Acknowledgments xv
    About the Authors xvii
    About the Technical Editors xix
    Introduction
    Chapter 1: Data Model Design
    Chapter 2: Programmability and Index Design
    Chapter 3: When You Can't Change the Design
    Chapter 4: Filtering and Finding Data
    Chapter 5: Aggregation
    Chapter 6: Subqueries
    Chapter 7: Getting and Analyzing Metadata
    Chapter 8: Cartesian Products
    Chapter 9: Tally Tables
    Chapter 10: Modeling Hierarchical Data
    Appendix: Date and Time Types, Operations, and Functions

    Salient Features

    61 practical, easy-to-use solutions -- all in full-color, with simple explanations and no jargon!
    Designed for all leading SQL implementations, with additional techniques for widely used versions. (Tested on IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Oracle Database, and PostgreSQL.)
    Identifies common misconceptions and pitfalls when authoring solutions using SQL and provides effective solutions to common scenarios"