What should I pay attention to when learning Oracle?

Oracle beginners often ask this question. Here is a unified answer.

1. If you have a certain database foundation and know what SQL is going on, you can skip to 2 even if you cannot write simple SQL statements. Otherwise, let's take a look at the basic database and the SQL language. You don't need to have a deep understanding of the complex SQL commands, but you don't need to remember them. These SQL commands can be used and learned and memorized later.

2. To learn about ORACLE, you must first learn the architecture of ORACLE. Now you do not need to understand them in depth, but you need to clarify 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.

Of course, the undo tablespace & redo log file and so on must be distinguished,

For many beginners, it is not easy to have a clear understanding of these concepts, and these are not all about Oracle.

3 and 2 are some basic concepts related to ORACLE. The following describes some simple practical operations, that is, how to manage ORACLE databases, of course, not all ORACLE databases. In this process, you will have a deeper understanding of SQL and ORACLE architecture.

1 2 Next Page

[Content navigation]
Page 7: What should I pay attention to when learning Oracle?	Page 7: What should I pay attention to when learning Oracle?