Overview of Course

Oracle Database 12c: Admin, Install and Upgrade Accelerated course provides essential knowledge and skills to install, configure, administer, and upgrade Oracle Database 12c.
 

Watch Full Course



Course Highlights

Highlight Icon

Hands-on training with expert instructors

Highlight Icon

In-depth coverage of installation, configuration, and administration of Oracle Database 12c

Highlight Icon

Detailed discussions on Oracle Database architecture, backup and recovery, and performance tuning




Key Differentiators

  • Checked Icon

    Personalized Learning with Custom Curriculum

    Training curriculum to meet the unique needs of each individual

  • Checked Icon

    Trusted by over 100+ Fortune 500 Companies

    We help organizations deliver right outcomes by training talent

  • Checked Icon

    Flexible Schedule & Delivery

    Choose between virtual/offline with Weekend options

  • Checked Icon

    World Class Learning Infrastructure

    Our learning platform provides leading virtual training labs & instances

  • Checked Icon

    Enterprise Grade Data Protection

    Security & privacy are an integral part of our training ethos

  • Checked Icon

    Real-world Projects

    We work with experts to curate real business scenarios as training projects

Contact Learning Advisor!

Inquiry for :
SKILLZCAFE



Skills You’ll Learn

#1

Installation, configuration, and administration of Oracle Database 12c

#2

Oracle Database architecture and backup and recovery techniques

#3

Performance tuning, security, and troubleshooting techniques

Training Options

Training Vector
Training Vector
Offer Vector

1-on-1 Training

USD 950 / INR 80000
  • Option Item Access to live online classes
  • Option Item Flexible schedule including weekends
  • Option Item Hands-on exercises with virtual labs
  • Option Item Session recordings and learning courseware included
  • Option Item 24X7 learner support and assistance
  • Option Item Book a free demo before you commit!
Offer Vector

Corporate Training

On Request
  • Option Item Everything in 1-on-1 Training plus
  • Option Item Custom Curriculum
  • Option Item Extended access to virtual labs
  • Option Item Detailed reporting of every candidate
  • Option Item Projects and assessments
  • Option Item Consulting Support
  • Option Item Training aligned to business outcomes
For Corporates
vectorsg Unlock Organizational Success through Effective Corporate Training: Enhance Employee Skills and Adaptability
  • Choose customized training to address specific business challenges and goals, which leads to better outcomes and success.
  • Keep employees up-to-date with changing industry trends and advancements.
  • Adapt to new technologies & processes and increase efficiency and profitability.
  • Improve employee morale, job satisfaction, and retention rates.
  • Reduce employee turnovers and associated costs, such as recruitment and onboarding expenses.
  • Obtain long-term organizational growth and success.

Course Reviews

