강의

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) 수강평 25개

강의소개.상단개요.수강생.short

난이도 초급

수강기한 무제한

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

먼저 경험한 수강생들의 후기

먼저 경험한 수강생들의 후기

4.9

5.0

kimhs2051

98% 수강 후 작성

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% 수강 후 작성

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% 수강 후 작성

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

강의상세_배울수있는것_타이틀

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

강의소개.콘텐츠.추천문구

학습 대상은 누구일까요?

  • 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

선수 지식, 필요할까요?

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

강의소개.지공자소개

2,239

수강생

86

수강평

78

답변

4.8

강의 평점

3

강의_other

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

더보기

커리큘럼

전체

50개 ∙ (강의상세_런타임_시간 강의상세_런타임_분)

해당 강의에서 제공: [object Object]
강의 게시일: 
마지막 업데이트일: 

수강평

전체

25개

4.9

25개의 수강평

  • suzdev334923님의 프로필 이미지
    suzdev334923

    수강평 1

    ∙

    평균 평점 5.0

    5

    100% 수강 후 작성

    • hyunop22426님의 프로필 이미지
      hyunop22426

      수강평 2

      ∙

      평균 평점 5.0

      5

      100% 수강 후 작성

      • herry1021님의 프로필 이미지
        herry1021

        수강평 19

        ∙

        평균 평점 4.9

        수정됨

        5

        100% 수강 후 작성

        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
          지식공유자

          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.

      • cjh7380님의 프로필 이미지
        cjh7380

        수강평 1

        ∙

        평균 평점 5.0

        5

        62% 수강 후 작성

        • kimhs20517712님의 프로필 이미지
          kimhs20517712

          수강평 1

          ∙

          평균 평점 5.0

          5

          98% 수강 후 작성

          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
            지식공유자

            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.

        itpaul님의 다른 강의

        지식공유자님의 다른 강의를 만나보세요!

        First Steps to ORACLE for DevelopersCourse Thumbnail

        First Steps to ORACLE for Developers

        itpaul

        Free

        Beginner / Oracle, DBMS/RDBMS, SQL

        4.8

        (39)

        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

        (39)

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

        Spring Boot Web Development Tutorial - Learn by Doing

        itpaul

        $68.20

        29%

        $48.40

        Basic / Spring Boot, Spring, MVC

        4.9

        (22)

        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

        29%

        $48.40

        Basic / Spring Boot, Spring, MVC

        4.9

        (22)

        200+

        비슷한 강의

        같은 분야의 다른 강의를 만나보세요!

        Complete Mastery of Practical SQL in 49 Sessions II - In-depth Course (Including Practice Materials and Problem Solving)Course Thumbnail

        Complete Mastery of Practical SQL in 49 Sessions II - In-depth Course (Including Practice Materials and Problem Solving)

        topdatastudio

        $68.20

        Basic / SQL, MSSQL

        4.8

        (5)

        'Complete Mastery of Practical SQL in 49 Sessions II - Advanced Course' follows the basic course. By using a practical database for learning, you can apply it right away in the field, and it is structured so that you can fully learn the learning content through theoretical explanations, practice, and solving a total of 200 application problems.

        Basic

        Basic

        SQL, MSSQL

        Complete Mastery of Practical SQL in 49 Sessions II - In-depth Course (Including Practice Materials and Problem Solving)Course Thumbnail

        Complete Mastery of Practical SQL in 49 Sessions II - In-depth Course (Including Practice Materials and Problem Solving)

        topdatastudio

        $68.20

        Basic / SQL, MSSQL

        4.8

        (5)

        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

        29%

        $41.80

        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

        29%

        $41.80

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

        4.2

        (54)

        600+
        [Web Development Full Stack Course] Learn Database Basics through Netflix and Carrot Market AnalysisCourse Thumbnail

        [Web Development Full Stack Course] Learn Database Basics through Netflix and Carrot Market Analysis

        realprogrammers

        Free

        Beginner / DBMS/RDBMS, MySQL, SQL

        5.0

        (19)

        2,700+

        This lecture is a lecture on database basics in the [Web Development Full Stack Course] lecture series for training full-stack web developers. This lecture is a process of understanding database design while analyzing Netflix and Carrot Market. It is a basic lecture where you can learn basic database design principles and SQL.

        Beginner

        Beginner

        DBMS/RDBMS, MySQL, SQL

        [Web Development Full Stack Course] Learn Database Basics through Netflix and Carrot Market AnalysisCourse Thumbnail

        [Web Development Full Stack Course] Learn Database Basics through Netflix and Carrot Market Analysis

        realprogrammers

        Free

        Beginner / DBMS/RDBMS, MySQL, SQL

        5.0

        (19)

        2,700+
        [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

        29%

        $24.20

        Basic / SQL, DBMS/RDBMS

        5.0

        (132)

        3,900+
        Active Replies
        Active Replies

        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

        29%

        $24.20

        Basic / SQL, DBMS/RDBMS

        5.0

        (132)

        3,900+
        Active Replies
        Active Replies
        MySQL Master Course for Data Analysts and IT Engineers!Course Thumbnail

        MySQL Master Course for Data Analysts and IT Engineers!

        moduai

        $15.40

        28%

        $11.00

        Basic / MySQL, SQL, Big Data, NoSQL, Tableau

        3.5

        (2)

        A must-have subject for aspiring developers and those looking to get a job in big data!!

        Basic

        Basic

        MySQL, SQL, Big Data

        MySQL Master Course for Data Analysts and IT Engineers!Course Thumbnail

        MySQL Master Course for Data Analysts and IT Engineers!

        moduai

        $15.40

        28%

        $11.00

        Basic / MySQL, SQL, Big Data, NoSQL, Tableau

        3.5

        (2)

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

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

        datarian

        $13.20

        25%

        $9.90

        Beginner / SQL, MySQL, Good for Gifting

        4.9

        (1,223)

        6,100+

        Inflearn cumulative students over 30,000, Datarian's SQL basics course with rich online/offline teaching experience. Learn SQL basic theory and solve 10 SQL problems together.

        Beginner

        Beginner

        SQL, MySQL, Good for Gifting

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

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

        datarian

        $13.20

        25%

        $9.90

        Beginner / SQL, MySQL, Good for Gifting

        4.9

        (1,223)

        6,100+
        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

        21%

        $39.60

        Beginner / Java, SQL, MySQL, MongoDB, database

        4.1

        (13)

        100+

        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

        21%

        $39.60

        Beginner / Java, SQL, MySQL, MongoDB, database

        4.1

        (13)

        100+
        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

        (50)

        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

        (50)

        1,500+
        Active Replies
        Active Replies
        DBT with a Silicon Valley EngineerCourse Thumbnail

        DBT with a Silicon Valley Engineer

        altoformula

        $34.10

        29%

        $24.20

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

        5.0

        (9)

        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

        29%

        $24.20

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

        5.0

        (9)

        300+
        Active Replies
        Active Replies
        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

        28%

        $49.50

        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

        28%

        $49.50

        Beginner / SQL, SQLD

        4.4

        (18)

        100+
        Active Replies
        Active Replies
        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

        24%

        $100.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

        24%

        $100.10

        Beginner / Java, JSP, Spring, SQL, oop

        High-Performance SQL for JPA (ORM) DevelopersCourse Thumbnail

        High-Performance SQL for JPA (ORM) Developers

        Vlad Mihalcea

        $176.00

        30%

        $123.20

        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

        30%

        $123.20

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

        4.9

        (31)

        600+
        Do it! SQL IntroductionCourse Thumbnail

        Do it! SQL Introduction

        easyspub

        Free

        Beginner / SQL

        4.6

        (55)

        2,900+

        A current database expert from a major global company generously shares 20 years of corporate practice and teaching experience!

        Beginner

        Beginner

        SQL

        Do it! SQL IntroductionCourse Thumbnail

        Do it! SQL Introduction

        easyspub

        Free

        Beginner / SQL

        4.6

        (55)

        2,900+

        강의상세.할인문구

        $8,517.00

        30%

        $77.00