How to get started is the most difficult thing for many beginners. Oracle involves too many aspects: SQL, management, optimization, backup and recovery, so where to start learning? If you have studied database theory during college, or have a certain database foundation is naturally very good; if not, it is really a big problem. I personally believe that we should start with SQL statements. A better textbook is SQL and PL/SQL for Oracle OCP Certification. When learning SQL, stick to Oracle's own tools as much as possible: SQLPLUS.
After a certain SQL foundation, you have to learn as much as possible about Oracle's architecture, which involves the content of Oracle Administration. When I studied, the book "Oracle9i DBA Handbook" by Mechanical Industry Press helped me quite a lot. Maybe now all out of the 11g version of it. Oracle's "Oracle Concepts" is a very good book, to understand the Oracle architecture is very good. Each Oracle version has a corresponding version, you can read it carefully a few times, each time there will be a new gain.
The company's products are almost all using Oracle now, and when we do maintenance, backup and recovery is something we have to touch. The amount of data is small, such as 20, 30 more than G, you can also consider using exp/imp to backup and recovery, but the amount of data is large, this method is not suitable at all. So learning Oracle backup and recovery technology is also an inevitable thing. In the case of large data volumes, Oracle recommends using RMAN for data backup and recovery. Currently on the market there are a lot of database backup and recovery software, in fact, a lot of them are also the background call RMAN. Tsinghua University Press published "Oracle 9i RMAN Backup and Recovery Technology" is a very good introduction to the RMAN book.
With the above foundation, we can say that we have already started, and some of the primary Oracle problems we encountered will no longer be helpless. However, we still have a long way to go. Our users may often complain that the database runs slowly. At this point, it would be good to have some knowledge of optimization. Sometimes you will see the optimization before the need to run several hours of work, optimization may be a few seconds after the completion! Oracle9i's performance diagnostic toolkit statspack, Oracle10g/11g's automatic work in line with the repository AWR are tuning a good helper. Mechanical Industry Press published "Oracle9i STATSPACK high-performance tuning" is to learn statspack good book.
In the database architecture, programming optimization, there is a great book, which is the world's top Oracle expert Thomas Kyte wrote "Oracle9i10g programming art" (English name "Expert Oracle Database Architecture"). Tom also wrote a book called "Expert One-on-One Oracle", which is also very classic. These two books are regarded as treasures by many Oracle learners, and if you want to go deeper in Oracle, it is highly recommended that you study them carefully.
Mastered the above content, or basic mastery of the above content, then you are in the eyes of many people Oracle masters, to solve the company's products in the database problem should not be a problem. But Oracle has a lot of advanced content can be further study. Here is a list of some, only interested colleagues reference.
1. Advanced Replication Technology
2. Oracle Real Application Cluster (RAC)
3. Data Guard
4. Oracle Stream
5. Data Warehouse
6. Proc, OCI Programming
The references for these advanced content listed above are mainly Oracle's electronic documentation. To tell you the truth, I am not familiar with the data warehouse, Proc, OCI programming listed above.
In the process of learning Oracle, the full use of network resources can play a doubly effective role.
In short, Oracle's biggest problem is complexity, complexity is the biggest charm of Oracle. Let us in order to harness Oracle and *** with the efforts of it!