Oracle Database 12cには、SQLを使用してアクセスできる一連の強力な分析機能と分析関数が実装されています。
以下のリンクからそれぞれの機能や特徴について学習してください。

技術情報

データ・シート
Analytical SQL Analytical SQL Data Sheet （US）
ホワイト・ペーパー
Oracle Database 12cのSQLパターン・マッチング
Oracle Database 12cの分析用SQL
SQL - the natural language for analysis
The SQL Model Clause of Oracle Database
iBooks
Patterns Everywhere - Find then fast! (Apple iBook for OSX, iPad and iPad Mini)
プレゼンテーション
Using Analytical SQL to Intelligently Explore Big Data
SQL - the best development language for Big Data
Analyze This! Analytical Power in SQL, More Than You Ever Dreamed Of
Oracle Statistical Functions Overview

 		 Oracle Database SQL Model Clause
技術記事
Oracle Magazine - Technology: SQL 101 by Melanie Caffrey is a senior development manager at Oracle.
Jan 2013 Having Sums, Averages, and Other Grouped Data
March 2013 A Window into the World of Analytic Functions
May 2013 Leading Ranks and Lagging Percentages: Analytic Functions, Continued
July 2013 Pivotal Access to Your Data: Analytic Functions, Concluded

Oracle Magazine - Ask Tom
March 2015 SQL, SQL and More SQL Tom Kyte covers using analytical SQL functions and SQL Model clause
デモ
Using pattern matching and spatial analytics to track fraud (OOW 2013 - Keynote demo)
Sessionization with SQL Pattern Matching
ビデオ
Tom Kyte: 12 Features of Oracle Database 12c
George Lumpkin: Big Data and Data Warehousing for the Enterprise

Back to top

Training

Oracle University
Oracle Database 12c: Analytic SQL for Data Warehousing
SQL Masterclass with Rob van Wijk
Oracle Database 12c: SQL and PL/SQL New Features Ed 1 * NEW *

Oracle-by-Example
SQL Model Clause
SQL Pattern Matching

Oracle Learning Library
Pattern Matching
Sessionization with SQL Pattern Matching
Introduction to SQL Analytics
Database X-Series - SQL Pattern Matching

OTN Virtual Developer Day
SQL Pattern Matching Workshop (Webcast, slides and hands-on lab)
Download Database 12c VM for workshop

Scripts
Github library of scripts
Series of scripts for Analytical SQL
Pattern Matching use cases and examples
Scripts and examples for SQL Model

Back to top

Presentations and Labs from Oracle OpenWorld

Using Analytical SQL to Intelligently Explore Big Data
Everything That Is Really Useful in Oracle Database 12c for Application Developers
Oracle Database 12c Row Pattern Matching: Beating the Best Pre-12c Solutions
Getting Started with SQL Pattern Matching in Oracle Database 12c
SQL Pattern Matching Big Data Sessionization Hands-on Lab

Back to top

Related Technology

 
Oracle Database 12c
PL/SQL
 
SQL
Data Warehousing and Big Data
 
Statistical Functions
Query Optimization
 
Big Data SQL
SQL Performance Analyzer (SPA)


 
Back to top
 
Go to Community for blogs, videos, and more . . .