Many netizens asked how to choose entry books and learn about Oracle's good books. Here are some common books. First, I declare that this article only involves foreign works, because there are very few domestic works, most of which are pieced together.
Speaking of getting started, I have to move Tom (Thomas Kyte) out again. In ask Tom and his latest book, he introduced the learning methods and reading materials he thought were better. The materials he recommended are official Oracle documents. A netizen also suggested whether to read the documents through the version. You can certainly say that if you read all the documents and remember 50% of them, you are already awesome, it is estimated that I will not be able to read it through in my lifetime-for 9ir2, a total of 48 documents totaling 46000 + pages! Tom provides the required documents and sequence. I will briefly describe them as follows:
All personnel
Concepts
|
New Features
_________________ | _______________
|
Developer DBA
Application backup & Recovery
Dev Guide (Fundamentals) Concepts
|
PL/SQLUser Guide recovery reference
& References |
|
Performance administrators 'Guide
Planning |
| _________________________________ |
|
Performance
& Tunning Guide
Let's talk about books.
The best-selling domestic Machine Industry Publishing House is the black one, among which there are many excellent products. The Oracle 9i beginner's guide is easy to understand and is a good helper for getting started.DevelopmentIn terms of Oracle 9i PL/SQL program design, DBA in terms of Oracle 9i DBA manual, and tuning in terms of Oracle 9iPerformanceThe tuning guide is a classic book. Choose as needed. I think Oracle
9i Reference Manual is a good book, which is comprehensive and practical, and will not be further involved in all aspects.
Other classic books cannot bypass Tom. His "Oracle expert advanced programming" (expert one-by-on Oracle) is an absolute classic. Unfortunately, the Chinese version is ruined by translation, i'm reading that some of the translation terms are weird, some of which are actually a little tired, but the content is deep, it involves the Oracle internal structure, lock mechanism, use of import and export, performance tuning, and so on. It is mainly based on Oracle 8.1.7, but in his original words, 99% can be used on 9i without any change. He also wrote another new book titled objective oracle by design (2003) based on this book. There is no translation version in China. If you want to buy it, you only need Amazon. At present, the price is lower. The content is mainly about the entire set of development, such as division of labor in team development, development principles, performance tuning, and so on. The content and contents of these two books can be found in asktom.OracleAs shown in. com, It is a master.
In fact, these books are enough, and tens of thousands of pages are also available. But if you want to test OCP, read the student guide? :)) I have just read Vol.1 from 007 and 031. The general feeling is that the explanation is still detailed and the content is not very deep, but it is really comprehensive. In addition, it is used as a tutorial, so the arrangement of many things takes into account the difficulty and so on, instead of explaining a data object and type at the same time as the general reference manual. You can read this document in conjunction with the official documents and books mentioned above.
By the wayDatabaseBasic Books. Before learning Oracle, you should first read the basic book. If you don't even understand the primary key, you can start to learn oracle. I think it is quite painful. I only wrote two questions, both of which have the Chinese version. I have read the latter, and I feel very good. However, the latter may need a good Discrete Mathematical foundation, involving more basic theories. The former is thicker, so it will be explained to you slowly when you are free, but I personally think it is a bit cool. Classic in any case!
Introduction to databases
Database concepts (version 4)