Discovering Sql - A Hands-On Guide for Beginners

A guide to the standard database language provides information on ways to create, access, and manipulate data and introduces such concepts as data modeling, query tuning, and optimization.

List of contents

INTRODUCTION.

CHAPTER 1: DROWNING IN DATA, DYING OF THIRST FOR KNOWLEDGE.

CHAPTER 2: BREAKING AND ENTERING: STRUCTURED INFORMATION.

CHAPTER 3: A THING YOU CAN RELATE TO -- DESIGNING A RELATIONAL DATABASE.

CHAPTER 4: OVERCOMING THE LIMITATIONS OF SQL.

CHAPTER 5: GROUPING AND AGGREGATION.

CHAPTER 6: WHEN ONE IS NOT ENOUGH: A QUERY WITHIN A QUERY.

CHAPTER 7: YOU BROKE IT; YOU FIX IT: COMBINING DATA SETS.

CHAPTER 8: WHAT ELSE IS THERE, AND WHY?

CHAPTER 9: OPTIMIZING PERFORMANCE.

CHAPTER 10: MULTIUSER ENVIRONMENT.

CHAPTER 11: WORKING WITH UNSTRUCTURED AND SEMISTRUCTURED DATA.

CHAPTER 12: NOT BY SQL ALONE.

APPENDIX A: INSTALLING RDBMSS RDBMS SOFTWARE.

APPENDIX B: ACCESSING RDBMSS.

APPENDIX C: ACCESSING RDBMSS WITH THE SQUIRREL UNIVERSAL SQL CLIENT.

APPENDIX D: INSTALLING THE LIBRARY DATABASE.

INDEX.

Product details

• Authors: Alex Kriegel
• Publisher: Wiley, John and Sons Ltd
• Languages: English
• Product format: Paperback / Softback
• Released: 15.04.2011
• EAN: 9781118002674
• ISBN: 978-1-118-00267-4
• No. of pages: 432
• Series: Wrox Programmer to Programmer
• Subject: Natural sciences, medicine, IT, technology > IT, data processing > IT