Shopping Cart
Your Cart is Empty
View Cart
  
 
 
 
Oracle 12c
Oracle 11g
Oracle Internet Application Developer - Forms & Reports
Oracle Fusion Middleware AS & BI - Discoverer
Oracle 10g
Oracle Certification
Microsoft VBA & Office
Other
Free Oracle Training Software
Virtual Training With Sideris Courseware Textbooks
Train-the-trainer Workshops & Training
Press room: Sideris Courseware in the news
About the Authors
Frequently Asked Questions (FAQ)
Contact Sideris
International Sales & Support
 
 
Textbooks & Training Courseware for
Information Technology Professionals

Oracle, Microsoft Office & VBA programming training materials

 
 
 
 
 


 
 
Our consultants give a faster return on investment with expertise in Oracle, agile software testing, web design & software implementation. Oracle consultants can help you succeed with architecture, testing, planning, implementation, upgrade, & migration. Our background in various desktop and mobile platforms, browsers, and applications enable our agile QA analysts to jumpstart your QA department. Our web designers' background in HTML, CSS, & PHP will complement your UI/UX design teams. For more information.
 
Sideris Oracle trainers have years of experience as subject matter experts. Our consultants and trainers are available to deliver on-site or online 'train-the-trainer' training. For more information on training in Oracle SQL and PL/SQL database development, coding and tuning, database administration, data warehousing, business intelligence (BI) and data modeling. The latest technology training for the Oracle 12c multitenant database, Oracle Enterprise Manager 12c Cloud Control and OBIEE, RMAN backup and recovery are all available.
The Oracle library produced by Sideris Courseware Corporation has been acquired by one of the most prestigious IT training materials providers in the world, Logical Operations. This is an exciting development for both organizations, and for the library that we have created. Click here to be redirected to the Logical Operations web store to purchase Sideris Oracle textbooks. Sideris is now available to assist you with consulting and/or training opportunities using our subject matter experts who wrote this library.
 
  .   .    
 
 
     
Training textbooks for Oracle 12c Oracle Certified Professional (OCP), Database, Oracle Enterprise Manager 12c Cloud Control, Oracle WebLogic Server 12c, SQL, PL/SQL, Oracle Cloud DBaaS, PaaS
Oracle Database 12c: Administration Workshop II
 

Oracle Database 12c: Administration Workshop II (5 days)

Description

This training textbook considers advanced features for Oracle 12c database administrators. Like any major software platform, the management of an Oracle database in a production environment can present challenges. Responding to those challenges requires more than just a basic understanding of database administration.

eTextbook Available

See the list of related eTextbook items for an electronic version of this textbook.

Target Audience

The primary target audiences for this textbook are:
  • Database administrators
  • Storage administrators
  • System administrators
  • Implementation specialists
  • Data center support engineers

About This Series

This textbook is part of the Sideris Oracle Certified Professional (OCP) Administrator series, which in turn is one of the learning paths from the Sideris Oracle 12c administration curriculum.

Prerequisites

The entire Oracle database administrator curriculum, including this textbook that you are now reading, has these prerequisites from the Sideris Textbook Series For Oracle Database Developers. Equivalent experience is also acceptable.
  • ORACLE DATABASE 12C: SQL FUNDAMENTALS (LEVELS I & II)
  • ORACLE DATABASE 12C: PL/SQL FUNDAMENTALS (LEVELS I & II)
With regard to this text and its position within the Sideris Textbook Series For Oracle Administrators these are the required prerequisites, or equivalent experience:
  • ORACLE DATABASE 12C: INSTALL & UPGRADE WORKSHOP
  • ORACLE DATABASE 12C: ARCHITECTURE & INTERNALS
  • ORACLE DATABASE 12C: ADMINISTRATION WORKSHOP

Certification

This textbook considers subjects helpful for certification as an Oracle Database 12c Administrator Certified Professional (OCP) for "Exam: 1Z0-063: Oracle Database 12c: Advanced Administration".

Content Summary

  • Volumes: 2
  • Pages: 906
  • Hands-On Workshops: 13
  • Exercises: 109

Suggested Next Textbooks

Readers may next wish to proceed onto these textbooks from this textbook series:
  • ORACLE DATABASE 12C: BACKUP & RECOVERY WORKSHOP
  • ORACLE DATABASE 12C: RESOURCE MANAGER & SCHEDULER
  • ORACLE DATABASE 12C: MANAGE THE MULTITENANT ARCHITECTURE

Target Audience

The primary target audiences for this textbook are:
  • Database administrators
  • Storage administrators
  • System administrators
  • Implementation specialists
  • Data center support engineers

Objectives

Within this textbook we will explore these topics:
  • Setting metric and alert thresholds for proactive database monitoring by the server alert framework.
  • Globalization features within the database to support applications in multiple languages, currencies, time zones and countries.
  • Database connection and session options that support thousands of concurrent users, including a shared servers configuration.
  • Automatic database management, monitoring and tuning facilities. Included are automatic management of storage space and memory resources within the database and the role of the Segment Advisor and Memory Advisors.
  • Automatic resumption of database operations even in the face of storage space allocation failures and errors.
  • Protecting data-at-rest in the database using the advanced data security feature Transparent Data Encryption, as well as a solid overview of underlying encryption technologies, protocols and algorithms.
  • Protecting data en route with Oracle Net Services encryption.
  • An introduction to advanced space management topics, including custom space management attributes, resumable space allocation and other subjects.
  • Advanced compression techniques for tables and indexes.
  • Columnar vs. row-oriented database storage and the use of hybrid columnar compression.
  • Heat map tracking of segment access to measure hot, warm and cold areas of the database that could be targeted for optimization.
  • ILM data management and support for that framework with available features of the Oracle database.
  • Automatic data optimization and policies that automatically implement the ILM concepts of row-level compression tiering, segment-level compression tiering and segment-level storage tiering.
  • Implementing custom ILM storage management policies.
  • In-memory storage of database objects, including big table caching, full database caching and in-memory column stores.
  • Archiving inactive data inside the database while not degrading performance while limiting added storage costs.
  • Introduce temporal validity into a table and perform flashback query operations using temporal validity criteria.
  • Data redaction that allows data privacy policies to be dynamically enforced during queries.

Contents Overview

  • Advanced Administration: About Advanced Database Administration
  • Advanced Administration: Globalization
  • Advanced Administration: Database Connections & Shared Servers
  • Advanced Security: Database Security Threats
  • Advanced Security: Encryption Concepts
  • Advanced Security: TDE Keystore Management
  • Advanced Security: TDE Data Encryption
  • Advanced Security: Oracle Net Services Encryption & Security
  • Advanced Storage: Space Management
  • Advanced Storage: The Segment Advisor
  • Advanced Compression
  • Heat Map Tracking & Automatic Data Optimization (ADO)
  • In-Memory Storage
  • In-Database Archiving
  • Data Redaction
Download PDF outline