Always Learning

Database Systems Using Oracle: A Simplified Guide to SQL and PL/SQL
Nilesh D. Shah, DeVry College of Technology and Monroe College

ISBN-10: 0130909335
ISBN-13:  9780130909336

Publisher:  Prentice Hall
Copyright:  2002
Format:  Paper; 326 pp
Published:  07/10/2001
We're sorry, this product is no longer available and has been replaced with Database Systems Using Oracle, 2/E.

Please contact your Pearson rep if you are using this product and need instructor resources.


Print this content

In this section:


Description

For Database Systems courses focusing on SQL and/or Oracle, Oracle courses, and SQL courses offered in departments of Computer Science, CIS, MIS, IT and Continuing Education.

Database Systems Using Oracle first introduces students to relational database concepts and database designing techniques, teaching them how to design and implement accurate and effective database systems. With its subsequent in-depth coverage of SQL (the universal query language for relational databases) and PL/SQL (Oracle's procedural language extension to SQL), this text serves not only as an introductory guide but also as a future reference. The author concludes with an introduction to the architecture and administration of Oracle 8, the new features of Oracle 8i, and the concepts of object orientation.


Features

  • Hands-on exercises and lab activities in each chapter.

    • Provides ample opportunity for students to practice the concepts they've learned in each chapter. Ex.___

  • Two sample databases used throughout the book as examples and in the lab activities—One database is a typical college student's database with demographic, schedule and registration information; the other is a corporation's employee database with employees' demographic and job-related data.

    • Illustrates how concepts are applied to address real-world needs. Ex.___

  • Common student errors highlighted with screen shots or queries and error messages.

    • Helps students avoid these mistakes. Ex.___

  • Simple examples and illustrations throughout the text.

    • Supplements the general syntax of SQL and PL/SQL. Ex.___

  • Versatility: the SQL and PL/SQL features covered in the book work with all versions of Oracle—Any necessary exceptions are pointed out within the context of specific topics.

    • Students can use the text with different versions of Oracle and with different environments (such as Windows NT, Unix, Linux, Solaris, or Novell Netware). Ex.___

  • SQL Review section.

    • Uses a third database—an Invoice-Item database—to summarize all the SQL statements covered in chapters 3 through 7 and to provide supplementary examples. Ex.___


Table of Contents

Most chapters end with In a Nutshell, Exercise Questions, and a Lab Activity.

I. DATABASE CONCEPTS.

1. Database Concepts: A Relational Approach.

Database: An Introduction. Relationships. Database Management System (DBMS). The Relational Database Model. Integrity Rules. Theoretical Relational Languages.

2. Database Design: Data Modeling and Normalization.

Data Modeling. Dependency. Database Design. Normal Forms. Dependency Diagrams. Denormalization.

II. THE ORACLE SQL.

3. Oracle 8: An Overview.

Personal Databases. Client/Server Databases. Oracle 8: An Introduction. The SQL*Plus Environment. Structured Query Language. Logging In to SQL*Plus. SQL*Plus Commands. Sample Databases. Alternate Text Editors. Oracle Online Help.

4. Oracle Tables: Creation and Modification.

Naming Conventions. Data Types. Constraints. Creating an Oracle Table. Displaying Table Information. Altering an Existing Table. Dropping a Table. Renaming a Table. Truncating a Table. Spooling.

5. Working with Tables: Data Management and Retrieval.

Adding a New Row/Record. Customized Prompts. Updating Existing Rows/Records. Deleting Existing Rows/Records. Dropping a Constraint. Disabling/Enabling Constraints. Retrieving Data from a Table. Arithmetic Operations. Restricting Data with a WHERE Clause. Sorting. Built-in Functions. Grouping Data. Nesting Group Functions. Revisiting Substitution Variables. DEFINE Command.

6. Multiple Tables: Joins and Sub-Queries.

Join. Set Operators. Sub-Query. Top-N Analysis.

7. Advanced Features: Objects, Transactions, and Control.

Views. Sequences. Synonyms. Index. Transactions. Locking Rows for Update. Controlling Access. SQL Review: Supplementary Examples.

III. PL/SQL.

8. PL/SQL: Programming Language Basics.

A Brief History of PL/SQL. Fundamentals of PL/SQL. PL/SQL Block Structure. Comments. Data Types. Other Scalar Data Types. Variable Declaration. Anchored Declaration. Assignment Operation. Bind Variables. Substitution Variables in PL/SQL. Printing in PL/SQL. Arithmetic Operators.

9. SQL and Control Structures in PL/SQL.

Control Structures. Nested Blocks. SQL in PL/SQL. Data Manipulation in PL/SQL. Transaction Control Statements.

10. Cursors and Exceptions.

Cursors. Implicit Cursors. Explicit Cursors. Explicit Cursor Attributes. Implicit Cursor Attributes. Cursor FOR Loops. SELECT . . . FOR UPDATE Cursor. WHERE CURRENT OF Clause. Cursor with Parameters. Cursor Variables: An Introduction. Exceptions. Types of Exceptions. Sample Programs.

11. Composite Data Types: Records and Tables.

Composite Data Types. PL/SQL Records. PL/SQL Tables. Sample Programs.

12. Procedures, Functions and Packages.

Procedures. Functions. Packages.

IV. MISCELLANEOUS TOPICS.

13. Oracle Database Administration.

Database Administrator (DBA). Oracle Architecture: An Overview. Installation. Networking. Security. System Privileges. Roles. Users. Oracle Tools. SQL*Plus. Oracle Data Dictionary.

14. Oracle 8i: An Overview and Web Tools.

Oracle8i Core Package. An Object. SQL Queries for Objects. Internet Computing and Oracle8i. WebDB. JDeveloper.

Appendix A: Sample Databases: Table Definitions.

The Indo-US College Student Database. The NamanNavan Corporation College Database.

Appendix B: Quick Reference to SQL & PL/SQL Syntax.

Appendix C: Additional References.

Web Sites. Books and Other Published Material on Oracle.

Index.



Back to top

Print this content

In this section:


Author Bios

Nilesh Shah, Ph.D., has been teaching for more than a decade. He is currently an Assistant Professor at the New Jersey campus of DeVry. He also works as a systems analyst at Monroe College, New York. Dr. Shah is associated with many prestigious technology companies as a freelance consultant.


Backcover Copy

Oracle is the premier database package used in industry and it is the preferred choice of many academic institutions to teach relational database applications. Database Systems Using Oracle provides the most comprehensive coverage of the Structured Query Language (SQL) and the Programming Language/ Structured Query Language (PUSQL) in Oracle version 8 or higher.

Mastery of Oracle SQL and PUSQL languages is greatly facilitated by the provision of clear, step-by-step instructions, supplemented by hands-on examples, exercise questions, and lab activities. Throughout the text the author uses two real-life running databases as a model as well as a dedicated section on SQL statements with an additional third database scenario. Exposure to these databases increases comprehension of real-life database issues.

Features:
  • Comprehensive coverage of the relational concepts and the database designing techniques necessary to design and implement effective database systems.
  • Thorough coverage of SQL.
  • Complete coverage of PL/SQL.
  • An introduction to the architecture and administration of Oracle 8, Oracle 8I, and the concept of object orientation.
  • Each chapter contains many exercise questions and lab activities promoting the "learn-by-doing" approach.
  • A companion website offers instant student assessment materials and PowerPoint slides for each chapter.

Back to top

Print this content

In this section:


Websites and Online Courses

Companion Website - Shah
Shah
©2002  |  Prentice Hall  |  On-line Supplement  |  Live
ISBN-10: 0130937843  |  ISBN-13: 9780130937841
More Info

Back to top

Print this content

In this section:

Companion Website - Shah
Shah
©2002  |  Prentice Hall  |  On-line Supplement  |  Live
ISBN-10: 0130937843  |  ISBN-13: 9780130937841
More Info

Back to top


Websites and online courses

Companion Website - Shah
Shah
©2002  |  Prentice Hall  |  On-line Supplement  |  Live
ISBN-10: 0130937843  |  ISBN-13: 9780130937841
More Info


Websites and Online Courses

Companion Website - Shah
Shah
©2002  |  Prentice Hall  |  On-line Supplement  |  Live
ISBN-10: 0130937843  |  ISBN-13: 9780130937841
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 contact your Pearson Higher Education representative.

Back to top