Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.
Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.
Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.
Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.
Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.
Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.
0131018574 Premium Publisher Direct Books are Like New or Brand New books direct from the publisher sometimes at a discount. Multiple copies are usually available. These books ...are not available for expedited shipping and may take up to 14 business days to receive.Read moreShow Less
PAPERBACK New 0131018574 Premium Publisher Direct Books are Like New or Brand New books direct from the publisher sometimes at a discount. Multiple copies are usually ...available. These books are not available for expedited shipping and may take up to 14 business days to receive.Read moreShow Less
5-13-04 other 2 BRAND NEW! ONLY Expedited orders are shipped with tracking number! *WE DO NOT SHIP TO PO BOX* Please allow up to 14 days delivery for order with standard ...shipping. SHIPPED FROM MULTIPLE LOCATIONS.Read moreShow Less
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.
More About This Textbook
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
Related Subjects
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.