วีดีโอ

044 Tracking changes in Data

043 Flashback operations Introduction

042 Query Rewrite functionality

041 Timing the refresh

040 Materialized Views with REFRESH FAST option

039 Materialized Views with ON DEMAND option

038 Materialized Views with ON COMMIT option

037 Materialized Views creation Options

036 Materialized Views Introduction

035 Analyzing Sales growth across time

034 LAG and LEAD function Examples

033 Dividing your data into Bands

032 Performing Top N Analysis

031 Ranking your data

030 Displaying Sales as a percentage of Total sales

029 Getting the cummulative Sum of Sales

028 Why Analytical Functions Example 2

027 Why Analytical Functions Example 1

026 Analytical Functions Introduction

025 Interval Partition for automatic partition creation

024 Composite Partitioning by mixing things up

023 Hash Partition based on the hash key

022 List Partition based on list of values

021 Range Partition based on range of values

020 Table Partitioning Introduction

019 Composite Columns

018 Limiting number of sub totals using GROUPING SETS function

017 GROUPING ID function

016 GROUPING function