How to learn Oracle

How to learn Oracle? Distinguishing several concepts is the key There are always some Oracle beginners ask the following questions, here to focus on the answer, I hope to help you.  1, if there is a certain base of the database, know what SQL is going on, even if you can't write simple SQL, but you can look at them, you can jump to 2. Otherwise, take a look at the database base and SQL language, do not need to be very deep, do not need to remember the complex SQL commands, these can stay in the future side of the application side learning, memory.  2. To learn Oracle well, the first thing to learn about Oracle's architecture is that you don't need to understand them in depth, but there are a few key concepts to distinguish: Instance & database, memory structure, process & those files, such as data file, control file, init Paramet ER file etc. As well as database, tablespace, data file and tablespace, Segmnet, extent & block the relationship between them.  of course, it's important to distinguish between undo Tablespace & Redo log file, and for many beginners, it's not easy to have a clearer idea of these concepts, which is not the whole of Oracle.  3, some of the basic concepts of Oracle, the following is to learn some simple practical operation, is how to manage the Oracle database, of course, not the management of all Oracle. In this process you will have a deeper understanding of SQL and Oracle architectures.  4, to this step you basically have mastered the Oracle, the following will be based on your direction to specific learning of other Oracle knowledge. If you're a developer, you'll 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 according to their actual situation, the choice of learning, that is, the following content is not a special order requirements. You can choose to learn more about Oracle's management, backup and recovery, performance tuning, networking, and more. Of course, in the process of learning these knowledge, if there are practical work better, so you can grow in practice, learn to trouble SHOOTING.  6, of course, in the process of learning, you can communicate with others in the site or forum, you can see some of the experience of others, you can also write some of their own experience. The progress of technology is itself the accumulation of experience and the process of refining. 3-------------------------

How to learn Oracle