실무에서 바로 쓰는 SQL튜닝 45가지
코딩 대한민국
30년 경력 DBA 강사가 실무에서 바로 적용 가능한 SQL 튜닝 핵심 기법 45가지를 실전 예제로 알려드립니다. 실행계획 분석부터 인덱스 최적화, 조인 튜닝까지 느린 쿼리를 10배 빠르게 만드는 실무 노하우를 습득하세요!
Basic
SQL, Oracle, 데이터 엔지니어링
[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.
What you will gain after the course
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.
341
Learners
38
Reviews
40
Answers
4.9
Rating
4
Courses
여러분들을 도와드릴 튜터입니다.
20년 넘는 현업 경험과 강의 경력의 데이터 분석가 과정 튜터
SQL200제 책의 저자 - 정보문화사
예제가 가득한 파이썬 길라잡이의 저자 - 정보문화사
유튜브 코딩 대한민국 판다스 100제 유튜버
사랑하는 19기 데이터 분석반 학생들의 밝은 미래를 진심으로 응원합니다.
Curriculum
All
25 lectures ∙ (12hr 9min)
Course Materials:
Lecture resources
4. PL/SQL Functions
29:46
Published:
Last updated:
$26.40
codingkorea's other courses
Check out other courses by the instructor!
![[2025년 최신 기출 반영] 빅데이터 분석 기사 실기 시험 100% 합격 ! 기출 문제의 패턴이 보인다 !Course Thumbnail](https://cdn.inflearn.com/public/courses/335192/cover/99e36628-6e8d-4403-bfe3-7f5d5844aa9a/335192.jpg?f=avif&w=420)
![실무에서 바로 쓰는 SQL [SQL200제 저자 직강]Course Thumbnail](https://cdn.inflearn.com/public/courses/335513/cover/e2411bc7-040f-4c60-bbe9-2c254f0f8b18/335513.png?f=avif&w=420)
Similar courses
Explore other courses in the same field!
![Oracle PL/SQL 딱 이만큼.. [개념+실전]Course Thumbnail](https://cdn.inflearn.com/public/courses/331731/cover/be361762-0351-44d0-afdb-5230f5a83052/331731-eng.png?f=avif&w=420)
![[웹 개발 풀스택 코스] 넷플릭스와 당근마켓 분석을 통해서 배우는 데이터베이스 기초Course Thumbnail](https://cdn.inflearn.com/public/courses/330079/cover/c142fdb2-b4fa-4b6a-9e8f-7bd48aed7635/fullstack-db-1.jpg?f=avif&w=420)
![[개념반]배워서 바로 쓰는 SQL 쿼리Course Thumbnail](https://cdn.inflearn.com/public/courses/325313/cover/d0ae99dd-3012-4a2e-a1cd-b7c459a75238/325313-eng-2.png?f=avif&w=420)
![[C#과 유니티로 만드는 MMORPG 게임 개발 시리즈] Part5: 데이터베이스Course Thumbnail](https://cdn.inflearn.com/public/courses/325283/course_cover/afb413e6-681e-47cd-808a-099c79fed112/rookiss-rpg-5.jpg?f=avif&w=420)
![AI 시대 똑똑한 SQL 학습법 [입문]Course Thumbnail](https://cdn.inflearn.com/public/files/courses/336379/cover/01k163anqmn6qkaarv95ge5tts?f=avif&w=420)
![자바의 정석부터 Oracle sql까지 완전정복 부트캠프 [Full vers.]Course Thumbnail](https://cdn.inflearn.com/public/files/courses/336223/cover/01k2j32xzj93q4a4mhs8ra9q4b?f=avif&w=420)
