Home > Store > Data > Oracle

Oracle 12c New Features, Part I LiveLessons (Video Training), Download Version

Oracle 12c New Features, Part I LiveLessons (Video Training), Download Version

Downloadable Video

  • Your Price: $299.99
  • About this video
  • Accessible from your Account page after purchase. Requires the free QuickTime Player software.

    Videos can be viewed on: Windows 8, Windows XP, Vista, 7, and all versions of Macintosh OS X including the iPad, and other platforms that support the industry standard h.264 video codec.

Additional sample videos, individual lessons and other formats are available here.

Register your product to gain access to bonus material or receive a coupon.


  • Copyright 2015
  • Edition: 1st
  • Downloadable Video
  • ISBN-10: 0-13-426908-X
  • ISBN-13: 978-0-13-426908-5

4+ Hours of Video Instruction


In the wake of the release of Oracle Database 12c R1 and its most recent upgrade,, many IT organizations are at last turning their attention to evaluating, experimenting with, and implementing the myriad features of this latest release.


Oracle ACE Director Jim Czuprynski demonstrates how to take advantage of these new features to:

  • Speed query execution
  • Conserve disk space
  • Implement true storage tiering
  • Manage maintenance of partitioned objects effectively
  • Perform database backups and recovery quickly and efficiently.

Skill Level

  • Intermediate
What You Will Learn
  • Understand how the In-Memory features of Oracle Database Column Store, In-Memory Joins, and In-Memory Aggregation--offer potential improvements of one to two orders of magnitude, especially for data warehousing queries, without changing any application code.
  • Discover how to implement Oracle Database 12c’s new Information Lifecycle Management (ILM) features and leverage them to improve flash and spinning disk storage allocation and query response time while simultaneously establishing viable strategies for data obsolescence.
  • Understand how the query optimizer has been enhanced in Oracle Database 12c to the point where many SQL statements are virtually self-tuningthrough features like Dynamic Plans, Automatic Re-Optimization, and SQL Plan Directives. The addition of two new histograms also helps retrieve skewed data faster than ever before.
  • Discover several new features, especially the ability to perform partition maintenance operations while all data is still available for queries and DML operations.
  • Understand how Oracle Database’s Attribute Clustering features make it possible to store a table’s data in an appropriate order within a table to speed its retrieval during query executions, as well as leverage Zone Mapping features that quickly prune away data that’s not required to complete a query.
  • Discover several new and enhanced features of Recovery Manager (RMAN) in Oracle Database 12c that speed backup and restore times for image-copy datafiles while simplifying and streamlining database cloning.
Who Should Take This Course
  • Oracle Database Administrators
  • Oracle Exadata Database Machine Administrators
  • Application Developers interested in leveraging new 12c Database features
Course Requirements
  • Basic working knowledge of Oracle Database operating concepts
  • Knowledge of Oracle Database 12c is not required

Table of Contents

Lesson 1: In-Memory Features

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

1.2.Prioritize which tables stay within the IMCS

1.3.Compress tables appropriately inside IMCS

1.4.Leverage IMCS to dramatically improve query performance

1.5.Understand how In-Memory Joins (IMJ) work

1.6.Understand advantages of In-Memory Aggregation (IMA)

Lesson 2: Information Lifecycle Management

2.1.Understand Information Lifecycle Management (ILM) concepts

2.2.Understand Automatic Data Optimization (ADO)

2.3.Understand In-Database Archiving (IDA)

2.4.Understand Temporal Validity (TV)

2.5.Understand Temporal History (TH)

2.6.Combine ADO, IDA, and TV Features

Lesson 3: SQL Performance Improvements

3.1.Understand Automatic SQL Tuning Features

3.2.Detect deployment of Adaptive Execution Plans

3.3.Deploy Automatic Re-Optimization

3.4.Leverage SQL Plan Directives

3.5.Utilize Extended Statistics

3.6.Take advantage of new Top Frequency and Hybrid histograms

Lesson 4: Attribute Clustering and Zone Mapping

4.1.Implement Attribute Clustering

4.2.Leverage Zone Mapping

4.3.Combine Attribute Clustering and Zone Mapping

Lesson 5: Data Warehousing Improvements

5.1.Take advantage of 12c Partitioning improvements

5.2.Understand online partition and online datafile operations

5.3.Leverage selective partition indexing

5.4.Utilize Advanced Index Compression

Lesson 6: Recovery Manager (RMAN) Improvements

6.1.Take advantage of simplified database cloning

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

6.3.Perform table-level point-in-time recovery

About LiveLessons Video Training

The LiveLessons Video Training series publishes hundreds of hands-on, expert-led video tutorials covering a wide selection of technology topics designed to teach you the skills you need to succeed. This professional and personal technology video series features world-leading author instructors published by your trusted technology brands: Addison-Wesley, Cisco Press, IBM Press, Pearson IT Certification, Prentice Hall, Sams, and Que. Topics include: IT Certification, Programming, Web Development, Mobile Development, Home and Office Technologies, Business and Management, and more. View all LiveLessons on InformIT at: http://www.informit.com/livelessons .


Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership