Technical Information

Data Sheets

• Analytical SQL Data Sheet

Whitepapers

• SQL - the natural language for analysis
• Patterns Everywhere - Find then fast!
• The SQL Model Clause of Oracle Database

iBooks

• Patterns Everywhere - Find then fast! (Apple iBook for OSX, iPad and iPad Mini)

Presentations

• Analytical SQL in Oracle Database 18c
• 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

Articles

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

Demos

• Using pattern matching and spatial analytics to track fraud (OOW 2013 - Keynote demo)
• Sessionization with SQL Pattern Matching

Videos

Tom Kyte: 12 Features of Oracle Database 12c

George Lumpkin: Big Data and Data Warehousing for the Enterprise

Keep It Simple SQL (KISS):

• Welcome to the KISS (Keep It Simply SQL) Analytics series
• Ranking rows
• Options for ranking
• Mind the gap
• More ranking options
• Dealing with null
• Predicates
• PARTITION BY clause
• PARTITION BY with aggregation
• Execution costs

Checkout the growing library of SQL videos on our YouTube channel by clicking here

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

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

Presentations and Labs from Oracle OpenWorld

• SQL Pattern Matching Big Data Sessionization Hands-on Lab