바로가기 메뉴
본문 바로가기
주메뉴 바로가기

Oracle

교육개요
교육 커리큘럼과 강사는 사정에 의해 변경될 수 있습니다.
교육명,를 포함한 교육과정 표
교육명 공통 Oracle Database 12c: Analytic SQL for Data Warehousing 2차
교육기간 2019-12-02 ~ 2019-12-03
교육시간 09:30~17:00(1일 6시간, 총 12시간)
교육장 영우글로벌러닝  지도보기
강사
정원 20명
교육비 758,100원(VAT별도)


교육소개
This Oracle Database 12c: Analytic SQL for Data Warehousing training teaches you how to interpret the concept of a hierarchical query, create a tree-structured report, format hierarchical data and exclude branches from the tree structure. You'll also learn to use regular expressions and sub-expressions to search for, match, and replace strings. In this course, you will be introduced to Oracle Business Intelligence Cloud Service.
교육목표
○ Group and aggregate data using the ROLLUP and CUBE operators
○ Analyze and report data using Ranking, LAG/LEAD, and FIRST/LAST functions
○ Use the MODEL clause to create a multidimensional array from query results
○ Use Analytic SQL to aggregation, Analyze and Reporting, and Model Data
○ Interpret the concept of a hierarchical query, create a tree-structured report, format hierarchical data, and exclude branches from the tree structure
○ Gain an understanding of the Oracle Business Intelligence Cloud Service
○ Use regular expressions to search for, match, and replace strings
○ Perform pattern matching using the MATCH_RECOGNIZE clause
교육대상
Application Developers / Database Designers / Support Engineer / Data Warehouse Analyst / Data Warehouse Developer
교육내용

 

 

□ Course Topics

 

Introduction
Course Objectives, Course Agenda and Class Account Information
Overview of Analytic SQL
Overview of SQL*Plus Environment
Describe the Schemas and Appendices used in the Lesson
Overview of SQL Developer
Oracle Database SQL and Data Warehousing Documentation


Grouping and Aggregating Data Using SQL
Using the ROLLUP and CUBE Operators
Using Concatenated Groupings with Example
Review of Group Functions
Working with GROUPING SET Operators and Composite Columns
Generating Reports by Grouping Related Data
Using the GROUPING Function
Reviewing GROUP BY and HAVING Clause


Hierarchical Retrieval
Using the WITH Clause
Hierarchical Query Example: Using the CONNECT BY Clause
Walking the Tree: Specifying the Direction of the Query
Hierarchical Queries: Syntax
Using Hierarchical Queries
Walking the Tree: Specifying the Starting Point
Natural Tree Structure
Sample Data from the EMPLOYEES Table


Working with Regular Expressions
Extracting Substrings Using the REGEXP_SUBSTR Function
Introducing Metacharacters
Performing a Basic Search Using the REGEXP_LIKE Condition
Finding Patterns Using the REGEXP_INSTR Function
Using the Regular Expressions Functions and Conditions in SQL and PL/SQL
Regular Expressions Functions and Conditions: Syntax
Using Metacharacters with Regular Expressions
Introducing Regular Expressions


Analyzing and Reporting Data Using SQL
Using the Ranking Functions
Using Reporting Functions
Overview of SQL for Analysis and Reporting Functions
Using Analytic Functions


Performing Pivoting and Unpivoting Operations
Creating a New Pivot Table: Example
Performing Pivoting Operations
Pivoting on the QUARTER Column: Conceptual Example
Performing Unpivoting Operations
Using the PIVOT and UNPIVOT Clauses
Using the UNPIVOT Clause Columns in an UNPIVOT Operation


Pattern Matching using SQL
Expressing All Permutations
Rules and Restrictions in Pattern Matching
Examples of Pattern Matching
Row Pattern Navigation Operations
Excluding Portions of the Pattern from the Output
Handling Empty Matches or Unmatched Rows


Modeling Data Using SQL
Using the CV Function
Using Analytic Functions in the SQL MODEL Clause
Using the MODEL clause
Using FOR Construct with IN List Operator, incremental values and Subqueries
Distinguishing Missing Cells from NULLs
Using the UPDATE, UPSERT and UPSERT ALL Options
Demonstrating Cell and Range References
Reference Models


Oracle Business Intelligence Cloud Service Overview
Oracle BI Cloud Service
BICS Can Integrate Any Data Source Quickly
Enterprise-Grade Service Reliability
Guidance Through Exploratory Analysis & Deep Discovery through Rich Feature Set
Speed, Flexibility and Economy of Cloud
BICS Makes Any Time The Right Time For New Insights
Immediate Access to New Functionality
Introducing Oracle Business Intelligence Cloud Service

 

 

학원의 설립ㆍ운영 및 과외교습에 관한 법률 시행령에 따라 다음과 같이 수강료를 환불해드립니다.

  1. 반환기한 : 반환사유가 발생한 경우 반환기준에 따라 반환사유 발생일로부터 5일 이내에 교습비등을 환불해 드리겠습니다.
  2. 반환기준
    • 1) 교습을 할 수 없거나 교습장소를 제공할 수 없게 된 날을 기준으로 이미 납부한 교습비등을 일할 계산한 금액을 환불해 드리겠습니다.
    • 2) 교습기간이 1개월 이내인 경우, 다음과 같이 환불해 드리겠습니다.
      - 교습시작 전 : 이미 납부한 교습비등의 전액
      - 총 교습시간 1/3 경과 전 : 이미 납부한 교습비등의 2/3에 해당하는 금액
      - 총 교습시간 1/2 경과 전 : 이미 납부한 교습비등의 1/2에 해당하는 금액
      - 총 교습시간 1/2 경과 후 : 반환하지 않음
    • 3) 교습기간이 1개월을 초과하는 경우, 다음과 같이 환불해 드리겠습니다.
      - 교습시작 전 : 이미 납부한 교습비등의 전액
      - 교습시작 후 : 반환사유가 발생한 해당월의 반환 대상 교습비등(교습기간 1개월 이내 기준 산출금액)과 나머지 월의 교습비등 전액을 합산한 금액