Database Systems Using Oracle

Series
Prentice Hall
Author
Nilesh Shah  
Publisher
Pearson
Cover
Softcover
Edition
2
Language
English
Total pages
456
Pub.-date
May 2004
ISBN13
9780131018570
ISBN
0131018574
Related Titles


Product detail

Product Price CHF Available  
9780131018570
Database Systems Using Oracle
164.40 approx. 7-9 days

Description

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

Updated to cover Oracle 9i, this text first introduces students to relational database concepts and database designing techniques, then teaches 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 valuable future reference. Part IV, Advanced Topics, allows students to further understand and utilize Oracle 9i architecture and administration.

Features

  • NEW - Updated material for Oracle 9 i-Introduces the new features of Oracle 9i.
    • Provides students with the latest material available for this powerful relational database.

  • NEW - More examples-Provided throughout the text; coding examples are replaced by more than 250 actual screen shots.
    • Illustrates for students the general syntax of SQL and PL/SQL, and helps them avoid mistakes.

  • NEW - Enhanced material-Provides new and enhanced information all existing topics, including Oracle's data dictionary; and updated ERD.
    • Enables students to utilize a text that is comprehensive and current.

  • NEW - New chapters-Includes Database Administration with Enterprise Manager and a new chapter on database connectivity with Java/C++ and SQLJ.
    • Provides students with a clearer explanation of relational database concepts.

  • NEW - New lesson on SQL*Plus-Includes exercises for SQL workshet and iSQL*Plus environments; these add to the already numerous hands-on exercises and lab activities for each chapter.
    • Provides students with ample opportunities to practice the concepts learned in class.

  • Two sample databases-Used throughout the book as examples and for lab activities; the first is a typical college student's database with demographic, schedule, and registration information; the second is a corporation's employee database with demographic and job-related data.
    • Enables students to understand how the text's concepts are applied to address real-world needs.

  • Versatility-Covers the SQL and PL/SQL features that work with any version of Oracle.
    • Allows students to use the text with different versions of Oracle and with different environments, making it an invaluable future reference work.

  • SQL Review section-Provides a review of SQL statements covered in chapters 3-9, and includes a sample database.
    • Provides students with ample opportunity to self-test. Enables instructors to check students' progress.

  • Comprehensive appendices.
    • Provides students and instructors with an easily accessible reference.

  • Complete supplement package-Includes a Test Bank; Solutions to Chapter Questions and Labs; PowerPoint slides; and scripts for sample databases.
    • Gives instructors an easy environment to create tests and quizzes, assign homework, and prepare lectures.

  • Companion software-Makes Oracle 9i available at a reasonable price.
    • Enables students to use the software to enhance the examples provided in the text.

New to this Edition

  • Updated material for Oracle 9 i-Introduces the new features of Oracle 9i.
    • Provides students with the latest material available for this powerful relational database.

  • More examples-Provided throughout the text; coding examples are replaced by more than 250 actual screen shots.
    • Illustrates for students the general syntax of SQL and PL/SQL, and helps them avoid mistakes.

  • Enhanced material-Provides new and enhanced information all existing topics, including Oracle's data dictionary; and updated ERD.
    • Enables students to utilize a text that is comprehensive and current.

  • New chapters-Includes Database Administration with Enterprise Manager and a new chapter on database connectivity with Java/C++ and SQLJ.
    • Provides students with a clearer explanation of relational database concepts.

  • New lesson on SQL*Plus-Includes exercises for SQL workshet and iSQL*Plus environments; these add to the already numerous hands-on exercises and lab activities for each chapter.
    • Provides students with ample opportunities to practice the concepts learned in class.

Table of Contents

I. RELATIONAL DATABASE CONCEPTS.

 1. Database Concepts: A Relational Approach.
 2. Database Design: Data Modeling and Normalization.

II. ORACLE SQL.

 3. Oracle 9i: An Overview.
 4. Oracle Tables: Data Definition Language (DDL).
 5. Working with Tables: Data Manipulation and Retrieval.
 6. Working with Tables: Functions and Grouping.
 7. Multiple Tables: Joins and Set Operators.
 8. Subqueries: Nested Queries.
 9. Advanced Features: Objects, Transactions, and Data Control.
SQL Review: Review of SQL Statements Covered in Chapters 3-9 with a Sample Database.

III. PL/SQL.

10. PL/SQL: A Programming Language.
11. More on PL/SQL: Control Structures and Embedded SQL.
12. Cursors and Exceptions.
13. PL/SQL Composite Data Types: Records, Tables, and Varrays.
14. PL/SQL Named Blocks: Procedure, Function, Package, and Trigger.

IV. ADVANCED TOPICS.

15. Connecting to Oracle Database: JDBC, SQLJ.
16. Oracle 9i Architecture and Administration.
Appendix A: Sample Databases-Table Definitions.
Appendix B: Quick Reference to SQL & PL/SQL Syntax.
Appendix C: Reference to SQL*Plus Commands.
Appendix D: Object Orientation with Oracle.
Appendix E: Additional References-Websites and Books.