Oracle Database 12c

D93517 : Oracle Database 12c R2: New Features for 12c R1 Administrators

Course Duration

5 Days

Delivery

ILT VILT

Overview

Overview Course Curriculum Training Schedule Exam & Certification FAQs

The Oracle Database 12c R2: New Features for 12c R1 Administrators course is designed for existing 12c Release 1 DBAs. In addition to covering the New Features of R2, this course also introduces students to the Oracle Database Cloud Service.

Learn To:

Create and manage application containers and applications in multitenant container databases.
Manage resources in a multitenant container database and pluggable databases with Resource Manager performance profiles and new memory directives.
Perform pluggable database flashback.
Upgrade the multitenant container databases and pluggable databases.
Manage security by using enhancements in unified auditing, system privileges, Privilege Analysis, Data Redaction, Transparent Sensitive Data Protection and
Transparent Data Encryption.
Manage data availability by using Recovery Manager, Oracle Data Pump features and SQL*Loader enhancements, and by performing enhanced online operations.
Increase the SQL performance by using the In-Memory Column-Store enhancements at deployment and SQL performance.
Tune the SQL performance by using the Optimizer Statistics Advisor and SQL join processing.
Monitor your databases by using DB operations enhancements.
Benefit from enhancements in partitioning methods.
Benefit from ADR automatic space file management.
Use the Trace File Analyzer collector to diagnose issues.
Use the new SQL*Plus history commands and SQL enhancements such as long identifiers.
Use the new SQLcl utility to benefit from commands and features missing from SQL*Plus itself.
Describe the Oracle Public Cloud services related to databases management.

What You'll Learn

Upon completing this course, the learner will be able to meet these overall objectives:

Perform recovery and flashback operation on pluggable databases
Monitor multitenant container database and pluggable databases by using ADDM / AWR enhancements at PDB level
Manage resources in a multitenant container database and pluggable databases with Resource Manager performance profiles
Tune the SQL performance by using the Optimizer Statistics Advisor and SQL join processing
Benefit from enhancements in partitioning methods
Use the ADR automatic file space management
Use the SQLcl new utility as the new SQL command line interface
Create pluggable databases with new methods and local UNDO mode
Create and manage application containers and applications in multitenant container databases
Manage security in application containers
Manage data optimization in pluggable databases with heat map statistics and ADO policy eviction
Upgrade pluggable databases and multitenant container databases
Manage security by using enhancements in unified auditing, system privileges, Privilege Analysis, Data Redaction, Transparent Sensitive Data Protection &
Data Encryption
Manage data availability by using Recovery Manager, Oracle Data Pump features and SQL*Loader enhancements and by performing online operations
Monitor your databases by using DB operations
Increase the SQL performance by using In-Memory Column-Store enhancements for deployment and SQL performance

Who Should Attend

Database Administrators
System Administrator
Support Engineer
Technical Consultant

Prerequisites

Knowledge of Oracle Database 12c and particularly 12.1.0.2
Oracle Database 12c R1: New Features for Administrators Ed 2

Suggested Prerequisites:

Oracle Database 12c: Install and Upgrade Workshop
Using Oracle Enterprise Manager Cloud Control 12c Ed 2

Learning Journey

Coming Soon...

Module 1: Introduction
Module 2: Application Containers and Applications
Module 3: Security in PDBs
Module 4: PDBs Creation Using New Methods
Module 5: PDBs Recovery and Flashback
Module 6: Performance in PDBs
Module 7: Upgrade and Other Operations in PDBs
Module 8: Privileges and User Profiles
Module 9: Unified Auditing
Module 10: Data Redaction
Module 11: Data Encryption
Module 12: Transparent Sensitive Data Protection
Module 13: Availability Enhancements
Module 14: Oracle Data Pump, SQL*Loader and External Tables
Module 15: In-Memory Column Store
Module 16: SQL Tuning
Module 17: Resource Manager and Other Performance Enhancements
Module 18: Partitioning
Module 19: Manageability
Module 20: Diagnosability
Module 21: Oracle Database Cloud Services
Module 22: SQL Enhancements

This course is not associated with any Certification.

Frequently Asked Questions (FAQs)

Why get Oracle certified?

Oracle certifications are globally recognized credentials that validate your expertise in Oracle technologies and solutions.
Whether your focus is on database administration, cloud infrastructure, Java development, or other Oracle products, these certifications demonstrate your skills and knowledge to employers, enhancing your career prospects and earning potential.
Oracle-certified professionals are highly sought after in the IT industry for their ability to design, implement, and manage complex Oracle environments.
What to expect for the examination?

Oracle certification exams assess your knowledge and skills in specific Oracle technologies and products.
Exams typically consist of multiple-choice questions, and some may include performance-based questions or simulations that test your ability to apply your knowledge in real-world scenarios.
Note: Certification requirements and policies may be updated by Oracle from time to time. We apologize for any discrepancies; do get in touch with us if you have any questions.
How long is Oracle certification valid for?

The validity period of Oracle certifications varies depending on the specific certification:
Cloud Application Certifications: Valid for 18 months from the date of passing the exam. To maintain your credential, you must take the Delta version of the exam before the 18 months expire.
Oracle Cloud Infrastructure (OCI) Certifications: OCI certification credentials are now valid for 2 years (previously 18 months), enabling users to learn and certify on multiple OCI technologies.
Oracle Database Certifications: If you hold a retiring Oracle Database credential that requires recertification, you must upgrade to a current version within twelve (12) months following retirement to keep your credential in active status.
Note: Certification requirements and policies may be updated by Oracle from time to time. We apologize for any discrepancies; do get in touch with us if you have any questions.
Why take this course with Trainocate?

Here’s what sets us apart:
- Global Reach, Localized Accessibility: Benefit from our geographically diverse training hubs in 16 countries (and counting!).
- Top-Rated Instructors: Our team of subject matter experts (with high average CSAT and MTM scores) are passionate to help you accelerate your digital transformation.
- Customized Training Solutions: Choose from on-site, virtual classrooms, or self-paced learning to fit your organization and individual needs.
- Experiential Learning: Dive into interactive training with our curated lesson plans. Participate in hands-on labs, solve real-world challenges, and take on comprehensive assessments.
- Learn From The Best: With 30+ authorized training partnerships and countless awards from Microsoft, AWS, Google – you're guaranteed learning from the industry's elite.
- Your Bridge To Success: We provide up-to-date course materials, helpful exam guides, and dedicated support to validate your expertise and elevate your career.

Keep Exploring

Course Curriculum

Training Schedule

Exam & Certification

FAQs

Frequently Asked Questions

Improve yourself and your career by taking this course.

Enroll Now

More Courses By Oracle

Browse All Courses

Oracle Database 18c

D93517 : Oracle Database 12c R2: New Features for 12c R1 Administrators

What You'll Learn

Who Should Attend

Prerequisites

Learning Journey

Frequently Asked Questions (FAQs)

Why get Oracle certified?

What to expect for the examination?

How long is Oracle certification valid for?

Why take this course with Trainocate?

Keep Exploring

Course Curriculum

Training Schedule

Exam & Certification

Frequently Asked Questions

Improve yourself and your career by taking this course.

More Courses By Oracle

Oracle Database 18c: Administration Workshop

Java Performance Tuning and Optimization

Oracle Application Express Workshop I Ed 2

Ready to Take Your Business from Great to Awesome?

Request More Information