Database Systems Using Oracle

A Simplified Guide to SQL and PL/SQL

Nilesh Shah

326 pages, parution le 04/04/2002

Ajouter à une liste

Indisponible

Résumé

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.

Contents

I. DATABASE CONCEPTS.

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

II. THE ORACLE SQL.

3. Oracle 8: An Overview.
4. Oracle Tables: Creation and Modification.
5. Working with Tables: Data Management and Retrieval.
6. Multiple Tables: Joins and Sub-Queries.
7. Advanced Features: Objects, Transactions, and Control.
SQL Review: Supplementary Examples.

III. PL/SQL.

8. PL/SQL: Programming Language Basics.
9. SQL and Control Structures in PL/SQL.
10. Cursors and Exceptions.
11. Composite Data Types: Records and Tables.
12. Procedures, Functions and Packages.

IV. MISCELLANEOUS TOPICS.

13. Oracle Database Administration.
14. Oracle 8i: An Overview and Web Tools.

Appendix A: Sample Databases: Table Definitions.
Appendix B: Quick Reference to SQL & PL/SQL Syntax.
Appendix C: Additional References.

Index.

Caractéristiques techniques

	PAPIER
Éditeur(s)	Prentice Hall
Auteur(s)	Nilesh Shah
Parution	04/04/2002
Nb. de pages	326
Format	17,5 x 23,5
Couverture	Broché
Poids	496g
Intérieur	Noir et Blanc
EAN13	9780130909336
ISBN13	978-0-13-090933-6