Oracle 12c New Features, Part I LiveLessons

Video Description

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.

Description

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.

About the Instructor

Jim Czuprynski’s information technology experience spans three decades. He served in diverse roles at several Fortune 1000 companies--as a mainframe programmer, applications developer, business analyst, and project manager--before becoming an Oracle DBA in 2001. He currently holds OCP certification for Oracle 9i, 10g, and 11g. He was awarded the status of Oracle ACE Director in March 2014.

Jim is also a sought-after public speaker on Oracle Database technology features. He has presented topics at Oracle OpenWorld, IOUG’s COLLABORATE, Hotsos Symposium, Oracle Technology Network ACE Tours, and Oracle User Group conferences around the world.

He has taught the core Oracle University database administration courses on behalf of Oracle and its Education Partners throughout the United States and Canada, instructing several hundred Oracle DBAs since 2005. He was selected as Oracle Education PartnerInstructor of the Year in 2009.

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.

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

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.