Oracle SQL

Oracle SQL

2.5 (2 ratings by Goodreads)
By (author)  , By (author) 

List price: US$93.99

Currently unavailable

Add to wishlist

AbeBooks may have this title (opens in new window).

Try AbeBooks


For courses in Database Management.

Focusing on standard ANSI SQL with a learn-by-doing approach, this text organizes SQL subtopics into short chapters. Students first learn the features of a SQL command, then its usage, based on management questions that typically arise in the management decision-making process. The authors pose management questions and then give examples of how SQL can be used to provide the data needed. In light of the wide adoption of the Oracle relational DBMS product in academic institutions and industry, additional examples of the supplemental commands available in the Oracle implementation of SQL are provided. 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 standard-including DB2, SQL Server, and SYBASE.
show more

Product details

  • Paperback | 368 pages
  • 201.2 x 258.1 x 14.2mm | 644.11g
  • Pearson
  • Upper Saddle River, NJ, United States
  • English
  • 0131011383
  • 9780131011380

Table of contents

(NOTE: Each chapter begins with Objectives and concludes with Summary, Review Exercises, Learn These Terms, Concepts Quiz, and SQL Coding Exercises and Questions.)

1. Introduction.

2. Creating Tables and Indexes.

3. Single Table Query Basics.

4. Adding Power to Queries.

5. Aggregate Row Functions.

6. Joins.

7. Subqueries.

8. Views, Synonyms, and Sequences.

9. SQL *Plus Reports.

10. Additional Functions.

11. Embedded SQL.

12. Oracle Database Administration.

Appendix A: The Company Database Schema.

Appendix B: The Riverbend Hospital Case.

Appendix C: End-of-Book SQL Coding Exercises.

Appendix D: Solutions to Odd-Numbered Exercises.
show more

Rating details

2 ratings
2.5 out of 5 stars
5 0% (0)
4 0% (0)
3 50% (1)
2 50% (1)
1 0% (0)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X