Oracle PL/SQL to learn?

Question

Oracle

Good evening, I would like to clarify with those who know, I decided to go towards the database, at the moment I worked minimally with databases, elementary concepts such as SELECT ORDER WHERE DELETE, etc. are available, to dive into PL / SQL Oracle, you need to study the work from scratch with a DB or it is possible already especially to be orientated under itself orakl?
I would also like to ask for fresh information on Oracle, since all the materials on the Internet are very old.
According to the stack in the luggage php, native js, jq.
I would like to thank everyone for advice and help.

Answer 1

pl/sql itself is only part of what you need to know. Oracle is extensive. Oracle in its implementation tries to meticulously follow all the standards, whether it's working with sql or xml, so you can purely focus on oracle itself. PL/SQL is an ada-like language, quite simple, really. It is not very difficult to learn and use it.
From a developer's point of view, I would single out three areas of study:
- study of the DBMS itself. You can start with Oracle database concepts.
- learning SQL. Everything is simple here, in general, Oracle sql is the same sql as everywhere else. There is, of course, a variant of its own syntax, but you can also write in ANSI. I can’t advise something simple, for a detailed study, you can read the OCA Oracle Database SQL Exam Guide.
- learning pl/sql. There are many resources, books, official documentation.
The rest - packages, options - can already be drawn from Oracle references and manuals. For example, in the appendage, you can learn APEX to create application applications.
It is worth preparing for a large number of new information.