2008 - Teach Yourself SQL in 24 Hours 4e (Sams).pdf - Web Design - Razlo

Ryan Stephens

Ron Plew

Arie D. Jones

Sams Teach Yourself

SQL ®

Hours

FOURTH EDITION

800 East 96th Street, Indianapolis, Indiana, 46240 USA

Sams Teach Yourself SQL® in 24 Hours, Fourth Edition

transmitted by any means, electronic, mechanical, photocopying, recording, or otherwise, without

written permission from the publisher. No patent liability is assumed with respect to the use of

the information contained herein. Although every precaution has been taken in the preparation of

this book, the publisher and author assume no responsibility for errors or omissions. Nor is any

liability assumed for damages resulting from the use of the information contained herein.

ISBN-13: 978-0-672-33018-6

ISBN-10: 0-672-33018-0

Library of Congress Cataloging-in-Publication Data

Associate

Publisher

Mark Taub

Acquisitions Editor

Trina MacDonald

Development

Editor

Michael Thurston

Managing Editor

Patrick Kanouse

Project Editor

Mandie Frank

Copy Editor

Heather Wilkins

Editorial Services

Indexer

Heather McNeil

Proofreader

Matt Purcell

Technical Editor

Steve Cvar

Publishing

Coordinator

Olivia Basegio

Designer

Gary Adair

Composition

Bronkella Publishing

Stephens, Ryan K.

Sams teach yourself SQL in 24 hours / Ryan Stephens, Ron Plew, Arie D.

Jones. -- 4th ed.

p. cm. -- (Sams teach yourself in 24 hours)

On t.p. of earlier ed. Ronald R. Plew's name appeared first.

Includes indexes

ISBN 978-0-672-33018-6 (pbk.)

1. SQL (Computer program language) I. Plew, Ronald R. II. Jones,

Arie. III. Plew, Ronald R. Sams teach yourself SQL in 24 hours. IV.

Title.

QA76.73.S67P554 2008

005.75'6--dc22

2008016630

Printed in the United States of America

First Printing May 2008

Trademarks

All terms mentioned in this book that are known to be trademarks or service marks have been

appropriately capitalized. Sams Publishing cannot attest to the accuracy of this information. Use

of a term in this book should not be regarded as affecting the validity of any trademark or service

mark.

Warning and Disclaimer

Every effort has been made to make this book as complete and as accurate as possible, but no

warranty or fitness is implied. The information provided is on an “as is” basis. The authors and

the publisher shall have neither liability nor responsibility to any person or entity with respect to

any loss or damages arising from the information contained in this book.

Bulk Sales

Sams Publishing offers excellent discounts on this book when ordered in quantity for bulk pur-

chases or special sales. For more information, please contact

U.S. Corporate and Government Sales

1-800-382-3419

corpsales@pearsontechgroup.com

For sales outside of the U.S., please contact

International Sales

international@pearson.com

Contents at a Glance

Introduction ................................................................................ 1

Part I: A SQL Concepts Overview

HOUR 1 Welcome to the World of SQL ........................................................ 7

Part II: Building Your Database

HOUR 2 Defining Data Structures ............................................................. 27

3 Managing Database Objects ........................................................ 41

4 The Normalization Process .......................................................... 61

5 Manipulating Data .................................................................... 73

6 Managing Database Transactions ................................................. 87

Part III: Getting Effective Results from Queries

HOUR 7 Introduction to the Database Query ............................................ 101

8 Using Operators to Categorize Data ............................................. 117

9 Summarizing Data Results from a Query ..................................... 141

10 Sorting and Grouping Data ........................................................ 151

11 Restructuring the Appearance of Data ......................................... 165

12 Understanding Dates and Times ................................................. 185

Part IV: Building Sophisticated Database Queries

HOUR 13 Joining Tables in Queries ........................................................... 203

14 Using Subqueries to Define Unknown Data ................................... 221

15 Combining Multiple Queries into One ......................................... 235

Part V: SQL Performance Tuning

HOUR 16 Using Indexes to Improve Performance ........................................ 253

17 Improving Database Performance ............................................... 265

Part VI: Using SQL to Manage Users and Security

HOUR 18 Managing Database Users ......................................................... 283

19 Managing Database Security ...................................................... 297

Part VII: Summarized Data Structures

HOUR 20 Creating and Using Views and Synonyms ..................................... 313

21 Working with the System Catalog ............................................... 329

Part VIII: Applying SQL Fundamentals in Today’s World

HOUR 22 Advanced SQL Topics ................................................................ 343

23 Extending SQL to the Enterprise, the Internet, and the Intranet ........ 359

24 Extensions to Standard SQL ........................................................ 369

Part IX: Appendixes

A Common SQL Commands ......................................................... 381

B Using MySQL for Exercises ......................................................... 387

C Answers to Quizzes and Exercises ................................................ 391

D CREATE TABLE Statements for Book Examples ................................ 435

E INSERT Statements for Data in Book Examples .............................. 437

F Bonus Exercises ........................................................................ 441

Glossary .................................................................................. 447

Index ..................................................................................... 451

Table of Contents

Introduction 1

What This Book Intends to Accomplish .................................................... 1

What We Added to This Edition .............................................................. 1

What You Need .................................................................................... 2

Conventions Used in This Book ................................................................ 2

ANSI SQL and Vendor Implementations .................................................... 3

Understanding the Examples and Exercises ................................................ 3

Part I: A SQL Concepts Overview

HOUR 1: Welcome to the World of SQL 7

SQL Definition and History .................................................................... 7

SQL Sessions ...................................................................................... 14

Types of SQL Commands ...................................................................... 15

The Database Used in This Book ............................................................ 17

Summary .......................................................................................... 22

Q&A .................................................................................................. 23

Workshop .......................................................................................... 24

Part II: Building Your Database

HOUR 2: Defining Data Structures 27

What Is Data? .................................................................................... 27

Basic Data Types ................................................................................ 28

Summary .......................................................................................... 36

Q&A .................................................................................................. 37

Workshop .......................................................................................... 37

2008 - Teach Yourself SQL in 24 Hours 4e (Sams).pdf

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: