Often some Oracle beginners ask this question, which is a unified answer.
1, if there is a certain database base, know how the SQL is going on, even if you can not write simple SQL, but you could look at them, you can jump to 2. Otherwise, please look at the database base and SQL language, do not need to be very deep, but also do not need to memorize those complex SQL commands, which can be left in the future edge of the application learning, memory.
2, to learn Oracle, first of all to learn Oracle architecture, now you do not need to understand them in depth, but to distinguish several 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.
And, of course, to distinguish undo Tablespace & Redo log file,
It is not easy for many beginners to have a clearer understanding of these concepts, and these are not all Oracle's.
3, 2 are 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 better understanding of the SQL and Oracle architectures.
4, to this step you basically master Oracle, the following will be based on your direction to learn more about the other Oracle knowledge. If you're a developer, you need to learn more about Pl/sql and developer, and this is going to be a new subject. If you are a DBA, please continue.
5, now you can according to their actual situation, selective learning, that is, the following content does not require special order. You can choose to learn more about Oracle management, backup and recovery, performance tuning, networking, and more. Of course, in the process of learning this knowledge, if there is practical work better, so you can grow in practice, learn to trouble SHOOTING.
6, of course, in the process of learning, you can in the site or forum to communicate with others, you can see some of the experience of others, you can write some of their own experience. Technological progress itself is the accumulation of experience and refining process, I hope we grow together, welcome to communicate with each other.
--------------------------------------------------------------------------------------------------------------- --------------
[Quote from http://www.ncn.cn/]
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
