What do you need to know to learn pl/sql?

Question

IT education

Recently I saw a vacancy for a Colvir programmer, the only requirement is knowledge of pl / sql. I studied oracle sql in high school for three plus (simple queries and creating and deleting and changing tables).
Is this knowledge enough to learn pl/sql?

Answer 1

In Enterprise projects (mainly in banking software), business logic is often written in PL / SQL in the Oracle DBMS. Therefore, I recommend you a book on programming in PL / SQL "Oracle PL / SQL. For professionals. 6th ed." .
You can search the text in this book and find answers to many Oracle PL/SQL questions.
The right way is to read a book and practice on some home project.
For example. you can raise a local Oracle XE database, just recently its latest version was released, as discussed in the habr article. In a local Oracle database, create your first schema with tables, fill them with data, perform various selections based on the examples from the book, create stored procedures and functions, create a package, play around with triggers, try
using views and materialized views, understand what collections are, etc.
Also, when studying, I recommend using several IDEs for developing on Oracle PL / SQL, for example PL / SQL Developer, TOAD, DataGrip, although the latter is not often used, at least in my practice of working in different banks and in outsourcing.

Feuerstein S., Pribyl B.
F36 Oracle PL/SQL. For professionals. 6th ed. - St. Petersburg: Peter, 2015. - 1024 p.: ill. —
(The O'Reilly Bestsellers series).
This book is a definitive guide to PL/SQL, which is
a procedural language extension to SQL. It covers in detail the basics of PL/
SQL, program structure, the basic principles of working with program data,
and how to use operators and instructions to access relational databases. Much
attention is paid to security issues, the impact of object technologies on PL/SQL
, and the integration of PL/SQL with XML and Java.
Over the past decades, during which this book has been republished, it has become an indispensable
a guide to PL/SQL for hundreds of thousands of programmers, both beginners and professionals
. The sixth edition of the book has been completely updated for Oracle12c.

Answer 2

To learn pl / sql it would be nice to be able to read so that you can read the documentation.

Answer 3

yes, you can study it without knowledge at all

Answer 4

Step by step training in programming in one of the most popular and powerful DBMS - ORACLE . You will master not only the PL / SQL programming language
directly and learn how to use it correctly, avoiding mistakes, the understanding of which, as a rule, comes with experience, but also learn how to use most of the ORACLE tools to solve any problems caused both by the requirements of modern business and legacy code support. Here are video examples: Programming lessons in ORACLE for beginners. PL/SQL structure. Programming in PL/SQL (ORACLE) Lesson 2 Please visit our website - section LEARNING - Programming in PL/SQL. ORACLE and sign up for the course!