강의

N
챌린지

멘토링

N
클립

커뮤니티

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

338 learners

  • itpaul
plsql
오라클DB관련
dbms
PL/SQL
SQL
Oracle

Reviews from Early Learners

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

2,195

Learners

82

Reviews

78

Answers

4.8

Rating

3

Courses

IT 에 오랜시간 몸담고 있습니다.

IT 는 개발 트렌드에도 민감해야 하는 부지런함이 필요한 직군인것 같습니다.

저도 여전히 지속적으로 공부하고 있습니다.

제가 가진 소소한 지식이 또 다른 누군가에게 도움이 되면 좋겠습니다. 

e-mail : good.dhkim@gmail.com

Curriculum

All

50 lectures ∙ (9hr 48min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

24 reviews

4.9

24 reviews

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

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

  • suzdev334923님의 프로필 이미지
    suzdev334923

    Reviews 1

    ∙

    Average Rating 5.0

    5

    100% enrolled

    • cjh7380님의 프로필 이미지
      cjh7380

      Reviews 1

      ∙

      Average Rating 5.0

      5

      62% enrolled

      • knh03131961님의 프로필 이미지
        knh03131961

        Reviews 1

        ∙

        Average Rating 4.0

        4

        100% enrolled

        It was good because it was detailed and practice-oriented.

        Limited time deal

        $53.90

        30%

        $77.00

        itpaul's other courses

        Check out other courses by the instructor!

        Spring Boot Web Development Tutorial - Learn by Doing강의 썸네일

        Spring Boot Web Development Tutorial - Learn by Doing

        itpaul

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

        초급

        초급

        Spring Boot, Spring, MVC

        Spring Boot Web Development Tutorial - Learn by Doing강의 썸네일

        Spring Boot Web Development Tutorial - Learn by Doing

        itpaul

        First Steps to ORACLE for Developers강의 썸네일

        First Steps to ORACLE for Developers

        itpaul

        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.

        입문

        입문

        Oracle, DBMS/RDBMS, SQL

        First Steps to ORACLE for Developers강의 썸네일

        First Steps to ORACLE for Developers

        itpaul

        Similar courses

        Explore other courses in the same field!

        [Oracle SQL: From Beginner to Expert] Learning Database with Practical Examples강의 썸네일

        [Oracle SQL: From Beginner to Expert] Learning Database with Practical Examples

        youngcodikimssam

        Starting from elementary school coding education to high school students in IT software departments, computer science college students, and job seekers from non-technical backgrounds, you can now meet the easy and fun coding lectures of Young Cody Kim, a current star instructor who has dedicated over 15 years to coding education, not only offline but also online. With Young Cody Kim, who has produced over 500 frontend, backend, full-stack, and web developers, your dream of becoming a developer will soon become reality!

        입문

        입문

        SQL, Oracle, DBMS/RDBMS

        [Oracle SQL: From Beginner to Expert] Learning Database with Practical Examples강의 썸네일

        [Oracle SQL: From Beginner to Expert] Learning Database with Practical Examples

        youngcodikimssam

        Jaeseong Yoon's Oracle SQL Database 11g PL/SQL Developer강의 썸네일

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

        softcampus

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

        초급

        초급

        SQL, Oracle, PL/SQL

        Jaeseong Yoon's Oracle SQL Database 11g PL/SQL Developer강의 썸네일

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

        softcampus

        [MMORPG Game Development Series with C# and Unity] Part 5: Database강의 썸네일

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

        Rookiss

        This course teaches MS-SQL through baseball/company databases.

        초급

        초급

        SQL, DBMS/RDBMS

        [MMORPG Game Development Series with C# and Unity] Part 5: Database강의 썸네일

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

        Rookiss

        [ITⓔCoaching] Practical Data Management with Oracle강의 썸네일

        [ITⓔCoaching] Practical Data Management with Oracle

        ubob

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

        입문

        입문

        Oracle, SQL, DBMS/RDBMS

        [ITⓔCoaching] Practical Data Management with Oracle강의 썸네일

        [ITⓔCoaching] Practical Data Management with Oracle

        ubob

        [Concept Class] Learn and Use SQL Queries Right Away강의 썸네일

        [Concept Class] Learn and Use SQL Queries Right Away

        breachers

        You will be able to extract the data you want directly without the help of a developer. We will provide everything you need for analysis, from simple queries to joins. Start learning SQL with a direct lecture from the author of the book <Planner's SQL>.

        입문

        입문

        SQL

        [Concept Class] Learn and Use SQL Queries Right Away강의 썸네일

        [Concept Class] Learn and Use SQL Queries Right Away

        breachers

        Easy to understand, SQL secret recipe for everyone강의 썸네일

        Easy to understand, SQL secret recipe for everyone

        mktcrmer8678

        A beginner's guide to SQL coding! We'll teach you the secrets of writing, interpreting, and validating SQL.

        초급

        초급

        SQL, Big Data, Data Engineering

        Easy to understand, SQL secret recipe for everyone강의 썸네일

        Easy to understand, SQL secret recipe for everyone

        mktcrmer8678

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

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

        Masocampus

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

        입문

        입문

        SQL, SQLD

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

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

        Masocampus

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

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

        Hong

        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.

        입문

        입문

        Java, SQL, MySQL

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

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

        Hong

        3. Web Development Course [Spring Framework + e-Government Standard Framework]강의 썸네일

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

        vmproductor0202

        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.

        입문

        입문

        Spring, eGovFrame, spring-framework

        3. Web Development Course [Spring Framework + e-Government Standard Framework]강의 썸네일

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

        vmproductor0202

        FastAPI Complete Guide강의 썸네일

        FastAPI Complete Guide

        dooleyz3525

        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.

        중급이상

        중급이상

        Python, FastAPI, SQL

        FastAPI Complete Guide강의 썸네일

        FastAPI Complete Guide

        dooleyz3525

        Complete Mastery Bootcamp from Java Fundamentals to Oracle SQL [Full vers.]강의 썸네일

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

        youngcodikimssam

        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

        입문

        입문

        Java, JSP, Spring

        Complete Mastery Bootcamp from Java Fundamentals to Oracle SQL [Full vers.]강의 썸네일

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

        youngcodikimssam

        SQL data analysis learned through various cases강의 썸네일

        SQL data analysis learned through various cases

        dooleyz3525

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

        중급이상

        중급이상

        SQL, PostgreSQL, DBMS/RDBMS

        SQL data analysis learned through various cases강의 썸네일

        SQL data analysis learned through various cases

        dooleyz3525