[국비지원] SQL 활용과 오라클(Oracle) Hint를 이용한 SQL튜닝 재직자 향상과정

<h4 style="margin: 0px; padding: 0px; border: 0px currentColor; border-image: none; color: rgb(51, 51, 51); line-height: 1.3; font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-size: 15px; font-weight: 500; vertical-align: top; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="font-size: 36pt; box-sizing: border-box;">SQL 활용과 오라클(Oracle) Hint를 이용한 SQL튜닝 재직자 향상과정</span></h4><div style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><br style="box-sizing: border-box;"></div><div style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><br style="box-sizing: border-box;"></div><div style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><br style="box-sizing: border-box;"></div><div align="center" style="text-align: center; color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="font-size: 24pt; box-sizing: border-box;"><img class="img-tag " style="margin: 0px; padding: 0px; border: 0px currentColor; border-image: none; width: auto; height: auto; vertical-align: middle; max-width: 100%; box-sizing: border-box;" alt="SQL íì©ê³¼ ì¤ë¼í´(Oracle) Hintë¥¼ ì´ì©í SQLíë ì¬ì§ì í¥ìê³¼ì " src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Ftopcredu.co.kr%2Fimages%2Fcrcl%2F%25EA%25B0%2595%25EC%25A2%258C%25EC%259D%25B4%25EB%25AF%25B8%25EC%25A7%2580_%25EC%2598%25A4%25EB%259D%25BC%25ED%2581%25B4SQL%25EA%25B8%25B0%25EB%25B3%25B8%25EB%25B0%258F%25ED%2599%259C%25EC%259A%25A91.jpg"></span></div><div align="center" style="text-align: center; color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><br style="box-sizing: border-box;"></div><div style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><div align="center" style="text-align: center; box-sizing: border-box;"><br style="box-sizing: border-box;"></div><div align="center" style="text-align: center; box-sizing: border-box;"><span style="font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-size: 24px; box-sizing: border-box; background-color: rgb(255, 239, 0);">평일주간<span style="box-sizing: border-box; background-color: rgb(255, 255, 255);">:<a class="con_link" style="background: 0px 0px; color: rgb(102, 102, 102); cursor: pointer; box-sizing: border-box;" href="http://topcredu.co.kr/sub/crcl/view/db/2257" target="_blank">http://topcredu.co.kr/sub/crcl/view/db/2257</a></span></span></div><div align="center" style="text-align: center; box-sizing: border-box;"><span style="font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-size: 24px; box-sizing: border-box; background-color: rgb(255, 239, 0);">주말주간</span><span style="font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-size: 24px; box-sizing: border-box;">:<a class="con_link" style="background: 0px 0px; color: rgb(102, 102, 102); cursor: pointer; box-sizing: border-box;" href="http://topcredu.co.kr/sub/crcl/view/db/2325" target="_blank">http://topcredu.co.kr/sub/crcl/view/db/2325</a></span></div><div align="center" style="text-align: center; box-sizing: border-box;"><span style="font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-size: 24px; box-sizing: border-box;"><br style="box-sizing: border-box;"></span></div><div align="center" style="text-align: center; box-sizing: border-box;"> </div></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="font-size: 16px; font-weight: 700; box-sizing: border-box; background-color: rgb(255, 232, 232);">★ 교육개요 ★</span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(255, 0, 0); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;"><br style="box-sizing: border-box;"></span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(255, 0, 0); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;">재직자가 아닌 경우 국비지원없이 전액 자부담으로 수강 가능 합니다.</span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(0, 0, 255);"><br style="box-sizing: border-box;"></span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(0, 0, 255);">[국비지원]</span><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;">프로그램 개발 시 개발자들이 가장 많이 접하는 SQL 사용법에 중점을 둔 강좌로서 기본적인 SQL사용법 부터 ,SQL*Plus사용법, SQL함수, 서브쿼리, 조인, 그룹함수, 분석함수에 대해 집중적으로 학습하며 개발자가 반드시 알아야 하는 Schema Object(Table, Index, View, Sequence, Synonym), 계층적 쿼리문까지 학습하는 과정 입니다.</span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;"><br style="box-sizing: border-box;"></span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;">또한 SQL 튜닝을 위해 오라클 옵티마이저에 대한 기본 이해부터 오라클 힌트구문의 이해를 통해 데이터 검색 시 최적화된 시간에 데이터가 검색되도록 하는 방법에 대해 이론과 실습을 통해 배우게 되는 실무/실습 위주의 강좌 입니다.</span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="font-size: 16px; font-weight: 700; box-sizing: border-box; background-color: rgb(255, 232, 232);"><br style="box-sizing: border-box;"></span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="font-size: 16px; font-weight: 700; box-sizing: border-box; background-color: rgb(255, 232, 232);">★ 수료조건 ★</span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;"><br style="box-sizing: border-box;"></span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;">출석률 80%이상</span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="font-size: 16px; font-weight: 700; box-sizing: border-box; background-color: rgb(255, 232, 232);"><br style="box-sizing: border-box;"></span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="font-size: 16px; font-weight: 700; box-sizing: border-box; background-color: rgb(255, 232, 232);">★ 교육목표 ★</span><span style="box-sizing: border-box;"> </span><span style="box-sizing: border-box;"> </span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;"><br style="box-sizing: border-box;"></span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;">관계형 데이터베이스에서 SQL을 사용하여 목적에 적합한 데이터를 정의하고, 조작하며, 제어하는 구문의 이해</span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;">테이블의 구조와 제약조건을 생성, 삭제하고 수정하는 DDL(Data Definition Language) 명령문 작성에 대한 이해</span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;">한 개의 테이블에 대해 데이터를 삽입, 수정, 삭제하고 행을 조회하는 DML(Data Manipulation Language) 명령문 작성에 대한 이해</span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;">업무단위인 트랜잭션의 완료와 취소를 위한 DCL(Data Control Language) 명령문 작성에 대한 이해</span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;">생성된 테이블의 목록, 테이블의 구조와 제약조건을 파악하기 위해 데이터사전을 조회하는 명령문 작성에 대한 이해</span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;">테이블 조회 시간을 단축하기 사용하는 인덱스의 개념을 이해하고 인덱스를 생성하는 DDL(Data Definition Language)명령문 작성에 대한 이해</span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;">생성된 테이블들을 이용하여 새로운 테이블과 뷰를 생성하는 DDL(Data Definition Language)명령문 작성에 대한 이해</span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;">조인, 서브쿼리, 집합연산자를 사용하여 두 개 이상의 테이블로부터 데이터를 조회하는 DML(Data Manipulation Language)명령문을 작성에 대한 이해</span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;">오라클 옵티마이저의 이해</span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;">SQL 실행계획의 이해</span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;">실행계획 SQL 연산자의 이해</span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;">서브쿼리/조인의 방법에 따른 성능을 이해하고 작성된 SQL 구문 튜닝의 이해</span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;">Access Parh/Join/Query Transformation과 관련된 오라클 힌트 구문의 이해</span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;">쿼리 최적화에 대한 이해</span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;"><br style="box-sizing: border-box;"></span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="box-sizing: border-box;"><span style="color: rgb(68, 68, 68); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-size: 13.2px; box-sizing: border-box;"><br style="box-sizing: border-box;"></span></span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="box-sizing: border-box;"><span style="font-size: 16px; font-weight: 700; box-sizing: border-box; background-color: rgb(255, 232, 232);">★ 교육대상 ★</span></span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;"><br style="box-sizing: border-box;"></span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;">DB엔지니어링분야의 신규 재직자</span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;">-</span><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;"> IT 신입사원</span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;">- 현업 사용자</span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;">- SQL 초보사용자</span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;">- SQL의 활용 능력을 통이고 싶은 자</span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;">- 초보개발자 및 실무개발자</span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;">- DB관리자</span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;">- 쿼리를 잘하고 싶은 IT 개발자</span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="color: rgb(244, 122, 32); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-weight: 700; box-sizing: border-box;"><br style="box-sizing: border-box;"></span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="box-sizing: border-box;"><span style="font-size: 16px; font-weight: 700; box-sizing: border-box; background-color: rgb(255, 232, 232);">★ 커리큘럼 ★</span><span style="color: rgb(68, 68, 68); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-size: 13.2px; box-sizing: border-box;"> </span></span></div><div align="left" style="color: rgb(51, 51, 51); font-family: "Malgun gothic", dotum, sans-serif; box-sizing: border-box; background-color: rgb(255, 255, 255);"><span style="box-sizing: border-box;"><span style="color: rgb(68, 68, 68); font-family: "맑은 고딕", "Malgun Gothic", dotum, 돋움, sans-serif; font-size: 13.2px; box-sizing: border-box;"><span class="deeporange" style="margin: 0px; padding: 0px; text-align: center; color: rgb(244, 122, 32); font-size: 12px; font-weight: 700; vertical-align: top; box-sizing: border-box;"></span></span></span><div class="cd-tabs is-ended" style="margin: 2em auto; padding: 0px; width: 960px; vertical-align: top; box-sizing: border-box;"><ul class="cd-tabs-content" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; padding: 0px; height: 2825px; vertical-align: top; list-style-type: none; box-sizing: border-box;"><li class="selected" style="margin: 0px; padding: 1.5em; line-height: 20px; vertical-align: top; box-sizing: border-box;"><div class="detail_edu" style="margin: 20px 0px 0px; padding: 0px; vertical-align: top; border-top-color: rgb(221, 221, 221); border-top-width: 1px; border-top-style: solid; box-sizing: border-box;"><table class="__se_tbl_ext" style="margin: 20px 0px 0px; padding: 0px; width: 920px; vertical-align: top; border-top-color: rgb(0, 52, 97); border-top-width: 1px; border-top-style: solid; border-collapse: collapse; box-sizing: border-box; border-spacing: 0px; background-color: transparent;" summary="교육에 대한 내용안내 입니다."><tbody style="margin: 0px; padding: 0px; vertical-align: top; box-sizing: border-box;"><tr style="margin: 0px; padding: 0px; vertical-align: top; box-sizing: border-box;"><th style="background: rgb(248, 248, 248); margin: 0px; padding: 0px 10px; text-align: left; color: rgb(0, 52, 97); line-height: 22px; vertical-align: middle; border-bottom-color: rgb(221, 221, 221); border-bottom-width: 1px; border-bottom-style: solid; box-sizing: border-box;">개요 및 실습데이터 설치</th><td style="margin: 0px; padding: 10px; line-height: 22px; vertical-align: middle; border-bottom-color: rgb(221, 221, 221); border-bottom-width: 1px; border-bottom-style: solid; box-sizing: border-box;">오라클, 데이터베이스관련 용어<br style="box-sizing: border-box;">오라클 에디션(ORACLE EDITION)<br style="box-sizing: border-box;">오라클 버전 변화<br style="box-sizing: border-box;">실습데이터 설치 및 SQL*PLUS 실행환경 설정<br style="box-sizing: border-box;">실습데이터 구조(테이블 정의서)<br style="box-sizing: border-box;">데이터베이스 무결성(DataBase Integrity)</td></tr><tr style="margin: 0px; padding: 0px; vertical-align: top; box-sizing: border-box;"><th style="background: rgb(248, 248, 248); margin: 0px; padding: 0px 10px; text-align: left; color: rgb(0, 52, 97); line-height: 22px; vertical-align: middle; border-bottom-color: rgb(221, 221, 221); border-bottom-width: 1px; border-bottom-style: solid; box-sizing: border-box;">SQL기본</th><td style="margin: 0px; padding: 10px; line-height: 22px; vertical-align: middle; border-bottom-color: rgb(221, 221, 221); border-bottom-width: 1px; border-bottom-style: solid; box-sizing: border-box;">SQL*Plus 명령어<br style="box-sizing: border-box;">Schema 계정에서의 기본 쿼리문<br style="box-sizing: border-box;">기본 쿼리문<br style="box-sizing: border-box;">ROWNUM 및 NULL값, NLS_DATE_FORMAT<br style="box-sizing: border-box;">데이터 타입(Data Type)<br style="box-sizing: border-box;">SQL 문자함수, 집합함수, 숫자 및 날짜함수, 변환함수, 일반함수 및 조건식</td></tr><tr style="margin: 0px; padding: 0px; vertical-align: top; box-sizing: border-box;"><th style="background: rgb(248, 248, 248); margin: 0px; padding: 0px 10px; text-align: left; color: rgb(0, 52, 97); line-height: 22px; vertical-align: middle; border-bottom-color: rgb(221, 221, 221); border-bottom-width: 1px; border-bottom-style: solid; box-sizing: border-box;">서브 쿼리 및 조인</th><td style="margin: 0px; padding: 10px; line-height: 22px; vertical-align: middle; border-bottom-color: rgb(221, 221, 221); border-bottom-width: 1px; border-bottom-style: solid; box-sizing: border-box;">서브 쿼리(SUB QUERY) 개요<br style="box-sizing: border-box;">복수행 서브쿼리(Multi-Row Sub Query)<br style="box-sizing: border-box;">상관 서브쿼리(Correlated Sub Query)<br style="box-sizing: border-box;">Scalar SubQuery, 인라인뷰, WITH <br style="box-sizing: border-box;">테이블 별명(Table Alias)<br style="box-sizing: border-box;">카티션 프로덕트<br style="box-sizing: border-box;">EquiJoin, Non EquiJoin<br style="box-sizing: border-box;">Self Join, Outer Join<br style="box-sizing: border-box;">계층형 쿼리(Hierarchical Query)</td></tr><tr style="margin: 0px; padding: 0px; vertical-align: top; box-sizing: border-box;"><th style="background: rgb(248, 248, 248); margin: 0px; padding: 0px 10px; text-align: left; color: rgb(0, 52, 97); line-height: 22px; vertical-align: middle; border-bottom-color: rgb(221, 221, 221); border-bottom-width: 1px; border-bottom-style: solid; box-sizing: border-box;">SQL 활용</th><td style="margin: 0px; padding: 10px; line-height: 22px; vertical-align: middle; border-bottom-color: rgb(221, 221, 221); border-bottom-width: 1px; border-bottom-style: solid; box-sizing: border-box;">분석함수 기본형식 및 응용<br style="box-sizing: border-box;">테이블 생성, 변경, 삭제<br style="box-sizing: border-box;">데이터 딕셔너리<br style="box-sizing: border-box;">DML, INSERT 명령어, 단일행 입력, 복수행 입력, UPDATE, DELETE, MERGE<br style="box-sizing: border-box;">인덱스(INDEX) 단일/복합, 고유/비고유, 재구성, 삭제, 숨기기<br style="box-sizing: border-box;">뷰(VIEW) 단순, 복합, 인라인<br style="box-sizing: border-box;">동의어(Synonym)<br style="box-sizing: border-box;">시퀀스(Sequence)</td></tr><tr style="margin: 0px; padding: 0px; vertical-align: top; box-sizing: border-box;"><th style="background: rgb(248, 248, 248); margin: 0px; padding: 0px 10px; text-align: left; color: rgb(0, 52, 97); line-height: 22px; vertical-align: middle; border-bottom-color: rgb(221, 221, 221); border-bottom-width: 1px; border-bottom-style: solid; box-sizing: border-box;">Hint / Tuning</th><td style="margin: 0px; padding: 10px; line-height: 22px; vertical-align: middle; border-bottom-color: rgb(221, 221, 221); border-bottom-width: 1px; border-bottom-style: solid; box-sizing: border-box;">SQL문 처리과정 <br style="box-sizing: border-box;">커서(Cursor) & Oracle Memory <br style="box-sizing: border-box;">DBMS_STATS 패키지 사용하기 <br style="box-sizing: border-box;">Optimizer Statistics(Table/Column 통계정보) <br style="box-sizing: border-box;">Literal SQL & Bind Variable SQL(Soft Parsing/Hard Parsing) <br style="box-sizing: border-box;">CURSOR_SHARING 파라미터 <br style="box-sizing: border-box;">튜닝의 도구 - SQL AUTOTRACE <br style="box-sizing: border-box;">튜닝의 도구 – DBMS_XPLAN <br style="box-sizing: border-box;">튜닝의 도구 – Event <br style="box-sizing: border-box;">실행계획 해석 <br style="box-sizing: border-box;">실행계획 해석(predicate) <br style="box-sizing: border-box;">초기화 파라미터 OPTIMIZER_MODE <br style="box-sizing: border-box;">Optimizer Mode Setting 방법 <br style="box-sizing: border-box;">규칙 기반 옵티마이저(Rule-Based Optimizer) <br style="box-sizing: border-box;">비용기반 옵티마이저(Cost-Based Optimizer) <br style="box-sizing: border-box;">Optimizer Mode를 변경하는 힌트 (RULE) <br style="box-sizing: border-box;">Optimizer Mode를 변경하는 힌트(FIRST_ROWS) <br style="box-sizing: border-box;">Optimizer Mode를 변경하는 힌트(ALL_ROWS) <br style="box-sizing: border-box;">Optimizer Mode를 변경하는 힌트(CHOOSE) <br style="box-sizing: border-box;">실행계획 SQL 연산(AND-EQUAL) <br style="box-sizing: border-box;">실행 계획 SQL 연산(CONCATENATION) <br style="box-sizing: border-box;">실행계획 SQL 연산(COUNT) <br style="box-sizing: border-box;">실행계획 SQL 연산(COUNT STOPKEY) <br style="box-sizing: border-box;">실행계획 SQL 연산(FILTER) <br style="box-sizing: border-box;">실행계획 SQL 연산(HASH ANTI-JOIN) <br style="box-sizing: border-box;">실행계획 SQL 연산(HASH SEMI-JOIN) <br style="box-sizing: border-box;">실행계획 SQL 연산(NESTED LOOP SEMI-JOIN) <br style="box-sizing: border-box;">실행계획 SQL 연산(INDEX RANGE SCAN) <br style="box-sizing: border-box;">실행계획 SQL연산(INDEX RANGE SCAN DESCENDING) <br style="box-sizing: border-box;">실행계획 SQL연산(INLIST ITERATOR) <br style="box-sizing: border-box;">실행계획 SQL연산(MERGE JOIN) <br style="box-sizing: border-box;">실행계획 SQL연산(MERGE SEMI JOIN) <br style="box-sizing: border-box;">실행계획 SQL연산(MERGE ANTI-JOIN) <br style="box-sizing: border-box;">Hints For Online Application Upgrade (CHANGE_DUPKEY_ERROR_INDEX) <br style="box-sizing: border-box;">Hints For Online Application Upgrade (IGNORE_ROW_ON_DUPKEY_INDEX) <br style="box-sizing: border-box;">Hints For Online Application Upgrade (RETRY_ON_ROW_CHANGE) <br style="box-sizing: border-box;">오라클 인덱스(Oracle Index) <br style="box-sizing: border-box;">비트리 인덱스(B*Tree Index) <br style="box-sizing: border-box;">비트맵 인덱스(Bitmap Index) <br style="box-sizing: border-box;">비트맵 조인 인덱스(Bitmap Join Index) <br style="box-sizing: border-box;">역전환키 인덱스(Reverse Key Index) <br style="box-sizing: border-box;">Hints For Access Paths(Data Scanning) <br style="box-sizing: border-box;">Hints For Access Paths(FULL) <br style="box-sizing: border-box;">Hints For Access Paths(CLUSTER) <br style="box-sizing: border-box;">Hints For Access Paths(HASH) <br style="box-sizing: border-box;">Hints For Access Paths(INDEX, INDEX_COMBINE) <br style="box-sizing: border-box;">Hints For Access Paths(INDEX_ASC) <br style="box-sizing: border-box;">Hints For Access Paths(INDEX_DESC) <br style="box-sizing: border-box;">Hints For Access Paths(NO_INDEX) <br style="box-sizing: border-box;">INDEX 힌트와 복합인덱스 <br style="box-sizing: border-box;">use_invisible_indexes, no_use_invisible_indexes 힌트 <br style="box-sizing: border-box;">Hints For Access Paths(NO_EXPAND) <br style="box-sizing: border-box;">Materialized View(구체화뷰) <br style="box-sizing: border-box;">Hints For Access Paths(REWRITE) <br style="box-sizing: border-box;">Hints For Access Paths(INDEX_FFS) <br style="box-sizing: border-box;">Hints For Access Paths(INDEX_SS) <br style="box-sizing: border-box;">Hints For Access Paths(INDEX_JOIN) <br style="box-sizing: border-box;">Hints For Access Paths(NATIVE_FULL_OUTER_JOIN) <br style="box-sizing: border-box;">Hints for Join Orders <br style="box-sizing: border-box;">중첩루프조인(Nested Loop Join) <br style="box-sizing: border-box;">Hints for Join Orders(ORDERED) <br style="box-sizing: border-box;">Hints for Join Orders(USE_NL) <br style="box-sizing: border-box;">Hints for Join Orders(USE_NL_WITH_INDEX) <br style="box-sizing: border-box;">Hints for Join Orders(NO_USE_NL) <br style="box-sizing: border-box;">해시조인(HASH JOIN, USE_HASH, NO_USE_HASH) <br style="box-sizing: border-box;">Hints for Join Orders(HASH_AJ) <br style="box-sizing: border-box;">Hints for Join Orders(HASH_SJ, NL_SJ) <br style="box-sizing: border-box;">Hints for Join Orders(USE_MERGE) <br style="box-sizing: border-box;">Hints for Join Orders(LEADING) <br style="box-sizing: border-box;">RBO에서의 드라이빙 테이블 선정 <br style="box-sizing: border-box;">CBO에서의 드라이빙 테이블 선정 <br style="box-sizing: border-box;">Semi Join(세미 조인) <br style="box-sizing: border-box;">Anti Join(안티조인) <br style="box-sizing: border-box;">SWAP_JOIN_INPUTS(OUTER JOIN에서 드라이빙 테이블 선정) <br style="box-sizing: border-box;">Additional Hints <br style="box-sizing: border-box;">Additional Hints(DRIVING_SITE) <br style="box-sizing: border-box;">Additional Hints(CACHE, NO_CACHE) <br style="box-sizing: border-box;">Additional Hints(CURSOR_SHARING_EXACT) <br style="box-sizing: border-box;">Additional Hints(GATHER_PLAN_STATISTCS) <br style="box-sizing: border-box;">Additional Hints(DYNAMIC_SAMPLING) <br style="box-sizing: border-box;">Additional Hints(RESULT_CACHE) <br style="box-sizing: border-box;">Additional Hints(QB_NAME) <br style="box-sizing: border-box;">Additional Hints(MONITOR) <br style="box-sizing: border-box;">Hints For Query Transformations(서브쿼리의 종류) <br style="box-sizing: border-box;">Hints For Query Transformations(UNNEST, NO_UNNEST) <br style="box-sizing: border-box;">Hints For Query Transformations(MERGE, NO_MERGE), View Merging <br style="box-sizing: border-box;">Hints For Query Transformations(phsh_subq, no_push_subq, SubQuery Pushing) <br style="box-sizing: border-box;">Query Transformations(Predicate Pushing, Predicate Pushdown) <br style="box-sizing: border-box;">Query Transformations(Join Predicate Pushdown, push_pred, no_push_pred) <br style="box-sizing: border-box;">Query Transformations(OR-Expansion) <br style="box-sizing: border-box;">SQL문 튜닝을 위한 접근 <br style="box-sizing: border-box;">SQL 작성 TIP<div class="autosourcing-stub-extra" style="-ms-zoom: 1; opacity: 1;"></div></td></tr></tbody></table></div></li></ul></div></div><p><br></p>