Learn the skills that Oracle should prepare and the oracle preparation skills

Learn the skills that Oracle should prepare and the oracle preparation skills

First, database skills:Database architecture, basic concepts and basic theories, database management, backup, recovery, SQL development, PLSQL development, and use of tools.

Operating System skills:Linux/Unix systems should have a considerable foundation. Understand concepts related to storage such as RAID, RAW, ASM, LVM, and OCFS, install Oracle software, install patches, and upgrade the system, and use common Linux/Unix commands: rpm, cpio, tar, ftp, top, vmstat, iostat, sar, netstat, ifconfig, crontab, chmod, chown, lsof, ntsysv, mv, rm, vi, mkdir and rmdir, etc..

Network:You need to understand basic network models and network protocol working principles.

Tools:You need to know how to use some performance measurement tools.

After preparing the above knowledge, we will begin to optimize the Oracle database.

In the future, I want to develop towards the database. At present, there is no basic preparation for training. If I want to learn oracle, do I need to master the linux technology?

I'm a little excited to have a chat today.
First, you need to know what kind of environment oracle is used in. Needless to say, it must be used as the background database for large-scale applications. Can a large application run on windows? Yes, but few. Mobile boss systems and banking transaction systems run on unix platforms. Therefore, it is necessary to learn the basics of oracle linux.
The answer provided above is very detailed and correct. The oracle architecture, SQL statements, and plsql are all required. To be honest, oracle is to play with SQL. A dba spends most of its time debugging SQL statements, analyzing execution plans, and providing database performance optimization suggestions, oracle is a deep topic, ranging from backup, optimization, to how an oracle block stores data.
The second question is, if you want to test an ocp + rhec to get a dba job, I can tell you directly that it is impossible. Don't listen to the demands of any training institutions, work well, and so on. The employment of oracl6e is no longer like the time in. We have trained 10 people who have a lot of work experience and can immediately get dba jobs after graduation. The number of employees is 0. If you don't have any basic knowledge (I mean you don't have any basic database or even system knowledge), you can directly train oracle. Congratulations, you are waiting for your death ~

What exactly do oracle need to learn? I really don't know about the database. Is there a lot to learn?

Difficulties in database...
Database, that is, to operate on data!

1. Ensure that the data is complete and no errors can be made! Because data is the core of an enterprise! (Backup and recovery knowledge points ).
2. Can you solve any database exceptions? (Find some trouble for yourself and how to concatenate these things)
For example, data files, control files, log files, hard disks, and operating systems are faulty. How do you think is it?
3. What is your data size? 1G, 100G, 1 T, 1 Mt, 1 TT number, how to plan your operating system, storage device. if it improves his operating efficiency !, This is what the data warehouse needs to do.
4. The simplest example is the database of the train ticket system, which is 12306. How can we solve the data access problem during the peak hours? This is the OLTP system of the real-time system, how to deal with these loads when traffic increases suddenly? (Now knowledge about ORACLE clusters and DATAGRID )!
It takes some time for you to master these skills.
These are just my personal opinions. What's wrong with them! :>