A brief summary of Oracle Learning Process

There are many things worth learning about Oracle. Here we mainly introduce the Oracle learning process, including the Oracle system. The Oracle system is too huge. For Beginners, it is inevitable that they will not start to feel like they want to learn anything, and the results will not be good. So share their learning experience, we hope that the beginners will have a general understanding of Oracle and avoid detours.

I. Positioning

Oracle has two major parts: development and management. Development is mainly about writing stored procedures, triggers, and so on, as well as using Oracle's Develop tool for form. It is a bit similar to a programmer who needs to have strong logical thinking and creative ability. I personally think it will be hard, but it is a problem of youth. management requires a deep understanding of the principles of Oracle databases, it has the ability to perform global operations and close thinking, and has a greater responsibility. Because a small mistake will lead down the entire database, the latter places more emphasis on experience than the former.

Because database management has a major responsibility, few companies are willing to ask a person who has just been in contact with Oracle to manage databases. For young people who have just graduated, they can choose development first, and then transform to database management after some experience. Of course, this depends on the actual situation of individual users.

Ii. Learning Methods

My approach is simple: Reading, thinking, taking notes, experimenting, thinking, and taking notes.

After reading the theoretical things, Let me calm down and think about it. I will ask myself a few more questions and take notes on what I have learned and what I think. I will do experiments when I cannot figure out or have questions, think about how it works. Similarly, write down the experiment results. Thinking and doing experiments aims to gain a deep understanding of this knowledge point. The process of taking notes is also a process of clarifying your own ideas.

The Oracle learning process is a process from fuzzy to clear, and then from clear to fuzzy. Every change means that you have learned a new knowledge point.

Oracle's learning process is also from point to line, from line to network, from network to surface. When the point turns into a line, you will suddenly feel open. When the network reaches the surface, you are the master.

Many netizens, especially beginners, have obtained questions from the Forum. Have you checked the books, studied the books, and searched the Forum before asking? This is called the inertia of thinking. When someone else answers your question, it will make it difficult for you to understand this knowledge point in a short period of time. However, through your own efforts to study it, you will not only gain a deeper understanding of this knowledge point, more importantly, the research process will improve your ability to solve and analyze problems. In general, no matter what you learn, you will not succeed.

Of course, beginners often go to the forum to raise questions when they encounter problems and do not know where to find information. But in my opinion, can I ask others how to analyze this question? Where can I find relevant materials? What is the answer to this question? It is better to teach people to fish than to teach them to fish.

1. Brief Introduction to Oracle 10 Gb Database
2. Overview of Oracle Database physical files
3. Description of Oracle data server startup mode
4. Brief Analysis of Oracle Rownum
5. Comprehensive Oracle Database 11g debate