Oracle 12c New Features, Part I LiveLessons (Video Training), Downloadable Version
- By Jim Czuprynski
- Published Jun 16, 2015 by Pearson.
Downloadable Video
- Your Price: $239.99
- List 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.
Register your product to gain access to bonus material or receive a coupon.
Description
- Copyright 2015
- Edition: 1st
- Downloadable Video
- ISBN-10: 0-13-426349-9
- ISBN-13: 978-0-13-426349-6
4+ Hours of Video Instruction
Overview
In the wake of the release of Oracle Database 12c R1 and its most recent upgrade, 12.1.0.2, many IT organizations are at last turning their attention to evaluating, experimenting with, and implementing the myriad features of this latest release.
DescriptionOracle 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 12.1.0.2--In-Memory 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 12.1.0.2’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.
- Oracle Database Administrators
- Oracle Exadata Database Machine Administrators
- Application Developers interested in leveraging new 12c Database features
- 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 TrainingThe 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 .
Extras
Related Article
6 Reasons to Migrate Your Oracle Databases Twice as Fast to Release 12.1.0.2