|
Mastering Oracle SQL & SQL Plus
This exceptional book explains fundamentals in detail, supported by realistic examples, while most other books on the market do not properly cover such basics. If you work with relational databases you need to understand the SQL language. And you will gain full competence to define, access, and manipulate data in an Oracle database, if you do so following
this book's guidance.
This book is fully compliant with the latest version of the ANSI SQL standard, and fully updated for the Oracle 10g database. Furthermore, this book is based on a popular Netherlands college textbook (currently in its third edition). And author Lex de Haan is vastly experienced with the Oracle database, and has twenty-five years of teaching experience. de Haan is also a member of the ANSI/ISO SQL standardization national body.
CONTENTS
Chapter 1 - Relational Database Systems and Oracle
Chapter 2 - Introduction to SQL, iSQL*Plus, and SQL*Plus
Chapter 3 - Data Definition, Part I
Chapter 4 - Retrieval: The Basics
Chapter 5 - Retrieval: Functions
Chapter 6 - Data Manipulation
Chapter 7 - Data Definition, Part II
Chapter 8 - Retrieval: Multiple Tables and Aggregation
Chapter 9 - Retrieval: Some Advanced Features
Chapter 10 - Views
Chapter 11 - SQL*Plus and iSQL*Plus
Chapter 12 - Object-Relational Features
Appendix A - Quick Reference to SQL and SQL*Plus
Appendix B - Data Dictionary Overview
Appendix C - The Seven Case Tables
Appendix D - Answers to the Exercises
Appendix E - Oracle Documentation, Web Sites, and Bibliography
|
