June 2015
Intermediate
4h 8m
English
Overview
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.
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 writes regularly about the myriad facets of Oracle database administration, with over a hundred articles to his credit since 2003. (Find them at databasejournal.com and ioug.org.) Jim’s blog, Generally…It Depends (http://jimczuprynski.wordpress.com), is a series of observations on all things Oracle.
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
- 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
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.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Watch now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.