استاد شدن در Oracle SQL و SQL *Plus: [شامل CD-ROM با مجوز توسعه‌دهنده پایگاه داده Oracle 10g برای ویندوز]

I have been doing a survey of Oracle books since I have a need to learn this database.. I took this book out of the library and I was looking at some of their samples that look like they have been thrown out there expecting you to get the data behind them. I went online to Apress looking for the source code and downloaded it only to find that the data is missing from the tables (actually all the code contained simple select statements). If you are learning SQL, and they are presenting how to you functions, they should provide the data as a download, included CD or some other format. Otherwise, the reader will have no clue behind what they are trying to show you... For example, in chapter 4 they are showing the difference between using the select statement with and without the distinct attribute. According to their discussion their are 8 rows displayed instead of 14 except what is the original data entered into the table? Am I missing something? The only good book that I found is Oracle Database by Jason Price. Even though he focuses on some small stuff he is coherent, complete and thorough in his presentation. In addition the complete source code can be downloaded from the web. The only thing is that he stuffs a lot of the examples into a few files but you can easily cut the information out that you need (at least the table data is provided to the user which really helps)... Update: This past week, I went to the Apress website and filled out an errata on this book... Even though, they said the writer will be contacted, I do not think anything will come about changing this issue (even though I do not believe it is a major fix).

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 25 years of teaching experience. de Haan is also a member of the ANSI/ISO SQL standardization national body.

Table of Contents

1. Relational Database Systems and Oracle
2. Introduction to SQL, iSQL*Plus, and SQL*Plus
3. Data Definition, Part I
4. Retrieval: The Basics
5. Retrieval: Functions
6. Data Manipulation
7. Data Definition, Part II
8. Retrieval: Multiple Tables and Aggregation
9. Retrieval: Some Advanced Features
10. Views
11. SQL*Plus and iSQL*Plus

SQL is the ANSI-standard language for accessing and manipulating relational databases. Anyone (programmers, administrators, or designers) who work with a relational databases need to understand the SQL language. While most books on the market do not properly cover the basics, this book differs: it explains fundamentals in detail, supported by realistic examples.You will gain full competence to define, access, and manipulate data in an Oracle database.This book is an effective tool for you to write effective SQL for the Oracle database. The text is fully compliant with the latest version of the ANSI SQL standard, and fully update for the Oracle 10g database. This book is a translation of popular Netherlands college text (currently in its third edition). Author Lex de Haan is highly 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. *Ideal for anyone who wants to learn SQL programming for Oracle database. *Author has 25 years of teaching experience; 14 years of curriculum develoment experience; 14 years of experience with the Orcle database. *Book can be used as collateral/handouts for SQL training courses at universities/ high schools.