Some suggestions for Oracle learning

Learning Oracle is a long and arduous process. If you are not interested, just forced to learn, then it is difficult to learn. When learning to a certain extent, if you want to improve further, you have to touch a lot of things other than Oracle, such as Unix, such as network, storage and so on. Therefore, if you really want to learn Oracle well, you must be interested. With interest, everything becomes simple and happy. To sum up briefly, that is: interest, learning, and practice.

Software Name:

Oracle to Mysql ORACLE is converted to Mysql database software free version

Software size:

1.6MB

updated:

2010-08-29

many beginners how to get started is the most difficult thing. There are too many aspects involved in Oracle: 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 foundation, it is naturally very good; if not, it is really a big problem. I personally think that we should learn from SQL statements. A good textbook is Oracle OCP-certified SQL and PL/SQL. When learning SQL, try to use Oracle's own tools: SQLPLUS.

After having a certain SQL foundation, it is necessary to understand the Oracle architecture as much as possible, which involves the contents of Oracle management. When I was studying, the book "Oracle9i DBA Handbook" by Machinery Industry Press helped me a lot. Maybe now the 11g version is out. Oracle's "Oracle Concepts" is a great book that is good for understanding the Oracle architecture. Each Oracle version has a corresponding version, you can read it carefully several times, each time there will be new gains.

The company's products are now almost all Oracle, and when we do maintenance, backup and recovery are the things that have to be touched. The amount of data is small, such as 20, more than 30 G, you can also consider using exp /imp to backup and recovery, but the amount of data is large, this method is simply not suitable. 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. There are a lot of database backup and recovery software on the market. In fact, many of them are called RMAN in the background. "Oracle 9i RMAN Backup and Recovery Technology" published by Tsinghua University Press is a very good book introducing RMAN.

With the above foundation, it can be said that you have already started, and you will not be helpless with some of the junior Oracle problems encountered. However, our learning path is still very long. Our users may often complain that the database is running slowly. At this time, if there is a certain optimization knowledge, then it will be easier. Sometimes you will see a few hours of work before optimization, and it may take a few seconds to optimize! Oracle9i's performance diagnostic toolkit statspack, Oracle10g/11g automatic work in line with the storage library AWR are a good helper to tune. "Oracle9i STATSPACK High Performance Tuning" published by Mechanical Industry Press is a good book to learn statspack.

In the database architecture, programming optimization, there is a book very good, this is the world's top Oracle expert Thomas Kyte wrote "Oracle9i & 10g 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 a collection by many Oracle learners. If you want to study in depth in Oracle, it is strongly recommended to study them carefully.

Mastering the above content, or basically mastering the above content, then you are also a master of Oracle in the eyes of many people, and solving the database problem in the company's products should not be a problem. However, Oracle has a lot of advanced content to learn more. Here are some examples, only for interested colleagues.

1. Advanced Replication Technology

2. Oracle Real Application Cluster (RAC)

3. Data Guard

4. Oracle Stream

5. Data Warehouse

6. Proc, OCI Programming

The above listed advanced content, reference materials are mainly Oracle's electronic documents. 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, Oracle's biggest problem is complexity, complexity is Oracle's greatest charm. Let us work together to harness Oracle!