[Source] Learn Oracle Database (1) - Written in the previous words

Question1：  Oracle database books are hard to understand, is oracle really hard to learn?
Answer1：   Oracle is a small piece of software that encapsulates complex things, and we learn to manage databases. Very simple. As long as you master the right learning method, managing Oracle databases is not difficult.

Question2：There are many versions of databases, which one should I learn?
Answer2：   Everything is the same, although there are many versions of the database, the essence is the same, what changes is only the appearance, you are an expert in oracle7, you must also be an expert in oracle10g.

Question3：There are many platforms for databases, which one should I learn?
Answer3：   There are differences on each platform, very small.WindowsIt is the best learning platform.

Question4：There are many tools for managing databases, which one should I use?
Answer4：   The best management tool for sqlplus, when you only use sqlplus to manage databases, you master oracle.

Question5：Which part of database learning is the hardest?
Answer5：   SQL statements are always SQL, and writing efficient SQL is our eternal goal.

Question6：What is the most important job of maintaining a database on a daily basis?
Answer6：   Backup, always backup, where there is data, there is everything.

Question7：  What are the basic courses for learning databases?
Answer7：   architecture, which is the cornerstone of backing up and optimizing databases.

Question8：  How do I measure the level of my database?
Answer8：   You can see whatever you want to see in the oracle database, and you are started. If you can understand everything, you will learn to understand.

Question9：  Is a graphical interface helpful for database learning?
Answer9：   Harmful and not beneficial!

Question10：  I don't have any computer professional foundation, can I learn databases?
Answer10：   Yes! The database is very simple, everyone can learn it. Like a car, we learn to drive, not to build a car. We don't understand the internal structure of the car, but it doesn't affect our driving of the car, our job is to manage the database, it's not difficult.

Question11：  Oracle has a lot of content, what products should we master?
Answer11：   Oracle is not made by one person, we don't need to master it comprehensively, you have mastered the basic principles, and go deeper into your work direction. The division of labor in the industry is very fine, and one person cannot become an all-round master. Life is boundless, knowledge is boundless.

Part ISQ L Basics

Basic query statements, DDL, and DML statements

Part IIPL/SQ L basis

Writing and programming anonymous blocks

Part IIIArchitecture of the database

Instance maintenance, control files, log files, data files, tablespaces, logical structure of databases, management of undo segments, tables—the most basic unit of data stored, indexes, constraint management, profile configuration, permission management, database character sets, metadata

Part IVNetwork configuration of the database

Part 5Backup and recovery of databases

Exp export and imp import, cold backup, hot backup, Rman backup and restore

Part VIOptimization of databases

Data collection, Shared_pool, other memory optimizations, different storage formats, SQL statement optimizations, and different access modes for databases

The expected results are basically grasped as follows

Basic Parts:

Oracle basic

Oracle User Management

Oracle table management

Premium Section:

Oracle tables

Oracle's functions

Oracle database management

Oracle's permissions, roles

PL/SQL programming

Indexes, constraints, and transactions