Learn Oracle databases from six aspects

Source: Internet
Author: User

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. If you want to learn about Oracle and the architecture of Oracle, you do not need to understand them in depth. However, you need to clarify several key concepts: instance & database, memory structure, process & those files, such as data file, control file, init parameter file etc, database, tablespace, data file, tablespace, segmnet, extent & block relationships between them.
Of course, undo tablespace & redo log file should be distinguished. For many beginners, it is not easy to have a clear understanding of these concepts, these are not all about Oracle.
3. The following describes some simple operations: how to manage the Oracle database, of course, not all Oracle databases. In this process, you will have a deeper understanding of SQL and Oracle architecture.
4. At this point, you have basically mastered Oracle. Next, you will learn other Oracle knowledge based on your needs. If you are a DEVELOPER, you need to learn more about PL/SQL and DEVELOPER. This will be a new course.
5. Now, you can select based on your actual situation. That is to say, the following content has no special requirements. You can choose to learn more about Oracle management, backup and recovery, performance adjustment, and network. Of course, in the process of learning this knowledge, if you have a better job, you can grow in practice and learn trouble shooting.
6. Of course, you can communicate with others on your website or forum.

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.