Where to start learning Oracle?

All setup steps are described on this site.

1. Install VirtualBox.
2. Install Oracle Linux or Centos (version 6.X) on it.
3. Configure the network, connect to the server via SSH.
4. If you don’t know how to work with the VI editor, you need to look at 10 commands on how to use it (there are links on the site).
5. Install Oracle 12C in Single configuration without ASM.
6. Install Oracle Client on the host machine.

7. Connect to the database using PL/SQL Developer or TOAD.

8. Next, decide what you prefer to do: SQL and PL/SQL or tasks related to administration.

9. You need to take a course similar to Oracle Database 12c: Administration Workshop I, II and/or SQL. Download pdf and video. The pdf for version 11 in English can be found 146% without any problem. Version 10 in Russian. The version doesn’t really matter for the start. Video, for example from the Specialist training center or even better from cbtnuggets, if your English is more or less okay. Take this course, repeating after the teacher. Then reread the pdfs. If you need administration, study administration materials. If SQL and PL/SQL, then materials on that topic accordingly.

All! An excellent start!

If something doesn’t work, you can try asking a question in the chat.

I would be grateful if you study these materials and help add missing information to the site. I’m interested in, for example, recreating an instance from pfile, recovery after file losses, and much more.