Course Overview

What will you learn?


  • Learn about the Oracle Database Architecture.
  • Create and manage an Oracle Database Instance.
  • Create and manage Storage Structures.
  • Configure the Oracle Network Environment.
  • Create and manage users.
  • Monitor the database and manage performance.
  • Develop backup and recovery procedures to address your business needs.
  • Implement backup and recovery settings and perform backup operations to disk and tape.
  • Employ Oracle Database recovery procedures to recover from media and other failures.
  • Diagnose and repair data failures.
  • Use Flashback Technologies and data duplication to complement backup and recovery procedures.
  • Secure the availability of your database by appropriate backup and recovery strategies.
  • Understand the multitenant architecture.
  • Create and manage a multitenant container database and pluggable databases.
  • Understand regular and application pluggable databases.
  • Manage storage within a multitenant container database and pluggable databases.
  • Manage security within a multitenant container database and regular and application pluggable databases.

Who should go for this training?
The following professionals can go for this course:

Who should go for this training?

The following professionals can go for this course:

  • Administrator
  • Architect
  • Database Administrator

What are the pre-requisites for this Course?

Oracle SQL and Linux Basics

Course Content


  • Describe the differences in Oracle Database editions, options, and packs
  • List the database offerings in Oracle Cloud
  • Explain the sample database that will be used in the course practices
  • List the major architectural components of Oracle Database
  • Explain memory structures
  • Describe background processes 
  • Correlate logical and physical storage structures
  • Describe multitenant architecture

  • Connect to an Oracle Database
  • Describe the tools used to access an Oracle Database
  • Describe the Oracle-supplied user accounts for Oracle Database
  • Query the data dictionary in an Oracle Database
  • Describe initialization parameter files and initialization parameters
  • View and modify initialization parameters in SQL*Plus
  • Start up and shut down Oracle databases
  • Open and close PDBs
  • Work with the Automatic Diagnostic Repository (ADR)
  • Query dynamic performance views
  • Describe Oracle Net Services
  • Explain how listeners work
  • Configure listeners for dynamic or static service registration
  • Configure local naming for database connections
  • Test Oracle Net connectivity with tnsping
  • Configure communication between databases by creating database links
  • Explain the difference between dedicated and shared server configurations
  • Create database users
  • Grant privileges to database users
  • Create and grant roles to users or other roles
  • Revoke privileges and roles from users and other roles
  • Create and assign profiles to users
  • Explain the various authentication options for users
  • Assign quota to users
  • Apply the principle of least privilege
  • Describe the methods and tools used to create PDBs
  • Create PDBs from seed by using SQL*Plus
  • Clone PDBs by using SQL*Plus
  • Unplug and plug in PDBs by using SQL*Plus
  • Drop PDBs by using SQL*Plus

Explain how table data is stored in the database

  • Use SQL*Plus to:

   Create and drop tablespaces

   Alter tablespaces

   View tablespace information

  • Implement Oracle Managed Files (OMF)
  • Use SQL*Plus to move and rename online data files
  • Implement tablespace encryption
  • Describe how the Oracle Database server automatically manages space
  • Save space by using compression
  • Proactively monitor and manage tablespace space usage
  • Describe segment creation in the Oracle database
  • Control deferred segment creation
  • Reclaim wasted space from tables and indexes by using the segment shrink functionality
  • Manage resumable space allocation
  • Explain DML and undo data generation
  • Monitor and administer undo data
  • Describe the difference between undo data and redo data
  • Configure undo retention
  • Guarantee undo retention
  • Enable temporary undo
  • Use the Undo Advisor
  • Describe ways to move data
  • Explain the general architecture of Oracle Data Pump
  • Use Data Pump Export and Import to move data between Oracle databases
  • Use SQL*Loader to load data from a non-Oracle database (or user files)
  • Use external tables to move data via platform-independent files
  • Describe methods that can be used to migrate databases to Oracle Database Cloud Service

