Oracle SQL / Edition 1
by Bijoy Bordoloi, David Brian Kroenke, Douglas B. Bock, David Brian KroenkeFocusing on standard ANSI SQL with a learn-by-doing approach, this book organizes SQL subtopics into short chapters. Readers first learn the features of a SQL command, then its usage, based on management questions that typically arise in the management decision-making process. Provides additional examples of the supplemental commands provided in the Oracle… See more details below
Overview
Focusing on standard ANSI SQL with a learn-by-doing approach, this book organizes SQL subtopics into short chapters. Readers first learn the features of a SQL command, then its usage, based on management questions that typically arise in the management decision-making process. Provides additional examples of the supplemental commands provided in the Oracle implementation of SQL. Ensures that all of the SQL concepts and commands covered (except in SQL *Plus and PL/SQL) are equally applicable to database management system software that follows the ANSI SQL standardincluding DB2, SQL Server, and SYBASE. Integrates numerous exercises and examples throughout. Offers detailed coverage of SQL, including SQL *Plus and Oracle Database Administration. Covers Data Definition Language with SQL. A valuable reference for SQL programmers, systems analysts, database programmers, and database administrators.
Product Details
- ISBN-13:
- 9780131011380
- Publisher:
- Prentice Hall
- Publication date:
- 02/10/2003
- Edition description:
- New Edition
- Pages:
- 368
- Product dimensions:
- 7.90(w) x 9.90(h) x 0.60(d)
Table of Contents
Preface | ||
Ch. 1 | Introduction | 1 |
Ch. 2 | Creating Tables and Indexes | 20 |
Ch. 3 | Single Table Query Basics | 46 |
Ch. 4 | Adding Power to Queries | 66 |
Ch. 5 | Aggregate Row Functions | 90 |
Ch. 6 | Joins | 109 |
Ch. 7 | Subqueries | 130 |
Ch. 8 | Views, Synonyms, and Sequences | 153 |
Ch. 9 | SQL*Plus Reports | 176 |
Ch. 10 | Additional Functions | 206 |
Ch. 11 | Embedded SQL | 228 |
Ch. 12 | Oracle Database Administration | 242 |
App. A | The Company Database Schema | 263 |
App. B | The Riverbend Hospital Case | 278 |
App. C | End-of-Book SQL Coding Exercises | 289 |
App. D | Solutions to Odd-Numbered Exercises | 311 |
Index | 345 |
Customer Reviews
Average Review: