About this title This easy-to-read book provides quick lessons on relational database terminology and normalization with very little effort. 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. About the Author: Nilesh Shah, Ph. He also works as a systems analyst at Monroe College, New York.
|Published (Last):||13 February 2016|
|PDF File Size:||1.29 Mb|
|ePub File Size:||9.20 Mb|
|Price:||Free* [*Free Regsitration Required]|
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. Part IV, Advanced Topics, allows students to further understand and utilize Oracle 9i architecture and administration.
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 actual screen shots. Enables students to utilize a text that is comprehensive and current. Provides students with a clearer explanation of relational database concepts.
Provides students with ample opportunities to practice the concepts learned in class. Allows students to use the text with different versions of Oracle and with different environments, making it an invaluable future reference work. Provides students with ample opportunity to self-test. Comprehensive appendices. Provides students and instructors with an easily accessible reference.
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. More examples—Provided throughout the text; coding examples are replaced by more than actual screen shots. Table of Contents 1. Database Concepts: A Relational Approach.
Database Design: Data Modeling and Normalization. Oracle 9i: An Overview. Working with Tables: Data Manipulation and Retrieval. Working with Tables: Functions and Grouping. Multiple Tables: Joins and Set Operators. Subqueries: Nested Queries. Cursors and Exceptions. Oracle 9i Architecture and Administration. Appendix D: Object Orientation with Oracle.
ISBN 13: 9780131018570
Sign in to the Instructor Resource Centre