Books & Videos

Table of Contents

Chapter: Introduction

Oracle 12c New Features, Part I LiveLessons: Introduction

02m 11s

Chapter: Lesson 1: In-Memory Features

Learning objectives

01m 32s

1.1 Understand In-Memory Column Store (IMCS) architecture and terminology

12m 31s

1.2 Prioritize which tables stay within the IMCS

07m 47s

1.3 Compress tables appropriately inside IMCS

04m 47s

1.4 Leverage IMCS to dramatically improve query performance

09m 31s

1.5 Understand how In-Memory Joins (IMJ) work

06m 58s

1.6 Understand advantages of In-Memory Aggregation (IMA)

07m 45s

Chapter: Lesson 2: Information Lifecycle Management

Learning objectives

01m 41s

2.1 Understand Information Lifecycle Management (ILM) concepts

02m 19s

2.2 Understand Automatic Data Optimization (ADO)

26m 17s

2.3 Understand In-Database Archiving (IDA)

08m 34s

2.4 Understand Temporal Validity (TV)

07m 24s

2.5 Understand Temporal History (TH)

04m 53s

2.6 Combine ADO, IDA, and TV features

03m 38s

Chapter: Lesson 3: SQL Performance Improvements

Learning objectives

01m 6s

3.1 Understand Automatic SQL Tuning features

01m 15s

3.2 Detect deployment of Adaptive Execution Plans

03m 27s

3.3 Deploy Automatic Re-Optimization

02m 29s

3.4 Leverage SQL Plan Directives

04m 31s

3.5 Utilize Extended Statistics

07m 15s

3.6 Take advantage of new Top Frequency and Hybrid histograms

24m 23s

Chapter: Lesson 4: Attribute Clustering and Zone Mapping

Learning objectives

01m 8s

4.1 Understand Attribute Clustering

17m 31s

4.2 Leverage Zone Mapping

04m 48s

4.3 Combine Attribute Clustering and Zone Mapping

07m 29s

Chapter: Lesson 5: Data Warehousing Improvements

Learning Objectives

01m 5s

5.1 Take advantage of 12c partitioning improvements

13m 3s

5.2 Understand online partition and online datafile operations

04m 52s

5.3 Leverage selective partition indexing

12m 17s

5.4 Utilize Advanced Index Compression

05m 12s

Chapter: Lesson 6: Recovey Manager (RMAN)

Learning Objectives

00m 45s

6.1 Take advantage of simplified database cloning

08m 17s

6.2 Leverage multi-piece image copy backups for faster backup and recovery

06m 40s

6.3 Perform database recovery using third-party snapshots

04m 21s

6.4 Perform table-level point-in-time recovery (PITR)

06m 49s

Chapter: Summary

Oracle 12c New Features, Part I LiveLessons: Summary

01m 40s