Oracle learning methods and Suggestions

Learning Oracle is a long and arduous process. If you are not interested but forced to learn, it is difficult to learn well. To a certain extent, if you want to further improve your knowledge, you have to get in touch with a lot of things outside of Oracle, such as Unix, such as network and storage. Therefore, you must be interested in learning Oracle well. If you are interested, everything will become simple and happy. To sum up, it is interest, learning, and practice.

Getting started is the biggest headache for beginners. Oracle involves too many aspects: SQL, management, optimization, backup and recovery ...... So where can I start learning well? If you have studied database theory in college, or have a certain database base, it would be good. If not, it would be a big problem. I personally think we should learn from SQL statements. A good tutorial is SQL and PL/SQL certified by Oracle OCP. When learning SQL, try to stick to the built-in Oracle tool: SQLPLUS.

With a certain degree of SQL Foundation, we should try to understand the Oracle architecture as much as possible, which involves the content of Oracle management. When I was studying, the Oracle9i DBA manual by the Mechanical Industry Publishing House helped me a lot. Maybe all of them are out of version 11g now. Oracle Concepts is a great book, which is good for understanding the Oracle architecture. Each Oracle version has a corresponding version, which can be carefully read several times, each time there will be a new harvest.

Almost all of our products are now using Oracle. during maintenance, backup and recovery have to be met. If the data volume is small, for example, 20 or 30 GB, you can also consider using exp/imp for backup and recovery. However, this method is not suitable if the data volume is large. Therefore, it is inevitable to learn the Oracle backup and recovery technologies. In the case of large data volumes, Oracle recommends using RMAN for data backup and recovery. At present, there are many database backup and recovery software on the market. In fact, many of them also call RMAN in the background. Oracle 9i RMAN backup and recovery technology published by Tsinghua University Press is a very good book about RMAN.

With the above foundation, we can say that we are getting started, and we will not be able to do anything about some of the basic Oracle problems we encounter. However, we still have a long way to learn. Our users may often complain about slow database operation. At this time, if you have a certain degree of optimization knowledge, it is easy to do. Sometimes you will see that jobs that need to be run several hours before optimization can be completed in a few seconds after optimization! The statspack and Oracle10g/11g performance diagnostic kits of Oracle9i automatically work in accordance with the AWR of the repository are a good helper for tuning. The Oracle9i STATSPACK High Performance adjustment published by the Mechanical Industry Press is a good book to learn about statspack.

There is a great book on database architecture and programming optimization, this is the Oracle9i & 10g programming art (English name: "Expert Oracle Database Architecture") written by Thomas Kyte, the world's top Oracle Expert "). Tom used to write a book called "Expert One-on-One Oracle", which is also very classic. These two books are considered by many Oracle learners. If you want to learn more in Oracle, you are strongly advised to study them carefully.

If you have mastered the above content or have mastered the above content, you are also a master of Oracle in the eyes of many people. Solving the database problems in the company's products should not be a problem. However, Oracle still has a lot of advanced content for further study. Here are some examples for your reference only.

1. Advanced Replication Technology

2. Oracle Real Application Cluster (RAC)

3. Data Guard

4. Oracle Stream

5. Data Warehouse

6. Proc and OCI Programming

The Advanced content listed above is primarily an Oracle electronic document. To be honest, I am not familiar with the data warehouse, Proc, and OCI programming in the above columns.

In the process of learning Oracle, making full use of network resources can do more with less.

In short, the biggest problem with Oracle is complexity, which is the biggest charm of Oracle. Let's work together to control Oracle!