1. Learn the architecture of oracle first, understand the function of oracle module in memory, and the ways of storage, reading, writing and backup. Oracle database 9i/10g/11g programming art is highly recommended.
2, learning sql, similar to other databases, but oralce has some unique grammar you have to learn. The following is what I need to master after learning the basic sql of oralce, and learn these recommended Advanced Programming for Oracle Experts.
● Control the transaction management.
● Create simple and complex views Create simple and complex views.
● Create, maintain and use sequences to control oralce's queues.
Delete the rows in the table to delete the table.
● Insert rows into the table.
● Connect the table to itself by using self-connection and self-connection.
● Update the rows in the table to modify the table.
● Set operators can be used to combine multiple single queries.
Use the with clause to use the with statement.
Basically, the first two books are enough for development, but if you want to advance to DBA, go ahead.
3. The database administrator, oca of oralce, recommended the original training materials of oracle. The following is the knowledge you need to master.
● Create consistent database backup.
● Monitor and resolve locking conflicts.
● Recover from the loss of system key data files.
● Restore the table contents to a specific point in time.
● Set warning and critical warning thresholds.
● Adjust instance recovery.
4. Database authentication expert, ocp of oracle, recommended the original ocp training materials of oracle. The following is the knowledge you need to master.
● Configure the resource manager
● Create a resource plan within the group.
● Determine which flashback technology to use in each recovery situation.
● Explain the reasons for incomplete recovery.
● Manage (or maintain) the rapid recovery area.
● Rebuild the index online.
● Use flashback version query to recover from user error.
● Restore the control file.
● Reduce space-related errors by actively managing tablespace usage.
● Start RMAN utility and allocate channels.
Use different storage options to improve query performance.
● Use RMAN backup command to create backup sets and image copies.
5. ocm of 5.oralce hasn't taken the exam yet. .
I used to fight with my whole hand! Hope to adopt