Advanced Oracle 12c for Administrators

Advanced Oracle 12c for Administrators

Bascom Bridge’s Advanced Oracle 12c for Administrators training teaches students how to handle challenges that require more than just a basic understanding of database administration. Attendees learn advanced administration, security, and storage techniques, as well as heat map tracking, data redaction, and more.

 

ORACLE 12C FOR ADMINISTRATORS TRAINING OBJECTIVES

Students will learn how to:

  • Set metric and alert thresholds
  • Use globalization features within the database
  • Work with database connection and session options
  • Manage automatic databases
  • Automatically resume database operations after failures and errors
  • Protect data-at-rest in the database using Transparent Data Encryption
  • Protect data en route with Oracle Net Services encryption
  • Use advanced compression techniques for tables and indexes
  • Understand columnar vs. row-oriented database storage
  • Use heat map tracking for areas of the database that could be targeted for optimization
  • Manage ILM data
  • Optimize automatic data and policies
  • Implement custom ILM storage management policies
  • Use in-memory storage of database objects
  • Archive inactive data
  • Introduce temporal validity into a table
  • Redact data

ORACLE 12C FOR ADMINISTRATORS TRAINING PREREQUISITES

Students should have taken Bascom Bridge’s  Oracle 12c for Administrators training or have equivalent experience.

ORACLE 12C FOR ADMINISTRATORS TRAINING MATERIALS

All students receive comprehensive courseware and a related textbook.

SOFTWARE NEEDED FOR EACH PC:

  • Intel dual core i5 or faster processor on a 64-bit operating system with at least 4 GB RAM
  • A complete installation of Oracle 12c
  • Please contact us for detailed setup instructions if you have purchased this class
  • For classes delivered online, all participants need either dual monitors or a separate device logged into the online session so that they can do their work on one screen and watch the instructor on the other. A separate computer connected to a projector or large screen TV would be another way for students to see the instructor’s screen simultaneously with working on their own.

ORACLE 12C FOR ADMINISTRATORS TRAINING OUTLINE

  • Introduction
  • About Advanced Database Administration
    • Database Feature Usage
    • Server Alert Framework
    • Managing The Server Alerts Using EM CC
    • pDB Level Alerts
  • Advanced Administration: Globalization
    • Globalization Settings
    • Managing NLS Settings
    • Date & Time Localization
    • Linguistic Sorting & Matching
    • Linguistic Indexes
    • About Locale Builder
  • Advanced Administration: Database Connections & Shared Servers
    • Connection & Session Options
    • Shared Servers Architecture
    • Comparing Shared Servers & Dedicated Servers
    • Configure Shared Servers
    • Use Shared Servers
    • Monitor Shared Servers
  • Advanced Security: Database Security Threats
    • Potential Threats
    • Potential Attackers
    • The Threat Matrix
    • Database Security Checklist
  • Advanced Security: Encryption Concepts
    • About Encryption
    • Data-At-Rest Encryption
    • Data-In-Transit Encryption
    • Data-En-Route Encryption
    • Encryption Limitations
    • Encryption Algorithms & Potential Weaknesses
    • Managing Encryption Keys
  • Advanced Security: TDE Keystore Management
    • About Transparent Data Encryption
    • The SYSKM Administrator
    • TDE Encryption Algorithms
    • Understanding How Column Encryption Works
    • Understanding How Tablespace Encryption Works
    • Is TDE Unbreakable?
    • Managing TDE
    • Managing The Keystore
    • Managing A Wallet Keystore Using SQL
    • Managing A Wallet Keystore Using EM CC
    • Managing A Wallet Keystore Using OWM
    • Advanced Management Options
    • Keystore Backups
    • Migrate To HSM Keystore
    • Wallet Open Options
    • Regenerate Master Encryption Key
  • Advanced Security: TDE Data Encryption
    • Implement Tablespace Encryption
    • Implement Column Encryption
    • Assessing Encryption Usage
  • Advanced Security: Oracle Net Services Encryption & Security
    • Network-Launched Attacks
    • Limiting Database Attacks
    • Preventing Denial-of-service Attacks
    • Avoiding Disclosure Of Vulnerabilities
    • Oracle Net Services User Notifications
    • Oracle Net Native Encryption
    • Implementation With Oracle Net Manager
    • Implementation With sqlnet.ora
  • Advanced Storage: Space Management
    • Space Management Best Practices
    • Segment Storage Specifications
    • Estimate & Track Space Usage
    • Resumable Space Allocation
    • Enable A Resumable Session
    • Detect A Suspended Session
    • Resuming A Session
    • Using DBMS_RESUMABLE()
    • Deferred Segment Creation
  • Advanced Storage: The Segment Advisor
    • About The Segment Advisor
    • Using The SHRINK SPACE Option
    • Segment Advisor Within EM CC
    • The Automatic Segment Advisor  Programmatic Segment Advisor
  • Advanced Compression
    • About Compression
    • Table Compression
    • Basic Table Compression
    • Advanced Row Compression
    • Additional Table Compression Considerations
    • Index Compression
    • Key Compression
    • Advanced Index Compression
    • Hybrid Columnar Compression
    • Compression Analysis
    • Using SQL Metadata Queries
    • Using DBMS_COMPRESSION()
    • Using EM CC
  • Heat Map Tracking & Automatic Data Optimization (ADO)
    • About ILM
    • The Oracle Database & ILM Support
    • Heat Map Tracking
    • Automatic Data Optimization (ADO)
    • Adding ADO Policies Using SQL
    • Managing ADO Policies Using SQL
    • Managing ADO Policy Evaluation
    • Managing ADO Policies Using EM CC
  • In-Memory Storage
    • About Traditional Table Caching
    • Big Table Caching
    • Full Database Caching
    • In-Memory Column Store
    • IMCS Internals . Configuring The IMCS
    • Assigning Objects To The IMCS
    • Assigning Columns To The IMCS
    • Monitoring IMCS Using EM CC
  • In-Database Archiving
    • About In-Database Archiving
    • In-Database Archival Tables
    • In-Database Archiving Of Rows
    • Temporal Validity
  • Data Redaction
    • About Data Redaction
    • The Redaction Functions
    • Using Function Type dbms_redact.random
    • Using Function Type dbms_redact.partial
    • Function Type dbms_redact.partial Shortcuts
    • Using Function Type dbms_redact.regexp
    • Function Type dbms_redact.regexp Shortcuts
    • Defining Redaction Policies
    • Managing Redaction Policies
    • Customizing Full Redaction
    • Viewing Redaction Metadata
    • Using EM Cloud Control
    • Inference Attacks
  • Conclusion

Send a Comment

Your email address will not be published.

CONTACT US

+91 9376007676  

INQUIRY NOW


,

Advanced Oracle 12c for Administrators

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...
  • Course No : ORC-336
  •  Theory : 40%
  •  Lab : 60%
  • Duration : 30 hours

Students should have taken Bascom Bridge’s  Oracle 12c for Administrators training or have equivalent experience.

Scroll Up
Skip to toolbar