Wiley.Discovering.SQL.A.Hands-On.Guide.For.Beginners.2011.pdf

DISCOVERING SQL

INTRODUCTION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . xxv

CHAPTER 1

Drowning in Data, Dying of Thirst for Knowledge . . . . . . . . . . . . . . . . . . . . 1

CHAPTER 2

Breaking and Entering: Structured Information . . . . . . . . . . . . . . . . . . . . 29

CHAPTER 3

A Thing You Can Relate To — Designing a Relational Database . . . . . 79

CHAPTER 4

Overcoming the Limitations of SQL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 103

CHAPTER 5

Grouping and Aggregation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .137

CHAPTER 6

When One Is Not Enough: A Query Within a Query . . . . . . . . . . . . . . . 155

CHAPTER 7

You Broke It; You Fix It: Combining Data Sets . . . . . . . . . . . . . . . . . . . . 173

CHAPTER 8

What Else Is There, and Why? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 207

CHAPTER 9

Optimizing Performance . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 231

CHAPTER 10

Multiuser Environment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 251

CHAPTER 11

Working with Unstructured and Semistructured Data . . . . . . . . . . . . . 287

CHAPTER 12

Not by SQL Alone . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 329

APPENDIX A

Installing the Library Database . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 353

APPENDIX B

Installing RDBMSs Software . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 375

APPENDIX C

Accessing RDBMSs . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 377

APPENDIX D

Accessing RDBMSs with the SQuirreL Universal SQL Client . . . . . . . . 379

INDEX. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 381

Discovering SQL

Discovering SQL

A HANDS-ON GUIDE FOR BEGINNERS

Alex Kriegel

Discovering SQL

Published by

Wiley Publishing, Inc.

10475 Crosspoint Boulevard

Indianapolis, IN 46256

www.wiley.com

Published simultaneously in Canada

ISBN: 978-1-118-00267-4

ISBN: 978-1-118-09279-8 (ebk)

ISBN: 978-1-118-09277-4 (ebk)

ISBN: 978-1-118-09278-1 (ebk)

Manufactured in the United States of America

10 9 8 7 6 5 4 3 2 1

No part of this publication may be reproduced, stored in a retrieval system or transmitted in any form or by any means,

electronic, mechanical, photocopying, recording, scanning or otherwise, except as permitted under Sections 107 or 108

of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization

through payment of the appropriate per-copy fee to the Copyright Clearance Center, 222 Rosewood Drive, Danvers,

MA 01923, (978) 750-8400, fax (978) 646-8600. Requests to the Publisher for permission should be addressed to the

Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011, fax (201)

748-6008, or online at http://www.wiley.com/go/permissions .

Limit of Liability/Disclaimer of Warranty: The publisher and the author make no representations or warranties with

respect to the accuracy or completeness of the contents of this work and speciﬁ cally disclaim all warranties, including

without limitation warranties of ﬁ tness for a particular purpose. No warranty may be created or extended by sales or

promotional materials. The advice and strategies contained herein may not be suitable for every situation. This work is

sold with the understanding that the publisher is not engaged in rendering legal, accounting, or other professional

services. If professional assistance is required, the services of a competent professional person should be sought. Neither

the publisher nor the author shall be liable for damages arising herefrom. The fact that an organization or Web site is

referred to in this work as a citation and/or a potential source of further information does not mean that the author or the

publisher endorses the information the organization or Web site may provide or recommendations it may make. Further,

readers should be aware that Internet Web sites listed in this work may have changed or disappeared between when this

work was written and when it is read.

For general information on our other products and services please contact our Customer Care Department within the

United States at (877) 762-2974, outside the United States at (317) 572-3993 or fax (317) 572-4002.

Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not be available

in electronic books.

Library of Congress Control Number: 2011922790

Trademarks: Wiley, the Wiley logo, Wrox, the Wrox logo, Programmer to Programmer, and related trade dress are trademarks

or registered trademarks of John Wiley & Sons, Inc. and/or its afﬁ liates, in the United States and other countries, and may not

be used without written permission. All other trademarks are the property of their respective owners. Wiley Publishing, Inc., is

not associated with any product or vendor mentioned in this book.

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: