Important knowledge points to be mastered in Oracle Learning

Important knowledge points to be mastered in Oracle Learning

1. Basic syntax

This is required. select, insert, update, where, and so on. To master this knowledge, you can do some verification and testing work. The target is for O & M or testing.

2. Writing stored procedures

You need to know how to write storage functions and stored procedures. How to call each other. To master this knowledge, you can do some basic development work. The target is in software development.

3. Package Design

Know what a package is and how to design a package. To master this knowledge point, you can basically design the database. Target for advanced software development.

4. concurrency, transactions, locks, and partitions.

Know how to use concurrency, transactions, locks, and partition functions. The conditions under which each function is applicable. With this knowledge, you can do some architectural design work. The target is DBA or database architect.

5. Understand oracle processes, memory layout, indexes, and other knowledge

Understand the operating principles and architecture of oracle. This knowledge can be used for debugging. The target is the advanced DBA.

Summary: if you are interested in oracle, you will be familiar with it all. Become a bull. If oracle is only used in work, consider the depth of learning as appropriate. A limited amount of energy, please maximize the value in a limited time.