Always Learning

Oracle SQL
Bijoy Bordoloi, Southern Illinois University, Edwardsville
Douglas B. Bock, Southern Illinois University, Edwardsville

ISBN-10: 0131011383
ISBN-13:  9780131011380

Publisher:  Prentice Hall
Copyright:  2004
Format:  Paper; 368 pp
Published:  02/10/2003
Status: Out of Stock


We're sorry, this product is no longer available.
Please contact your Pearson rep if you are using this product and need instructor resources.


Print this content

In this section:


Description

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.


Features

  • NEW - Small-chapter organization.

    • Enables professors to move easily through the material without overwhelming students.

  • NEW - Numerous exercises and examples integrated throughout—Includes end-of-chapter coding exercises; corresponding end-of-book exercises, with 12-18 exercises for each chapter; and approximately 20-30 coding examples per chapter.

    • Gives instructors additional opportunities to reinforce concepts presented in a comprehensive manner and also facilitates exam preparation; gives students many different examples to use in learning the material.

  • NEW - Solutions to half of the end-of-chapter and end-of-book exercises—Gives professors access to remaining solutions on the book's Web site.

    • Helps students assess their understanding of the material.

  • NEW - Detailed coverage of SQL, including SQL *Plus and Oracle Database Administration.

    • Gives students a comprehensive understanding of the material.

  • NEW - Coverage of Data Definition Language with SQL.

    • Gives students and professors coverage for table creation not usually found in other books on the subject.


New To This Edition

  • Small-chapter organization.

    • Enables professors to move easily through the material without overwhelming students.

  • Numerous exercises and examples integrated throughout—Includes end-of-chapter coding exercises; corresponding end-of-book exercises, with 12-18 exercises for each chapter; and approximately 20-30 coding examples per chapter.

    • Gives instructors additional opportunities to reinforce concepts presented in a comprehensive manner and also facilitates exam preparation; gives students many different examples to use in learning the material.

  • Solutions to half of the end-of-chapter and end-of-book exercises—Gives professors access to remaining solutions on the book's Web site.

    • Helps students assess their understanding of the material.

  • Detailed coverage of SQL, including SQL *Plus and Oracle Database Administration.

    • Gives students a comprehensive understanding of the material.

  • Coverage of Data Definition Language with SQL.

    • Gives students and professors coverage for table creation not usually found in other books on the subject.


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.



Back to top

Print this content

In this section:


Websites and Online Courses

Companion Website - Bordoloi
Bordoloi
©2004  |  Prentice Hall  |  On-line Supplement; 0 pp  |  Live
ISBN-10: 0131405616  |  ISBN-13: 9780131405615

Show Downloadable Files
 | More Info

Back to top

Print this content

In this section:

Companion Website - Bordoloi
Bordoloi
©2004  |  Prentice Hall  |  On-line Supplement; 0 pp  |  Live
ISBN-10: 0131405616  |  ISBN-13: 9780131405615

Show Downloadable Files
 | More Info

Back to top


Websites and online courses

Companion Website - Bordoloi
Bordoloi
©2004  |  Prentice Hall  |  On-line Supplement; 0 pp  |  Live
ISBN-10: 0131405616  |  ISBN-13: 9780131405615

Show Downloadable Files
 | More Info


Websites and Online Courses

Companion Website - Bordoloi
Bordoloi
©2004  |  Prentice Hall  |  On-line Supplement; 0 pp  |  Live
ISBN-10: 0131405616  |  ISBN-13: 9780131405615

Show Downloadable Files
 | More Info

Log in to the Instructor Resource Center

Login name: 

  Password: 

Forgot login/password?  |  Need to redeem an access code?

        

Instructor Resource Center File Download

This work is protected by local and international copyright laws and is provided solely for the use of instructors in teaching their courses and assessing student learning. Dissemination or sale of any part of this work (including on the World Wide Web) will destroy the integrity of the work and is not permitted. The work and materials from this site should never be made available to students except by instructors using the accompanying text in their classes. All recipients of this work are expected to abide by these restrictions and to honor the intended pedagogical purposes and the needs of other instructors who rely on these materials.

Cancel     I accept, proceed with download

Print this content

Pearson Higher Education offers special pricing when you choose to package your text with other student resources. If you're interested in creating a cost-saving package for your students, browse our available packages below, or contact your Pearson Higher Education representative to create your own package.

Package ISBN-10: 0132410818 | ISBN-13: 9780132410816
©2010 | Not Yet Published
Suggested retail price: $149.33  

This package contains:

Bordoloi & Bock | ©2004 | Prentice Hall | Paper; 368 pp
Kroenke & Auer | ©2010 | Prentice Hall | Cloth; 672 pp


Back to top