inflearn logo
강의

Course

Instructor
inflearn logo
BEST
Programming

/

Database

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

This course provides developers/operators using Oracle with PL/SQL concepts and practical skills that can be immediately applied in the field.

(4.9) 28 reviews

355 learners

Level Basic

Course period Unlimited

PL/SQL
PL/SQL
SQL
SQL
Oracle
Oracle
PL/SQL
PL/SQL
SQL
SQL
Oracle
Oracle

Reviews from Early Learners

4.9

5.0

kimhs2051

98% enrolled

Hello, boss, I have been watching you since your YouTube channel, and this time I am using PL/SQL at the place I am going to, and I think I am gaining some confidence. The quality of the lectures is really practical, so I am very happy. If you upload more lectures in the future, I will trust you and want to pay right away. Thank you so much for making such a great lecture.

5.0

Idea

100% enrolled

I found out that my new workplace uses PL/SQL, so I hurriedly took this course. I usually refer to reviews a lot before choosing a course, and I learned that the instructor's course was well-structured with practical content that could be completed in a short period, which led me to decide to take it. Now that I've finished the course, I feel confident that I can handle PL/SQL-related tasks at work without major issues 😊😊 Thank you so much for teaching content that's frequently used in actual work. I highly recommend this to anyone like me who needs to quickly learn PL/SQL and apply it to their work!

5.0

junhui0386

36% enrolled

The lecture materials and the sections in the lecture are not synchronized. For example, the lecture material says "#Section3 [Practice] PL/SQL Just This Much," but the lecture is classified as "Section 4."

What you will gain after the course

  • PL/SQL Basic Syntax

  • PL/SQL like practice through scenarios

  • PL/SQL that can be used in operations.

PL/SQL that will give wings to Oracle DBMS!

Only the concepts necessary for practical use
Oracle PL/SQL

  • 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.

Do you often use simple SQL through DB, but are you worried about how to develop/verify complex work requests?
PL/SQL may be a good solution for these people.

I recommend this to these people

Oracle DBMS based computer operator

Newbies/Juniors who need to learn PL/SQL

Oracle DBMS based developer

Developers/operators who want to learn PL/SQL for real-world situations rather than simple concepts

  • You can see yourself creating PL/SQL statements from the things you were previously concerned about.
  • Create your own scripts in PL/SQL and you'll have a powerful weapon of your own that you can pull out whenever you need it.
  • You can easily handle tasks that are difficult to solve with applications by writing them in PL/SQL syntax.

What you'll learn 📚

  • It doesn't simply explain some concept.
  • Create scenarios using actual DB configurations and learn concepts through practice.
  • Through practice, you will understand each concept by comparing it to other concepts.
  • We will briefly cover the theory and concepts in advance and then move straight into practice.
  • Of course, if you are currently working with Oracle, you are all set! (You can skip the concept)

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&A 💬

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.)

📢 Please note before taking the class

  • 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.)

Recommended for
these people

Who is this course right for?

  • Operator who operates the system through Oracle DBMS

  • Newcomers/juniors who need to learn PL/SQL

  • Developers who develop based on Oracle DBMS

  • Developers/operators who want to study in an environment like the real world, not with fragmentary knowledge

Need to know before starting?

  • Although it covers basic content, you can understand the content more easily if you have an understanding of Oracle and SQL.

  • Please take the free course "ORACLE Introduction for Developers: First Steps" first.

Hello
This is itpaul

2,296

Learners

92

Reviews

78

Answers

4.8

Rating

3

Courses

I have been working in the IT field for a long time.

IT seems to be a field that requires diligence, as one must stay sensitive to development trends.

I am also still continuously studying.

I hope that my modest knowledge can be of help to someone else.

e-mail : good.dhkim@gmail.com

More

Curriculum

All

50 lectures ∙ (9hr 48min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

28 reviews

4.9

28 reviews

  • junhui03869379님의 프로필 이미지
    junhui03869379

    Reviews 4

    ∙

    Average Rating 5.0

    5

    36% enrolled

    The lecture materials and the sections in the lecture are not synchronized. For example, the lecture material says "#Section3 [Practice] PL/SQL Just This Much," but the lecture is classified as "Section 4."

    • itpaul
      Instructor

      Hello, and thank you for your feedback. I have checked the part you mentioned. As I was preparing the lecture, I made adjustments along the way, and it seems the numbers in the title and the video sequence don't match. I will check and correct it. I hope you gain good insights through the lecture. Have a great day!

  • kimhs20517712님의 프로필 이미지
    kimhs20517712

    Reviews 1

    ∙

    Average Rating 5.0

    5

    98% enrolled

    Hello, boss, I have been watching you since your YouTube channel, and this time I am using PL/SQL at the place I am going to, and I think I am gaining some confidence. The quality of the lectures is really practical, so I am very happy. If you upload more lectures in the future, I will trust you and want to pay right away. Thank you so much for making such a great lecture.

    • itpaul
      Instructor

      Yes, the concept is important, but I tried to make it so that it can be used in actual practice. I think that even if you go to the place where you entered, you will probably be able to do more than the basics with this level of content. Thank you.

  • dlcksal936661님의 프로필 이미지
    dlcksal936661

    Reviews 1

    ∙

    Average Rating 5.0

    5

    100% enrolled

    I understand it all now!

    • itpaul
      Instructor

      I'm glad you understood it well. I think it will be of great help in your work. Thank you for taking the class and leaving a review.

  • herry1021님의 프로필 이미지
    herry1021

    Reviews 19

    ∙

    Average Rating 4.9

    Edited

    5

    100% enrolled

    I found out that my new workplace uses PL/SQL, so I hurriedly took this course. I usually refer to reviews a lot before choosing a course, and I learned that the instructor's course was well-structured with practical content that could be completed in a short period, which led me to decide to take it. Now that I've finished the course, I feel confident that I can handle PL/SQL-related tasks at work without major issues 😊😊 Thank you so much for teaching content that's frequently used in actual work. I highly recommend this to anyone like me who needs to quickly learn PL/SQL and apply it to their work!

    • itpaul
      Instructor

      This is a review that makes me think about several things at the end of the year. Since I'm still working in the field, I believe I have a good understanding of how Oracle is actually used in real-world settings. Among those areas, PL/SQL is not a common domain. It seems difficult to get practical help by learning only from books. If you've gained confidence in practical work through my course, I think you probably won't have any difficulties in your future tasks. I sincerely appreciate this review that motivates me in many ways.

  • brucehan님의 프로필 이미지
    brucehan

    Reviews 90

    ∙

    Average Rating 4.4

    5

    100% enrolled

    It was very helpful to have PL/SQL explained based on practical experience. It's the best. The environment I'm in also deals with a lot of SQL and PL/SQL, so I've been wondering when to study PL/SQL. I just searched the web and played around with it. The tips the instructor gave are actually a little different from my environment. The parts I use are a little different. But I can see parts that I can use someday! It was nice to be able to learn by following them. I gained a lot of insight. By the way, it's not common for a senior to share knowledge like this, and I'm grateful and will follow suit, especially for scratching an itchy area like PL/SQL compared to Java and the cloud. Below are the parts that I personally found helpful, written as I remember them. - bulk insert into & forall - collection - How to create procedures & functions - Basic principles of PL/SQL such as blocks - How to create dummy data - Data migration (this was really helpful) - Scheduler (I also gained a lot of insight from this) Thank you.

    • itpaul
      Instructor

      Thank you for your valuable review. In fact, I made this course with my best effort because I didn't want to let such a good language as PL/SQL go to waste, and I'm so glad that it's helping someone. As I always think, the legacy we have is still valid even in the AI era. I hope you will grow steadily in your position.

itpaul's other courses

Check out other courses by the instructor!

First Steps to ORACLE for DevelopersCourse Thumbnail

First Steps to ORACLE for Developers

itpaul

Free

Beginner / Oracle, DBMS/RDBMS, SQL

4.8

(41)

1,600+

This is a guide course for beginners who are taking their first steps into Oracle. We will teach you the basics of user creation, table creation, and queries.

Beginner

Beginner

Oracle, DBMS/RDBMS, SQL

First Steps to ORACLE for DevelopersCourse Thumbnail

First Steps to ORACLE for Developers

itpaul

Free

Beginner / Oracle, DBMS/RDBMS, SQL

4.8

(41)

1,600+
Spring Boot Web Development Tutorial - Learn by DoingCourse Thumbnail

Spring Boot Web Development Tutorial - Learn by Doing

itpaul

$68.20

Basic / Spring Boot, Spring, MVC

4.8

(23)

200+

Java web development using Spring Boot, which you will learn in no time as you follow along!

Basic

Basic

Spring Boot, Spring, MVC

Spring Boot Web Development Tutorial - Learn by DoingCourse Thumbnail

Spring Boot Web Development Tutorial - Learn by Doing

itpaul

$68.20

Basic / Spring Boot, Spring, MVC

4.8

(23)

200+

Similar courses

Explore other courses in the same field!

[SQL Automation] Practical PL/SQL for Immediate Use at WorkCourse Thumbnail

[SQL Automation] Practical PL/SQL for Immediate Use at Work

codingkorea

$26.40

Beginner / PL/SQL, SQL, RPA, dba

5.0

(2)

A lecture directly taught by the author of the SQL 200 Questions book (PL/SQL) published by Jeongbo Munhwasa! This is a PL/SQL lecture by Oracle instructor Yoo Yeon-soo, who has trained numerous DBAs and PL/SQL developers. After taking this course, you will clearly feel the difference between before and after using PL/SQL.

Beginner

Beginner

PL/SQL, SQL, RPA

[SQL Automation] Practical PL/SQL for Immediate Use at WorkCourse Thumbnail

[SQL Automation] Practical PL/SQL for Immediate Use at Work

codingkorea

$26.40

Beginner / PL/SQL, SQL, RPA, dba

5.0

(2)

Jaeseong Yoon's Oracle SQL Database 11g PL/SQL DeveloperCourse Thumbnail

Jaeseong Yoon's Oracle SQL Database 11g PL/SQL Developer

softcampus

$8.80

Basic / SQL, Oracle, PL/SQL, DBMS/RDBMS

4.6

(115)

1,100+

Easy explanations and examples are provided so that you can apply them directly to your work.

Basic

Basic

SQL, Oracle, PL/SQL

Jaeseong Yoon's Oracle SQL Database 11g PL/SQL DeveloperCourse Thumbnail

Jaeseong Yoon's Oracle SQL Database 11g PL/SQL Developer

softcampus

$8.80

Basic / SQL, Oracle, PL/SQL, DBMS/RDBMS

4.6

(115)

1,100+
[ITⓔCoaching] Practical Data Management with OracleCourse Thumbnail

[ITⓔCoaching] Practical Data Management with Oracle

ubob

$84.70

Beginner / Oracle, SQL, DBMS/RDBMS

5.0

(2)

Extract and utilize data through Oracle 18c and become a database expert!

Beginner

Beginner

Oracle, SQL, DBMS/RDBMS

[ITⓔCoaching] Practical Data Management with OracleCourse Thumbnail

[ITⓔCoaching] Practical Data Management with Oracle

ubob

$84.70

Beginner / Oracle, SQL, DBMS/RDBMS

5.0

(2)

[The concept is easy~, the practice is intense] SQL data analysis, utilization!Course Thumbnail

[The concept is easy~, the practice is intense] SQL data analysis, utilization!

hongpark

$27.50

Basic / SQL, PostgreSQL, DBMS/RDBMS

4.8

(26)

500+

SQL data analysis! We will teach you how to solve practical problems that are applicable in the field, quickly and easily!

Basic

Basic

SQL, PostgreSQL, DBMS/RDBMS

[The concept is easy~, the practice is intense] SQL data analysis, utilization!Course Thumbnail

[The concept is easy~, the practice is intense] SQL data analysis, utilization!

hongpark

$27.50

Basic / SQL, PostgreSQL, DBMS/RDBMS

4.8

(26)

500+
[MMORPG Game Development Series with C# and Unity] Part 5: DatabaseCourse Thumbnail

[MMORPG Game Development Series with C# and Unity] Part 5: Database

Rookiss

$34.10

Basic / SQL, DBMS/RDBMS

4.9

(137)

3,900+
Active Replies
Active Replies

This is a course for learning MS-SQL through baseball and corporate databases.

Basic

Basic

SQL, DBMS/RDBMS

[MMORPG Game Development Series with C# and Unity] Part 5: DatabaseCourse Thumbnail

[MMORPG Game Development Series with C# and Unity] Part 5: Database

Rookiss

$34.10

Basic / SQL, DBMS/RDBMS

4.9

(137)

3,900+
Active Replies
Active Replies
Winning Strategy to Pass SQLD in Just 2 Weeks: Ultra-Short-Term Strategy with Latest Revised Exam QuestionsCourse Thumbnail

Winning Strategy to Pass SQLD in Just 2 Weeks: Ultra-Short-Term Strategy with Latest Revised Exam Questions

Masocampus

$69.30

Beginner / SQL, SQLD

4.4

(18)

200+

Perfect preparation for the SQLD certification, from understanding SQL to practical function application, finishing with the latest exam questions!

Beginner

Beginner

SQL, SQLD

Winning Strategy to Pass SQLD in Just 2 Weeks: Ultra-Short-Term Strategy with Latest Revised Exam QuestionsCourse Thumbnail

Winning Strategy to Pass SQLD in Just 2 Weeks: Ultra-Short-Term Strategy with Latest Revised Exam Questions

Masocampus

$69.30

Beginner / SQL, SQLD

4.4

(18)

200+
[A hundred words are not as good as seeing once] Advanced SQL for data analysisCourse Thumbnail

[A hundred words are not as good as seeing once] Advanced SQL for data analysis

datarian

$42.90

Intermediate / SQL

4.8

(339)

3,500+

Inflearn cumulative students of over 30,000, Datarian's advanced SQL course with extensive online/offline teaching experience. Learn advanced SQL theory and solve 25 practice problems together.

Intermediate

Intermediate

SQL

[A hundred words are not as good as seeing once] Advanced SQL for data analysisCourse Thumbnail

[A hundred words are not as good as seeing once] Advanced SQL for data analysis

datarian

$42.90

Intermediate / SQL

4.8

(339)

3,500+
Mastering Java from "Standard of Java" to Oracle SQL Bootcamp [Full vers.]Course Thumbnail

Mastering Java from "Standard of Java" to Oracle SQL Bootcamp [Full vers.]

youngcodikimssam

$133.10

24%

$100.10

Beginner / Java, JSP, Spring, SQL, oop

From Java basics to advanced levels and Oracle SQL, this is a backend web development series where you learn through hands-on practice with star instructor Young-Cody Kim, who makes coding easy to understand even for non-majors and beginners.

Beginner

Beginner

Java, JSP, Spring

Mastering Java from "Standard of Java" to Oracle SQL Bootcamp [Full vers.]Course Thumbnail

Mastering Java from "Standard of Java" to Oracle SQL Bootcamp [Full vers.]

youngcodikimssam

$133.10

24%

$100.10

Beginner / Java, JSP, Spring, SQL, oop

3. Web Development Course [Spring Framework + e-Government Standard Framework]Course Thumbnail

3. Web Development Course [Spring Framework + e-Government Standard Framework]

vmproductor0202

$59.40

Beginner / Spring, eGovFrame, spring-framework, Oracle, Java

4.2

(54)

600+

This is a lecture using the only domestic e-government framework and Layered Architecture, which are widely used in practice but not available in Korea. In this lecture, we will learn how to build the backend and server side of web development using the Spring Framework and the e-government standard framework.

Beginner

Beginner

Spring, eGovFrame, spring-framework

3. Web Development Course [Spring Framework + e-Government Standard Framework]Course Thumbnail

3. Web Development Course [Spring Framework + e-Government Standard Framework]

vmproductor0202

$59.40

Beginner / Spring, eGovFrame, spring-framework, Oracle, Java

4.2

(54)

600+
The Easiest and Most In-Depth MongoDB Complete Guide [ By. Non-CS Major & Kakao Developer ]Course Thumbnail

The Easiest and Most In-Depth MongoDB Complete Guide [ By. Non-CS Major & Kakao Developer ]

Hong

$50.60

Beginner / Java, SQL, MySQL, MongoDB, database

4.1

(14)

100+
Active Replies
Active Replies

This course is a master class that systematically covers the fundamental principles and practical applications of MongoDB. Starting with core MongoDB concepts, you will systematically learn essential topics for practical work, such as database design, CRUD operations, indexing, aggregation pipelines, performance optimization, transactions, and security. It explains topics step-by-step so even beginners can understand, and you can deeply learn the working principles of MongoDB through exercises and examples. This is the best introductory and practical course for developers who want to build strong MongoDB skills for practical work.

Beginner

Beginner

Java, SQL, MySQL

The Easiest and Most In-Depth MongoDB Complete Guide [ By. Non-CS Major & Kakao Developer ]Course Thumbnail

The Easiest and Most In-Depth MongoDB Complete Guide [ By. Non-CS Major & Kakao Developer ]

Hong

$50.60

Beginner / Java, SQL, MySQL, MongoDB, database

4.1

(14)

100+
Active Replies
Active Replies
High-Performance SQL for JPA (ORM) DevelopersCourse Thumbnail

High-Performance SQL for JPA (ORM) Developers

Vlad Mihalcea

$176.00

Intermediate / SQL, performance-tuning, sql-query, DBMS/RDBMS

4.9

(32)

600+

Make the most of relational database systems!

Intermediate

Intermediate

SQL, performance-tuning, sql-query

High-Performance SQL for JPA (ORM) DevelopersCourse Thumbnail

High-Performance SQL for JPA (ORM) Developers

Vlad Mihalcea

$176.00

Intermediate / SQL, performance-tuning, sql-query, DBMS/RDBMS

4.9

(32)

600+
DBT with a Silicon Valley EngineerCourse Thumbnail

DBT with a Silicon Valley Engineer

altoformula

$34.10

22%

$26.40

Basic / SQL, Data Engineering, data-analysis, dbt, Data literacy

4.8

(17)

300+
Active Replies
Active Replies

Learn how modern data teams leverage dbt. Build maintainable analytics models and validated data pipelines hands-on. Master core concepts of analytics engineering with a practical focus. This course is for those who want to take their data career to the next level 🚀

Basic

Basic

SQL, Data Engineering, data-analysis

DBT with a Silicon Valley EngineerCourse Thumbnail

DBT with a Silicon Valley Engineer

altoformula

$34.10

22%

$26.40

Basic / SQL, Data Engineering, data-analysis, dbt, Data literacy

4.8

(17)

300+
Active Replies
Active Replies
SQL data analysis learned through various casesCourse Thumbnail

SQL data analysis learned through various cases

dooleyz3525

$68.20

Intermediate / SQL, PostgreSQL, DBMS/RDBMS, Data Engineering, data-analysis

4.9

(54)

1,600+

By implementing various practical data analysis cases using SQL, you can simultaneously improve your data analysis and SQL utilization skills.

Intermediate

Intermediate

SQL, PostgreSQL, DBMS/RDBMS

SQL data analysis learned through various casesCourse Thumbnail

SQL data analysis learned through various cases

dooleyz3525

$68.20

Intermediate / SQL, PostgreSQL, DBMS/RDBMS, Data Engineering, data-analysis

4.9

(54)

1,600+
PostgreSQL from a Silicon Valley AI Developer Handling 200++ Billion Data RecordsCourse Thumbnail

PostgreSQL from a Silicon Valley AI Developer Handling 200++ Billion Data Records

Hong

$117.70

Early Bird

59%

$47.30

Beginner / MySQL, PostgreSQL, Oracle, DBMS/RDBMS, database

4.7

(6)

200+
New
New
Active Replies
Active Replies

This course goes beyond simple CRUD-level database usage to help you acquire PostgreSQL skills necessary for the AI era from a practical perspective. Based on AI development experience in Silicon Valley, you will learn step-by-step how to design and utilize JSON, indexes, transactions, and even pgvector in real-world services, while mastering methods to solve complex data structures and performance issues.

Beginner

Beginner

MySQL, PostgreSQL, Oracle

PostgreSQL from a Silicon Valley AI Developer Handling 200++ Billion Data RecordsCourse Thumbnail

PostgreSQL from a Silicon Valley AI Developer Handling 200++ Billion Data Records

Hong

$117.70

Early Bird

59%

$47.30

Beginner / MySQL, PostgreSQL, Oracle, DBMS/RDBMS, database

4.7

(6)

200+
New
New
Active Replies
Active Replies

25% off for new members

$57.00

25%

$77.00