 |
Mastering Oracle SQL and SQL *Plus View Larger Image | Lex de Haan
Apress, Paperback, Published January 2005, 468 pages, ISBN 1590594487 | List Price: $39.99
Our Price: $24.50
You Save: $15.49 (39% Off)
| | | Availability: Out-Of-Stock |
Customer Reviews: 1 Average Customer Rating:  Write a Review and tell the world about this title! People who purchase this book frequently purchase: - Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions; Thomas Kyte, $30.50, 39% Off!
- Oracle Database 10g PL/SQL Programming; Scott Urman, et al, $33.50, 39% Off!
- Oracle PL/SQL Programming, 4th Edition; Steven Feuerstein, et al, $40.50, 38% Off!
- Expert Oracle Database 10g Administration; Sam R. Alapati, $36.95, 38% Off!
Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
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.
Table of 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
About the Author
Lex de Haan worked for Oracle Corporation fourteen years, including four years as the senior curriculum manager for the education division, among the product development groups. In March, 2004, de Haan decided to "go independent" again, with hisNatural Join B.V. consultancy. de Haan specializes in education and consulting in the areas of relational data modeling, SQL tuning, physical database design, database administration, and database internals. He presents training seminars on these topics all over the world. Since 1999, de Haan has been a member of the Dutch national body of the ANSI/ISO standardization committee for the SQL Language, working on the SQL:1999 and SQL:2003 standards. de Haan is a founding members of the Oaktable network.
Customer Reviews
Customer Reviews: 1 Average Customer Rating: Mar 31, 2005
Comprehensive Oracle SQL book with good examples
I have read several Oracle SQL books over the past few years and this one really hits the mark.
If you are new to Oracle or trying to catch up on some new features in 9i or 10g, or just haven't had the time to sit down and learn about iSQL*Plus yet, this book can get you off to a very good start.
The flow of the book was very logical - Starting off with the Relational Model and moving along to DDL, DML, data retrieval, and even some object-relational concepts. Along the way, coverage of SQL*Plus and the new iSQL*Plus are done in nice order. Even though I've been working at the SQL*Plus prompt for about 10 years, I'm always amazed to see the options and little helpful things that can make my job a little bit easier. Learning the tricks of report generation from your SQL*Plus session are invaluable and you will use these almost daily as a DBA.
Perhaps the most interesting chapter for me as an experienced Oracle DBA was the one on Advanced Features of Data Retrieval which introduced some new topics to me like Oracle's new Flashback Query and SQL Analytics. This is the first Oracle book I've seen that explains SQL Analytical and Windowing functions, which are quite advanced features in later releases of Oracle. His examples are good and I would look forward to seeing a whole section on this topic in future editions.
The flow of the book went well and I believe I will find this to be a useful reference for looking up SQL related info later on. Appendix A has a nicely formatted SQL Quick Reference which I anticipate using quite a bit.
As Mr. de Haan comes from the well regarded Oracle Education Course Development group, he added an exercises section at the end of each chapter. Though I often don't have the time while reading a techincal book to complete these, I definitely see the value and will make it a point to run through them to test or reinforce the topics I have read about.
Overall, I'd highly recommend this book to anyone interested in learning Oracle SQL or who would like to brush up on some new SQL features in Oracle9i and 10g.
|
|
