Oracle PL/SQL Just This Much.. [Concept + Practice]

• There's a world of difference between knowing and not knowing Oracle PL/SQL!
• As you learn PL/SQL, you will experience how much easier your work becomes.

IT Latecomer Kim Bujang, who created this lecture, ✅

• I have been operating databases and handling large amounts of data in the field for over 20 years, mainly using Oracle PL/SQL.
• I think many people find the powerful language PL/SQL difficult, so I prepared this lecture with the intention of conveying the actual situation through hands-on practice.

Q. I know SQL, but do I really need to learn PL/SQL?

Public transportation is so good, do I really need a private car?
Of course, you can get the job done with just SQL, but PL/SQL gives SQL wings.

Q. I'm weak in SQL. Can I learn PL/SQL?

The basics of PL/SQL are SQL grammar. If you watch and follow each lecture, you will see that powerful PL/SQL can be created with just basic SQL.

Q. Don't you use PL/SQL a lot these days?

PL/SQL doesn't seem to be used much in recent SI development. However, PL/SQL is still used in many places as a powerful language. PL/SQL is useful not only for development but also for data verification and transfer (I absolutely use it!).

Q. What level of content is covered in the class?

This lecture is close to practical lecture. Therefore, it does not list all PL/SQL and lecture, but instead lectures at a level that can be used immediately in the field. If you have fully digested the lecture, you can find and use more when necessary.

Q. I am curious about the Oracle version and other tools used in class.

The lecture used Oracle 19C, 21C versions, but there is no problem if you follow the lecture with an older version. The tool used was SqlDeveloper. (※ PL/SQL grammar does not differ much depending on the Oracle version.)

• We provide students with a PDF document explaining the concepts for each section.
• Each class consists of approximately 5 minutes of concept and approximately 20 minutes of practice.
• This course starts at a level that covers Oracle SQL.
• If you do not have any Oracle experience, it would be better to take the free course first.
• If you have any questions about the content, we will answer them. (If necessary, we will produce and upload additional videos.)