Identify DBA responsibilities regarding database backup and recovery

Identify the types of failure that can occur in an Oracle database

Describe instance recovery

Describe complete and incomplete recovery

  • About Configuring the Environment for RMAN Backups
  • Configuring the Fast Recovery Area
  • Multiplex the control file
  • Multiplex redo log files
  • Configure ARCHIVELOG mode
  • Configuring the Backup Retention Policy
  • Backup Optimization and the CONFIGURE command
  • Configuring an Archived Redo Log Deletion Policy
  • Overview of the RMAN Environment
  • Starting RMAN and Connecting to a Database
  • Showing the Default RMAN Configuration
  • Backing Up a Database
  • Reporting on RMAN Operations
  • Maintaining RMAN Backups
  • Diagnosing and Repairing Failures with Data Recovery Advisor
  • Rewinding a Database with Flashback Database
  • Restoring and Recovering Database Files
  • About the RMAN Environment
  • About RMAN Command-Line Client
  • About RMAN Channels
  • About the RMAN Repository
  • About Media Management Using RMAN
  • About the Fast Recovery Area
  • About RMAN in a Data Guard Environment
  • About RMAN in a Recovery Appliance Environment
  • About Consistent and Inconsistent RMAN Backups
  • About Online Backups and Backup Mode
  • About Backup Sets
  • About RMAN Image Copies
  • About Multiple Copies of RMAN Backups
  • About RMAN Control File and Server Parameter File Autobackups
  • About RMAN Incremental Backups
  • About Backup Retention Policies
  • Overview of RMAN Backups
  • Specifying Backup Output Options
  • Backing Up Database Files with RMAN
  • Backing Up CDBs and PDBs
  • Backing Up Application Containers
  • Backing Up Sparse Databases with RMAN
  • Backing Up Archived Redo Logs with RMAN
  • Making and Updating RMAN Incremental Backups
  • Making Database Backups for Long-Term Storage
  • Backing Up RMAN Backups
  • Create consistent database backups
  • Back up your database without shutting it down
  • Create incremental backups
  • Overview of the RMAN Recovery Catalog
  • Creating a Recovery Catalog
  • Registering a Database in the Recovery Catalog
  • Cataloging Backups in the Recovery Catalog
  • Creating and Managing Virtual Private Catalogs
  • Protecting the Recovery Catalog
  • Managing Stored Scripts
  • Maintaining a Recovery Catalog
  • Dropping a Recovery Catalog
  • Determine the need for performing recovery
  • Describe and use available options, such as Recovery Manager (RMAN) and the Data Recovery Advisor
  • Recover data files
  • Restore and recover a DBCS database
  • Overview of Complete Database Recovery
  • Preparing for Complete Database Recovery
  • Performing Complete Database Recovery
  • Performing Complete Recovery of CDBs
  • Performing Complete Recovery of Application Containers
  • Performing Complete Recovery of Sparse Databases with RMAN
  • Overview of RMAN TSPITR
  • TSPITR Restrictions, Special Cases, and Limitations
  • Planning and Preparing for TSPITR
  • Running RMAN TSPITR:

       – Performing Fully Automated RMAN TSPITR

       – Overriding Defaults for RMAN TSPITR with an RMAN-Managed Auxiliary Database

       – Performing RMAN TSPITR Using Your Own Auxiliary Database

  • Troubleshooting RMAN TSPITR
  • Overview of Recovering Tables and Table Partitions from RMAN Backups
  • Preparing to Recover Tables and Table Partitions
  • Recovering Tables and Table Partitions
  • Recovering Tables and Table Partitions in PDBs
  • Examples: Recovering Tables and Table Partitions From RMAN Backups
  • Understand flashback technologies from various types of errors
  • Configure your database to use flashback technologies
  • Perform flashback query, version query, transaction backout
  • Perform flashback table, recyclebin, flashback data archive
  • Describe Flashback Database architecture
  • Configure your database to support Flashback Database
  • List the purposes and create duplicate database with RMAN
  • Duplicate a database based on a running instance
  • Describe the activities that you perform to manage database performance
  • Use Enterprise Manager Database Express and performance views to monitor database instance performance
  • Describe the Oracle performance tuning methodology
  • Describe the server statistics and metrics that are collected by the Oracle Database server
  • Configure and monitor memory components for optimal performance

  • Describe the SQL tuning methodology
  • Manage optimizer statistics
  • Use SQL Tuning Advisor to identify and tune SQL statements that are using the most resources
  • Use SQL Access Advisor to tune a workload

Modes of Training

Classroom Training

Live interactive sessions delivered in our classroom by our expert trainers with real-time scenarios.

Online Training

Learn from anywhere over internet, joining the live sessions delivered by our expert trainers.

Self-Pace Training

Learn thru pre-recorded video sessions delivered by experts with your own pace and timing.

Program Benefits

MULTIPLE BENEFITS C
CLASSROOM
O
ONLINE
R
RECORDINGS

Live Sessions by expert trainer

60hrs session recorded videos

Study and Practice course material

Lab practice environment (dedicated machine)

Help for preparing lab setup in students laptop
Guidance for oracle certification exams
100% learning satisfaction guaranteed

Upcoming Batches

Classroom Sessions

Not yet scheduled
Not yet scheduled
Not yet scheduled

Duration: 40 sessions

12,000/-
20,000/- save 40%

Online Sessions

Not yet scheduled
Not yet scheduled
Not yet scheduled

Duration: 40 sessions

24,000/- $329
28,000/- save 14%

Recorded Sessions

Recorded Videos : 60 hrs Video
Material : Study and Lab Material
lifetime
18,000/-
20,000/- save 10%

Our Trainers

Demo Video

No Records Found

Interview Questions

Lorem Ipsum is simply dummy text?

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry.

Lorem Ipsum is simply dummy text?

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry.

Lorem Ipsum is simply dummy text?

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum is simply dummy text of the printing and typesetting industry.

Certification Guidence

No Records Found

Faq

Each of our live sessions are recorded. In case if you miss any, you can request us to share the link of that particular session.

Once you get registered, our back-end team will share you the details to join the session live over online portal which can be accessed through a browser.

You can contact our support team, or just drop an email to [email protected] with your queries.

For practical execution, our trainer/technical team will provide server access details to the student.

The course material and recorded videos which are provided during the course period. You can download it anytime.

Yes. We do provide the step-by-step document which you can follow and if required our technical team will assist you.

Visit our website regularly to check discount offers time to time. However, we provide discount for single participant

& special discount for 2 or more participants.

Live-Online training is where you can have live session with the trainer and clarify queries parallelly.

Pre-recorded sessions are the recorded videos that will be provided to you so that you can see, listen and learn anytime at your feasible place. For doubts in the videos you can mail the trainer regarding the same.

  • If request for cancelation is made within 2 days of enrolment for class, 100% refunded.
  • If request made after 2 days, then Refund is made after deduction of administration fee.

Combo Offers

Pay less and learn more with our best combo courses. Avail more discount on multiple top trending technologies

Related Courses

Testimonials

Recently I took Oracle Golden gate and Exadata-X6 classroom training from AKSWAVE ORACLE TRAINIGS by Mr.Akal Singh good teaching and good Lab Environment.One of the Best Institute in Hyderabad.

-Venkatesh

Oracle DBA

This institute is a very good platform to build your career. Mr Akal Singh is one of the best teacher for Oracle DBA. in this institute lab facilities is very good.it is the best institute for 12c DBA and RAC.

-Sandeep Singh

DBA

Google Ratings

4.6

Facebook Ratings

4.9

Twitter Ratings

4.8

Course Enquiry

The Secret of getting ahead is getting started.

Classroom Sessions Online Sessions Recorded Sessions