Trainer

22 yrs exp

Duration

40 Days

Recordings

60 Hrs

Material

Reading and LAB guide

Online LAB

Server 24x7 available

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 Overview

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

Lives 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 through pre-recorded video sessions delivered by experts with your own pace and timings

For Coporate Training, We provide customized content and delivered by industry experts with complete practical demonstration, discussions and exercises based on practical use cases.

Our Key Highlights

Unique Benefits included in this training

Key Benefits

Upcoming Batches

CLASSROOM TRAINING

This Course Includes:
  • Delivered by our experts having 22 yrs exp
  • 40 Live classroom sessions
  • Reading material and Lab activity guide
  • One-to-one dedicated server access for practice
  • 70 Hrs of Lab practices
  • 100% practical-oriented classes
  • Real-time projects and certification guidance
  • Get certificate on course completion
  • Job assistance
  • Certified technical assistance
11-Jan

10:30am - 12:30pm IST

MON - FRI

14-Jan

10:30am - 12:00pm IST

MON - FRI

18-Jan

10:30am - 12:00pm IST

MON - FRI

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

ONLINE TRAINING

This Course Includes:
  • Delivered by our experts having 22 yrs exp
  • 40 Virtual online sessions
  • Access for 60 Hrs of Recorded videos
  • Reading material and Lab activity guide
  • 24x7 dedicated online AksWave server access
  • 70 Hrs of Lab practices
  • 100% practical-oriented classes
  • Real-time projects and certification guidance
  • Get certificate on course completion
  • Job assistance
  • Technical support thru chat and email
21-Dec

8:30am - 10:00am IST

MON - FRI

23-Dec

8:30am - 10:00am IST

MON - FRI

27-Dec

8:30am - 10:00am IST

MON - FRI

20 % OFF 30,000/- $321 24,000/-

SELF-PACED LEARNING

This Course Includes:
  • Access for 20 Hrs of Recorded videos
  • Reading material and Lab activity guide
  • 24x7 dedicate online AksWave server access
  • 70 Hrs of Lab practices
  • Real-time projects and certification guidance
  • Technical support thru chat and email

18,000/-

Our Instructor

Demo Video

No Video Found

No Demo Video

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

Testimonials

Manoj Kumar

1 month ago

I recently took Oracle RAC training from Akswave. Akal Sir is one of the best teacher for Oracle RAC. I learned lot of concepts, understood well and he cleared many of my doubts too. His explanation and presentation is better and easy to understand. About online Lab environment its good and the Co-ordinators are very helpful in clearing my doubts. I personally enjoyed and learned many new things in AKSWAVE.

Ravi Krishna

5 months ago

I have taken classes from Akswave Oracle Training and I gained excellent knowledge in Oracle DBA , Oracle RAC and APPs from there. I recommend people who wants better future in Oracle DBA, join Akswave. Lets see when the GoldenGate classroom training will start, I like to join.

Azjad Hussain

10 months ago

Akswave Oracle Training is one of the best institute in Ameerpet, comparing to other institutes in terms of Lab Infrastructure , helping nature faculties and the amazing skilled Mr Akal singh. Now waiting for cloud training to be started.

Google Ratings

4.6

Facebook Ratings

4.9

Twitter Ratings

4.8