Curriculum

  • (Overview, Architecture, Editions)
  • Explain the fundamentals of Oracle database 12c including architecture, and editions.

  • Hardware and Software Requirements, Pre-installation Tasks
  • Learn about the hardware and software requirements for Oracle database 12c installation and perform pre-installation tasks.
     

  • Installation types, Installation process
  • Understand various types of Oracle database 12c installation, and learn how to install and configure the database.

  • Database architecture, Memory Management, Processes
  • Get an in-depth knowledge of the database architecture and how to manage memory, and processes.

  • Backup types, Recovery process, Flashback technology)
  • Learn about various backup and recovery techniques and use flashback technology for restoring databases.

  • Upgrade methods, Post-upgrade tasks
  • Learn about upgrade methods and tasks to be performed post-upgrade to ensure database stability.

  • Initialization Parameter Files
  • Starting an Oracle Database Instance
  • Shutting Down an Oracle Database Instance
  • Viewing Log Files
  • Using Trace Files
  • Using the Dynamic Performance Views
  • Data Dictionary

  • Oracle Net Services Overview
  • Oracle Net Listener Overview
  • Establishing Oracle Network Connections
  • Connecting to a Server
  • Tools for Configuring and Managing the Oracle Network
  • Using the Listener Control Utility
  • Using Oracle Net Configuration Assistant
  • Using Oracle Net Manager

  • Database User Accounts (overview)
  • Predefined Administrative Accounts
  • Creating a User
  • Authentication
  • Unlocking a User Account and Resetting the Password
  • Privileges
  • Roles
  • Profiles

  • Understanding Storage of Data
  • Database Block contents
  • Exploring the Storage Structure
  • Creating a New Tablespace
  • Overview of Tablespaces Created by Default
  • Managing Tablespaces
  • Viewing Tablespace Information
  • Using Oracle Managed Files

  • Space Management Overview
  • Block Space Management
  • Row Chaining and Migration
  • Free Space Management Within Segments
  • Types of Segments
  • Allocating Extents
  • Allocating Space
  • Creating Tables Without Segments

  • Undo Data Overview
  • Transactions and Undo Data
  • Storing Undo Information
  • Comparing Undo Data and Redo Data
  • Managing Undo
  • Configuring Undo Retention
  • Guaranteeing Undo Retention
  • Changing an Undo tablespace to a Fixed Size

  • Overview of Locks
  • Locking Mechanism
  • Data Concurrency
  • DML Locks
  • Enqueue Mechanism
  • Lock Conflicts
     

  • Separation of Responsibilities
  • Database Security
  • Monitoring for Compliance
  • Standard Database Auditing
  • Unified Audit Data Trail
  • Separation for Duties for Audit Administration (AUDIT_ADMIN and AUDIT_VIEWER roles)
  • Configuring the Audit Trail
  • Specifying Audit Options

  • Categories of Failures
  • Flashback Technology
  • Understanding Instance Recovery
  • Phases of Instance Recovery
  • Tuning Instance Recovery
  • Using the MTTR Advisor
  • Comparing Complete and Incomplete Recovery
  • Oracle Data Protection Solutions
     

  • Configuring for Recoverability
  • Configuring the Fast Recovery Area
  • Multiplexing the Control File
  • Online Redo Log File
  • Multiplexing the Online Redo Log File
  • Archived Redo Log Files
  • Archiver Process
  • Archived Redo Log File Naming and Destinations

  • Backup Solutions Overview Oracle Secure Backup (over
  • Oracle Secure Backup (overview)
  • User Managed Backup (overview)
  • Backup Terminology and Types of Backups
  • Using Recovery Manager (RMAN)
  • Configuring Backup Settings
  • Oracle-Suggested Backup
  • Backing Up the Control File to a Trace File

  • Data Recovery Advisor
  • Loss of a Control File
  • Loss of a Redo Log File
  • Loss of a Datafile in NOARCHIVELOG Mod
  • Loss of a Noncritical Datafile in ARCHIVELOG Mode
  • Loss of a System-Critical Datafile in ARCHIVELOG Mode

  • Moving Data: General Architecture
  • Oracle Data Pump
  • SQL*Loader
  • External Tables
     

  • Database Maintenance (overview)
  • Viewing the Alert History
  • Terminology
  • Automatic Workload Repository (AWR)
  • Statistic Levels
  • Automatic Database Diagnostic Monitor (ADDM)
  • Advisory Framework
  • Enterprise Manager and Adviso

  • Performance Monitoring
  • Tuning Activities
  • Performance Planning
  • Monitoring Performance
  • Managing Memory
     

  • Database as a Service Architecture, Features and Tooling
  • Software Editions: Included Database Options and Management Packs
  • Automated Database Provisioning
  • Managing the Compute Node Associated With a Database Deployment
  • Managing Network Access to Database as a Service
  • Enabling Access to a Compute Node Port
  • Scaling a Database Deployment & Patching Database as a Service
  • Using the Oracle Database Cloud Service Console to Manage Patches
Hanger Icon
Contact Learning Advisor
  • RedtickMeet the instructor and learn about the course content and teaching style.
  • RedtickMake informed decisions about whether to enroll in the course or not.
  • RedtickGet a perspective with a glimpse of what the learning process entails.
Phone Icon
Contact Us
+91-9350-455-983
(Toll Free)
Inquiry for :
SKILLZCAFE

Description

Section Icon

Target Audience:

  • Database Administrators
  • Technical Consultants
  • System Administrator
Section Icon

Prerequisite:

  • Basic understanding of SQL and PL/SQL
  • Familiarity with Linux operating system
Section Icon

Benefits of the course:

  • Enhance your skills in managing Oracle Database 12c
  • Increase your earning potential with a valuable certification
  • Learn from expert instructors with hands-on training
Section Icon

Exam details to pass the course:

  • Exam Name: Oracle Database 12c Administrator Certified Associate (OCA)
  • Exam Code: 1Z0-062
  • Number of Questions: 67
  • Exam Duration: 120 minutes
     
Section Icon

Certification path:

  • Oracle Database 12c Administrator Certified Associate (OCA)
  • Oracle Database 12c Administrator Certified Professional (OCP)
  • Oracle Database 12c Maximum Availability Certified Expert (MACE)
     
Section Icon

Career options:

  • Database Administrator
  • Database Consultant
  • Technical Consultant
     

Why should you take this course from Skillzcafe:

Skillzcafe
Why should you take this course from Skillzcafe:
  • Bullet Icon Expert instructors with years of industry experience
  • Bullet Icon Hands-on training with real-world scenarios
  • Bullet Icon Comprehensive curriculum with in-depth coverage
  • Bullet Icon Flexible learning options

FAQs

Familiarity with basic database concepts and SQL is recommended.

Yes, this course is suitable for beginners as well as experienced professionals.

This course covers topics such as installation, configuration, upgrading, backup and recovery, database security, and performance tuning.

Question Vector
Equip your employees with the right skills to be prepared for the future.

Provide your workforce with top-tier corporate training programs that empower them to succeed. Our programs, led by subject matter experts from around the world, guarantee the highest quality content and training that align with your business objectives.

  • 1500+

    Certified Trainers

  • 200+

    Technologies

  • 2 Million+

    Trained Professionals

  • 99%

    Satisfaction Score

  • 2000+

    Courses

  • 120+

    Countries

  • 180+

    Clients

  • 1600%

    Growth