Oracle - Advanced Analytics II and Data Mining (ORA9)

Databases, Oracle

This course expands participants' knowledge of advanced analytics, statistical methods and data mining in the Oracle environment. After a clear overview of analytic functions, we focus on time series, period-to-period comparison and advanced aggregations.

You will learn to handle text data and use Oracle's Model Clause for Excel-like transformations, perform regression analysis and hypothesis testing, apply association rules, and use sampling, percentiles and partitioned joins for robust predictive workflows.

Location, current course term

Brno + online (volitelně)	10/20/2025 - 10/21/2025 CZECH Order 1/12/2026 - 1/13/2026 CZECH Order
Praha + online (volitelně)	11/26/2025 - 11/27/2025 CZECH Order 2/18/2026 - 2/19/2026 CZECH Order
Custom	Customized Training (date, location, content, duration)

The course:

Hide detail

• Oracle Advanced Analytic Functions
1. Oracle Analytics – summary of analytic functions
2. Filling missing values
3. Time series
4. Period-to-period calculations

• Oracle Text Analysis
1. Text data analysis – searching via a text index
2. Comparison of methods for text analysis

• Oracle Advanced Analytic
1. Pivoting and unpivoting – comparison of methods
2. Approximate aggregate functions – purpose and use
3. Oracle Model Clause – Excel-like processing
4. Data sampling – methods and comparison
5. Partitioned outer join and its usage
6. Regression analysis
7. Statistical aggregates (median and similar)
8. Percentile and inverse percentile
9. Hypothesis testing
10. Linear algebra in Oracle

• Oracle Data Mining
1. Introduction to data mining in Oracle
2. Overview of Oracle methods for Data Mining
3. Association rules and Market Basket Analysis

Assumed knowledge:

Basic knowledge of SQL and Oracle database concepts.

Recommended previous course:

Oracle - Advanced Analytics I. (ORA7)

Schedule:

2 days (9:00 AM - 5:00 PM )

Course price:

580.00 € ( 701.80 € incl. 21% VAT)

Language: