Some suggestions for Oracle learning

Learning about Oracle is a long and arduous process. If you are not interested, just forced to learn, it is difficult to learn. Learning to a certain extent, to further improve, you have to contact a lot of things beyond Oracle, such as UNIX, such as network, storage and so on. Therefore, to be really determined to learn Oracle, you must be interested. With interest, everything becomes simple and joyful. To sum up, it is: interest, learning, practice.

How to get started is the most troublesome thing for many beginners. Oracle is involved in too many aspects: SQL, Management, optimization, backup recovery ... So where do you start to learn? If you have studied database theory during college or have a certain database base, it would be a great problem. I personally think it should be learned from the SQL statement. The better textbook is the Oracle OCP certified SQL and Pl/sql. When learning SQL, stick with Oracle's own tools as much as possible: Sqlplus.

With a certain base of SQL, it is important to understand Oracle's architecture as much as possible, which involves Oracle management. When I was studying, the Oracle9i DBA Manual of the machinery industry press had helped me a lot. Maybe it's all out of the 11g version now. Oracle's Oracle Concepts is a great book and is good for understanding Oracle architectures. Each Oracle version has a corresponding version, you can read more than a few times, each will have a new harvest.

The company's products are now almost all using Oracle, and we do maintenance, backup and recovery is the content to be contacted. Small amount of data, such as 20, more than 30 g, you can also consider using EXP/IMP to backup and recovery, but the volume of data, this method is simply not suitable. So learning Oracle Backup and Recovery technology is also a necessity. In the case of large data volumes, Oracle recommends that Rman be used for backup and recovery of data. At present, there are many database backup recovery software, in fact, many are also the background call Rman. "Oracle 9i Rman Backup and Recovery Technology" published by Tsinghua University Press is a very good book to introduce Rman.

With the above foundation, you can say that you are getting started, and you will no longer be helpless with some of the primary Oracle problems you encounter. However, we still have a long way to learn. Our users may often complain that the database is running slowly. At this time, if there is a certain degree of optimization knowledge, it is good to do. Sometimes you will see a few hours of work before the optimization, the optimization may be completed in a few seconds! Oracle9i's Performance Diagnostics Kit Statspack, ORACLE10G/11G's automatic work conforms to the repository awr is a good helper for tuning. Machinery Industry Press Published "Oracle9i statspack high-performance adjustment" is to learn statspack good books.

In the database architecture, programming optimization, there is a book is very good, this is the world's top Oracle expert Thomas Kyte written "oracle9i&10g Programming Art" (English name is "Expert Oracle Database Architecture "). Tom used to write a book called "Expert One-on-one Oracle", also very classic. These two books are considered valuable by many Oracle learners and are strongly recommended for careful study if they are to be studied in depth in Oracle.

Master the above content, or basically master the above content, then you in many people's eyes is also Oracle Master, solve the company's products in the database problem should not be a problem. However, Oracle also has a lot of advanced content to learn further. Here are some, only for 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

These advanced content listed above, resources are mainly Oracle company's electronic documents. To be honest, I'm not familiar with the Data Warehouse, PROC, OCI programming of the column above.

In the process of learning Oracle, the full use of network resources can play a multiplier effect.

In summary, Oracle's biggest problem is complexity, complexity is Oracle's greatest charm. Let's work together to harness Oracle!