Product Cover Image

Oracle SQL By Example, CourseSmart eTextbook, 4th Edition

By Alice Rischert

Published by Prentice Hall

Published Date: Aug 12, 2009

More Product Info


No other SQL book offers the volume of examples and exercises that the author provides in this book. Further, the author offers a Web site that allows readers to download end-of-chapter solutions and sample data. The book’s approach lends itself to both self-study and in-classroom use. The lab-style exercises are accompanied by detailed explanation.

Table of Contents

Foreword     xxxi

Preface     xxxiv

Chapter 1: SQL and Data     1

Chapter 2: SQL: The Basics     49

Chapter 3: The WHERE and ORDER BY Clauses     101

Chapter 4: Character, Number, and Miscellaneous Functions     133

Chapter 5: Date and Conversion Functions     189

Chapter 6: Aggregate Functions, GROUP BY, and HAVING Clauses     263

Chapter 7: Equijoins     285

Chapter 8: Subqueries     323

Chapter 9: Set Operators     377

Chapter 10: Complex Joins     399

Chapter 11: Insert, Update, and Delete     429

Chapter 12: Create, Alter, and Drop Tables     503

Chapter 13: Indexes, Sequences, and Views     571

Chapter 14: The Data Dictionary, Scripting, and Reporting     615

Chapter 15: Security     661

Chapter 16: Regular Expressions and Hierarchical Queries     695

Chapter 17: Exploring Data Warehousing Features     741

Chapter 18: SQL Optimization     803

Appendix A: Answers to Quiz Questions     839

Appendix B: SQL Formatting Guide     855

Appendix C: SQL*Plus Command Reference     859

Appendix D: STUDENT Database Schema     873

Appendix E: Table and Column Descriptions     875

Appendix F: Additional Example Tables     881

Appendix G: Navigating the Oracle Documentation     887

Appendix H: Resources     893

Appendix I: Oracle Data Types     897

Index     899


Purchase Info ?

With CourseSmart eTextbooks and eResources, you save up to 60% off the price of new print textbooks, and can switch between studying online or offline to suit your needs.

Once you have purchased your eTextbooks and added them to your CourseSmart bookshelf, you can access them anytime, anywhere.

Buy Access

Oracle SQL By Example, CourseSmart eTextbook, 4th Edition
Format: Safari Book

$34.99 | ISBN-13: 978-0-13-708324-4