How to learn Oracle?
There are often some Oracle's beginners asking this question, and here is a unified reply.
1. If there is a certain database basis, know what SQL is going, even if you can't write simple SQL, you can look at them, you can jump to 2. Otherwise, let's take a look at the database base and SQL language, don't need to be deep, don't need to remember those complex SQL commands, which can stay in the future, learn, memory.
2. To learn Oracle, first learn Oracle's architecture, now you don't need to understand them in depth, but you have to divide a few key concepts:
Instance & Database,
Memory Structure, Process & Those Files, Such As Data File, Control File, Init Parameter File ETC
And the relationship between Database, Tablespace, Data File and Tablespace, Segmnet, Extent & Block.
Of course, you have to distinguish undo tablespace & redo log file, etc.
For many beginners, you can have a clearer understanding of these concepts is not an easy task, which is not all Oracle.
3, 2 is some basic concepts about Oracle. The following is some simple practical operation, how to manage the Oracle database, of course, not to manage all Oracle. In this process, you will have a more in-depth understanding of the SQL and Oracle architectures.
4. In this step, you basically have initially mastered Oracle, and below will learn other Oracle knowledge according to your direction. If you are a developer, you need to learn more about PL / SQL and developer, and this will be a new course. If you are a DBA, please continue.
5, now you can make choice to learn according to your actual situation, that is, the following content is not particularly sequential. You can choose to learn Oracle management, backup and recovery, performance adjustment, network, etc. Of course, in the process of learning this knowledge, if there is actual work, you can grow in practice, learn Trouble Shooting.
6. Of course, in the process of learning, you can communicate with others in the website or forum, you can see some experience articles of others, you can write some experience. The technical progress is itself is the experience of the accumulation and refining process. I hope everyone will grow together, welcome everyone to communicate with each other. -------------------------------------------------- -------------------------------------------------- ------------------------- [Part from http://www.ncn.cn/]
