Database Systems Using Oracle

Database Systems Using Oracle : United States Edition

3.95 (42 ratings by Goodreads)
By (author) 

Free delivery worldwide

Available. Dispatched from the UK in 2 business days
When will my order arrive?


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 more

Product details

  • Paperback | 456 pages
  • 177.8 x 233.7 x 17.8mm | 680.4g
  • Pearson Education (US)
  • Pearson
  • Upper Saddle River, NJ, United States
  • English
  • 2nd edition
  • 0131018574
  • 9780131018570
  • 1,471,959

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 more

Rating details

42 ratings
3.95 out of 5 stars
5 43% (18)
4 26% (11)
3 17% (7)
2 12% (5)
1 2% (1)
Book ratings by Goodreads
Goodreads is the world's largest site for readers with over 50 million reviews. We're featuring millions of their reader ratings on our book pages to help you find your new favourite book. Close X