Oracle Database 12c: New Features For Administrators Training in O' Fallon
Enroll in or hire us to teach our Oracle Database 12c: New Features For Administrators class in O' Fallon, Missouri by calling us @303.377.6176. Like all HSG
classes, Oracle Database 12c: New Features For Administrators may be offered either onsite or via instructor led virtual training. Consider looking at our public training schedule to see if it
is scheduled: Public Training Classes
Provided there are enough attendees, Oracle Database 12c: New Features For Administrators may be taught at one of our local training facilities.
We offer private customized training for groups of 3 or more attendees.
|
||
Course Description |
||
The single most important new capability introduced with the Oracle 12c
release of the database is the multitenant database feature. With this
technology, the Oracle database can be a full participant in a cloud
computing-based application architecture. Even a traditional on-premise
systems architecture can be dynamically and dramatically transformed as
a result of this feature. Many traditional and new database features are
enhanced or introduced when a multitenant database configuration is
used. Introduced with the Oracle 12c release of the database are many
advanced storage administration features. Some of these new features
support various forms of in-memory storage, advanced compression and
other capabilities targeted for high-performance environments and
massive scalability. --- This course covers the training content for
the 1Z0-060 Oracle Database 12c: New Features for Administrators exam.
Course Length: 5 Days
Course Tuition: $2400 (US) |
Prerequisites |
|
In order to fully benefit from this textbook one must have extensive experience working with the Oracle 11g release as a database or other administration specialist. |
Course Outline |
Oracle 12c & The Database Utilities
• About Oracle 12c
• Oracle 12c Universal Installer
• EM Cloud Control
• EM Database Express
• EM Database Express Framework & XML DB
• Access EM Database Express
• SQL Developer
• Instance Threaded Mode
• Invisible Columns
Database Security Enhancements
• Database Security Principles
• Database Privilege Changes
• Database Role Changes
• User Password Complexity
• Privilege Analysis
• Auditing Modes & Unified Auditing
• Configuring Unified Auditing & Enabling Policies
• Viewing & Maintaining The Audit Trail
ADR & Network Enhancements
• Fault Diagnosability Infrastructure
• Advanced Network Compression
Performance Improvements
• SQL Statement Execution
• Real-Time Operation Monitoring
• Real-Time ADDM Analysis
• Emergency Monitoring
• Real-Time ADDM
Fundamentals: The Multitenant Database Architecture
• Cloud Computing Principles
• Peering Into The Architecture
• Multitenant Database Instance
• Multitenant Storage Architecture
• Multitenant Data Dictionary
• Benefits Of The Architecture
• Challenges Of The Architecture
Fundamentals: Creating & Connecting To Multitenant Databases
• About cDB Capacity Planning
• cDB & pDB Creation
• Using Oracle Installer
• Using DBCA
• cDB & pDB Connections
• Using SQL*Plus
• EM Cloud Control
Fundamentals: Multitenant Database Security Management
• Multitenant Security Model
• Multitenant Privileges & Roles
• Common Users
• Local Users
• Common & Local Roles & Privileges
• Commonly & Locally Defined
• Commonly & Locally Granted
• Common & Local Profiles
• Common & Local Dictionary Access
• Multitenant Unified Auditing
• Local Audit Policies
• Querying The Unified Audit Trail
• Common Audit Policies
• Auditing Management With EM CC
Provisioning: Provisioning pDBs From pdb$seed
• Provision & Decommission pDBs
• EM CC Provisioning Prerequisites
• pDB File Location Prerequisites
• Provision A pDB From pdb$seed
• Provision Using SQL
• Provision Using EM CC
• Post Provisioning Checklist
• Drop A pDB
• Querying cDB & pDB Metadata
Provisioning: Additional pDB Provisioning
• Clone A pDB
• Unplug & Plug-In A pDB
• Migrate A Non-cDB To A pDB
• pDB Provisioning Using EM CC
• pDB Provisioning Using DBCA
Administration: Administering Multitenant Databases
• About Multitenant Administration
• cDB Administration
• cdb$root Administration
• pDB Administration
Administration: Multitenant Storage Management
• Manage Permanent Tablespaces
• Manage Temporary Tablespaces
Administration: Multitenant Backup & Recovery
• Devising Multitenant Recovery Plan
• RMAN Multitenant Usage
• RMAN Multitenant Backup
• EM CC Multitenant Backup
• RMAN Multitenant Recovery
• Complete Recovery
• Incomplete cDB / pDB Point-in-time Recovery (PITR)
• Incomplete Table Point-in-time Recovery (PITR)
• Multitenant Flashback Database
• EM CC Multitenant Recovery
• Multitenant Database Duplication
• cDB Duplication
• pDB Duplication
Administration: Multitenant Resource Management
• About Resource Management
• cDB Resource Plans & Directives
• pDB Resource Plans & Directives
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
|
Course Directory [training on all levels]
Technical Training Courses
Software engineer/architect, System Admin ... Welcome!
- .NET Classes
- Agile/Scrum Classes
- Ajax Classes
- Android and iPhone Programming Classes
- Blaze Advisor Classes
- C Programming Classes
- C# Programming Classes
- C++ Programming Classes
- Cisco Classes
- Cloud Classes
- CompTIA Classes
- Crystal Reports Classes
- Design Patterns Classes
- DevOps Classes
- Foundations of Web Design & Web Authoring Classes
- Git, Jira, Wicket, Gradle, Tableau Classes
- IBM Classes
- Java Programming Classes
- JBoss Administration Classes
- JUnit, TDD, CPTC, Web Penetration Classes
- Linux Unix Classes
- Machine Learning Classes
- Microsoft Classes
- Microsoft Development Classes
- Microsoft SQL Server Classes
- Microsoft Team Foundation Server Classes
- Microsoft Windows Server Classes
- Oracle, MySQL, Cassandra, Hadoop Database Classes
- Perl Programming Classes
- Python Programming Classes
- Ruby Programming Classes
- Security Classes
- SharePoint Classes
- SOA Classes
- Tcl, Awk, Bash, Shell Classes
- UML Classes
- VMWare Classes
- Web Development Classes
- Web Services Classes
- Weblogic Administration Classes
- XML Classes
Business Training Courses
Project Managers, Business Analysts, Paralegals ... Welcome!
Upcoming Classes
Gain insight and ideas from students with different perspectives and experiences.
- Introduction to C++ for Absolute Beginners
16 December, 2024 - 17 December, 2024 - Introduction to Spring 5 (2022)
16 December, 2024 - 18 December, 2024 - See our complete public course listing