강의

멘토링

로드맵

Programming

/

Database

[SQL Automation] PL/SQL for Immediate Practical Use

Author's direct lecture for the SQL200je (PL/SQL) book, published by 정보문화사! This PL/SQL course is by Oracle instructor Yooyeonsu, who has trained countless DBAs and PL/SQL developers. After taking the lecture, you will clearly feel the difference between before and after using PL/SQL.

(5.0) 1 reviews

39 learners

  • codingkorea
실습 중심
데이터분석실습
PL/SQL
SQL
RPA
dba

What you will learn!

  • You can automate SQL using PL/SQL.

  • You can automate data search tasks using PL/SQL.

  • Learn how PL/SQL is utilized by Korean conglomerates.


What is PL/SQL?

Oracle PL/SQL is the programming language used in the Oracle database.
PL/SQL
is an abbreviation for Procedural Language/Structured Query Language, and is a procedural programming language.

It combines the features of query languages.
This language is based on SQL statements and adds programming elements to provide powerful database-based operations.

Allows you to implement business logic.

Regarding PL/SQL
What Instructor Yoo Yeon-su Wants to Tell You

After learning SQL, I felt a gentle pleasure in searching data with my own hands.
However, when working with SQL, you will experience monotonous tasks repeated every day.
Automating these repetitive, simple tasks is why we use PL/SQL.
PL/
SQL allows me to program, which allows me to put my own creative thinking into SQL.
Learning PL/ SQL will be more fun than just knowing SQL.



This is the employment or job change status of students who took Professor Yoo Yeon-su's PL/SQL class.


Source: https://cafe.daum.net/oracleoracle/SDMs/441

It is constantly being updated.


Lecture Contents:

1. Setting up a PL/SQL development environment

2. Why you should learn PL/SQL

3. Understanding PL/SQL Variables

4. Functions used in PL/SQL

5. Understanding PL/SQL blocks

6. How to write DML statements in PL/SQL

7. If and loop statements in PL/SQL

8. Double loop statement in PL/SQL

9. Debugging Code Using Labels

10. PL/SQL record combination variable

11. PL/SQL Cursor Statement

12. Cursor statement using subquery

13. Exception handling in PL/SQL

14. Using exception trap functions

15. Procedures in PL/SQL

16. Functions in PL/SQL

17. Composite Variables in PL/SQL Records and Collections

18. Improving DML statement performance in PL/SQL

19. Improving FOR loop performance in PL/SQL

20. Improving PL/SQL Procedure Performance

21. Creating SQL Automation Scripts1

22. Creating SQL Automation Scripts2

23. Creating SQL Automation Scripts3

24. Creating SQL Automation Scripts4

25. Writing PL/SQL code using ChatGPT


You can learn SQL by mastering the following 4-step skills. This subject is the 2nd step of the two.



Recommended for
these people

Who is this course right for?

  • I recommend it to those who want to automate SQL.

  • Recommended for those who want to write SQL simply using PL/SQL.

  • Recommended for those curious how domestic large companies utilize PL/SQL.

Need to know before starting?

  • It's good to know a bit about SQL.

Hello
This is

222

Learners

31

Reviews

29

Answers

4.9

Rating

3

Courses

여러분들을 도와드릴 튜터입니다.

  • 20년 넘는 현업 경험과 강의 경력의 데이터 분석가 과정 튜터

  • SQL200제 책의 저자 - 정보문화사

  • 예제가 가득한 파이썬 길라잡이의 저자 - 정보문화사

  • 유튜브 코딩 대한민국 판다스 100제 유튜버

     

     

사랑하는 19기 데이터 분석반 학생들의 밝은 미래를 진심으로 응원합니다.

Curriculum

All

25 lectures ∙ (12hr 9min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

1 reviews

5.0

1 reviews

  • dooll816482님의 프로필 이미지
    dooll816482

    Reviews 2

    Average Rating 5.0

    5

    16% enrolled

    Giọng nói của thầy cũng rất hay và thầy giải thích rất dễ hiểu. Cảm ơn thầy đã có những bài giảng hay.

    • codingkorea
      Instructor

      Cảm ơn bạn rất nhiều. ^^

$26.40

codingkorea's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!