Database Systems Using Oracle: A Simplified Guide to SQL and PL/SQL / Edition 2

Database Systems Using Oracle: A Simplified Guide to SQL and PL/SQL / Edition 2

by Nilesh Shah
     
 

View All Available Formats & Editions

ISBN-10: 0131018574

ISBN-13: 9780131018570

Pub. Date: 05/13/2004

Publisher: Pearson

This easy-to-read book provides quick lessons on relational database terminology and normalization with very little effort. Updated for Oracle 9i, its thorough coverage of Oracle's SQL and PL/SQL and introduction to advanced SQL topics makes this a must for busy professionals. The many examples, with output shown as screenshots, provide ample opportunity

Overview

This easy-to-read book provides quick lessons on relational database terminology and normalization with very little effort. Updated for Oracle 9i, its thorough coverage of Oracle's SQL and PL/SQL and introduction to advanced SQL topics makes this a must for busy professionals. The many examples, with output shown as screenshots, provide ample opportunity for the reader to easily understand and learn to use Oracle and SQL. First introducing relational database concepts, the book covers SQL (Structured Query Language); Programming Language (the extension to SQL); and then proceeds to advanced topics, which include Oracle architecture and database administration with enterprise tools. For any IT professional who needs to understand SQL or Oracle database systems.

Product Details

ISBN-13:
9780131018570
Publisher:
Pearson
Publication date:
05/13/2004
Edition description:
2ND
Pages:
456
Product dimensions:
7.00(w) x 9.00(h) x 1.00(d)

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.

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >