inflearn logo
강의

Course

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) 27 reviews

350 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

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,250

Learners

90

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

27 reviews

4.9

27 reviews

  • suzdev334923님의 프로필 이미지
    suzdev334923

    Reviews 1

    ∙

    Average Rating 5.0

    5

    100% enrolled

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

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

    • hyunop22426님의 프로필 이미지
      hyunop22426

      Reviews 2

      ∙

      Average Rating 5.0

      5

      100% enrolled

      • cjh7380님의 프로필 이미지
        cjh7380

        Reviews 1

        ∙

        Average Rating 5.0

        5

        62% enrolled

        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

        (40)

        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

        (40)

        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)

        Oracle SQL Beginner's CourseCourse Thumbnail

        Oracle SQL Beginner's Course

        JeongTaeHyun

        $8.80

        Beginner / SQL, Oracle, DBMS/RDBMS

        3.3

        (24)

        200+

        This is an Oracle DBMS SQL course for beginners.

        Beginner

        Beginner

        SQL, Oracle, DBMS/RDBMS

        Oracle SQL Beginner's CourseCourse Thumbnail

        Oracle SQL Beginner's Course

        JeongTaeHyun

        $8.80

        Beginner / SQL, Oracle, DBMS/RDBMS

        3.3

        (24)

        200+
        [Practice Makes Perfect] Intermediate SQL for Data AnalysisCourse Thumbnail

        [Practice Makes Perfect] Intermediate SQL for Data Analysis

        datarian

        $29.70

        Basic / SQL

        4.9

        (966)

        5,400+

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

        Basic

        Basic

        SQL

        [Practice Makes Perfect] Intermediate SQL for Data AnalysisCourse Thumbnail

        [Practice Makes Perfect] Intermediate SQL for Data Analysis

        datarian

        $29.70

        Basic / SQL

        4.9

        (966)

        5,400+
        GCP BigQuery Tutorial for BeginnersCourse Thumbnail

        GCP BigQuery Tutorial for Beginners

        Sungmin Kim

        $35.20

        Beginner / SQL, Google Cloud Platform, bigquery, sql-query, database

        Let's learn together about Columnar Storage, which allows you to conveniently handle both structured and unstructured data provided by GCP and allows for a free table format, and BigQuery, a universal database.

        Beginner

        Beginner

        SQL, Google Cloud Platform, bigquery

        GCP BigQuery Tutorial for BeginnersCourse Thumbnail

        GCP BigQuery Tutorial for Beginners

        Sungmin Kim

        $35.20

        Beginner / SQL, Google Cloud Platform, bigquery, sql-query, database

        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+
        [SQL Quest] Strengthen your SQL skills by solving real-world problems (Basic)Course Thumbnail

        [SQL Quest] Strengthen your SQL skills by solving real-world problems (Basic)

        WHIZ

        $26.40

        Basic / SQL, sql-query, bigquery, Data literacy

        5.0

        (4)

        This course will solidify the basics of SQL through various problems that can be encountered in the actual IT industry. Solve the problem-solving quests, take the first step toward data analysis, and strengthen your SQL skills that can be applied in real life!

        Basic

        Basic

        SQL, sql-query, bigquery

        [SQL Quest] Strengthen your SQL skills by solving real-world problems (Basic)Course Thumbnail

        [SQL Quest] Strengthen your SQL skills by solving real-world problems (Basic)

        WHIZ

        $26.40

        Basic / SQL, sql-query, bigquery, Data literacy

        5.0

        (4)

        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

        (31)

        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

        (31)

        600+
        DBT with a Silicon Valley EngineerCourse Thumbnail

        DBT with a Silicon Valley Engineer

        altoformula

        $34.10

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

        4.8

        (12)

        300+

        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

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

        4.8

        (12)

        300+
        FastAPI Complete GuideCourse Thumbnail

        FastAPI Complete Guide

        dooleyz3525

        $59.40

        29%

        $41.80

        Intermediate / Python, FastAPI, SQL, SQLAlchemy

        4.9

        (68)

        800+
        Active Replies
        Active Replies

        This course is designed to help you learn the core functions of FastAPI, as well as the entire process of web service development. Through this course, we will help you become a FastAPI expert developer needed in the field.

        Intermediate

        Intermediate

        Python, FastAPI, SQL

        FastAPI Complete GuideCourse Thumbnail

        FastAPI Complete Guide

        dooleyz3525

        $59.40

        29%

        $41.80

        Intermediate / Python, FastAPI, SQL, SQLAlchemy

        4.9

        (68)

        800+
        Active Replies
        Active Replies
        [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

        5.0

        (132)

        3,900+

        This course teaches MS-SQL through baseball/company 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

        5.0

        (132)

        3,900+
        Complete Mastery Bootcamp from Java Fundamentals to Oracle SQL [Full vers.]Course Thumbnail

        Complete Mastery Bootcamp from Java Fundamentals to Oracle SQL [Full vers.]

        youngcodikimssam

        $133.10

        Beginner / Java, JSP, Spring, SQL, oop

        From Java basics to advanced concepts, and Oracle SQL too, Backend web development series with hands-on practice, taught by star instructor Young Cody Kim who explains clearly for non-majors and coding beginners

        Beginner

        Beginner

        Java, JSP, Spring

        Complete Mastery Bootcamp from Java Fundamentals to Oracle SQL [Full vers.]Course Thumbnail

        Complete Mastery Bootcamp from Java Fundamentals to Oracle SQL [Full vers.]

        youngcodikimssam

        $133.10

        Beginner / Java, JSP, Spring, SQL, oop

        SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questionsCourse Thumbnail

        SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questions

        Masocampus

        $69.30

        23%

        $52.80

        Beginner / SQL, SQLD

        4.4

        (18)

        100+
        Active Replies
        Active Replies

        From understanding SQL to using actual functions, Complete preparation for SQLD certification with the latest past exam questions!

        Beginner

        Beginner

        SQL, SQLD

        SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questionsCourse Thumbnail

        SQLD 2-week surefire way to pass: ultra-short-term strategy with the latest revised version of past exam questions

        Masocampus

        $69.30

        23%

        $52.80

        Beginner / SQL, SQLD

        4.4

        (18)

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

        SQL data analysis learned through various cases

        dooleyz3525

        $68.20

        29%

        $48.40

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

        4.9

        (52)

        1,500+
        Active Replies
        Active Replies

        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

        29%

        $48.40

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

        4.9

        (52)

        1,500+
        Active Replies
        Active Replies

        $77.00