Trainer

24 yrs exp

Duration

35 Sessions

Recordings

60 Hrs

Material

Reading and LAB guide

Online LAB

Server 24x7 available

Course Overview

What will you learn?

Our curriculum for Delhi candidates is designed to equip you with the comprehensive skills and knowledge required to excel in Oracle Database Administration. This program covers essential and advanced topics, preparing you for real-world DBA challenges.

Key Learning Areas:
  • Gain a deep understanding of Oracle's architecture and its components.
  • Creating and Managing an Oracle Database Instance
  • Develop expertise in managing storage, setting up networking, and handling user accounts.
  • Database Monitoring and Performance Management
  • Master backup strategies and recovery scenarios to safeguard your data.
  • Learn recovery techniques to handle media and system failures, minimizing downtime.
  • Implement Flashback technologies to restore and recover lost or corrupted data quickly.
  • Learn to create and manage multitenant architectures, including container and pluggable databases.
  • Gain hands-on experience with database cloning and set up Oracle Data Guard for disaster recovery solutions.
  • Learn best practices for installing Oracle software and applying critical patches to maintain database security.

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

The following professionals can go for this course:

  • Administrator
  • Architect
  • Database Administrator

What are the pre-requisites for this Course? Oracle SQL and Basics of Linux

Course Overview

Course Content

Expand All
  • Describe the differences in Oracle Database editions
  • 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
  • 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 and Drop PDBs by using SQL*Plus
  • 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 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
  • Create database users, Grant privileges to 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
  • 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 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
  • 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 & redo log files
  • Configure ARCHIVELOG mode
  • Configuring the Backup Retention Policy
  • Backup Optimization and the CONFIGURE command
  • Configuring an Archived Redo Log Deletion Policy
  • About the RMAN Environment
  • About RMAN Command-Line Client and Channels
  • About the RMAN Repository
  • About Media Management Using RMAN
  • About the Fast Recovery Area
  • About Consistent and Inconsistent RMAN Backups
  • About Online Backups and Backup Mode
  • About Backup Sets & Image Copies
  • About Multiple Copies of RMAN Backups
  • About RMAN Control File and Server Parameter File Autobackups
  • About RMAN Incremental Backups & Retention Policies
  • Overview of RMAN Backups
  • Specifying Backup Output Options
  • Backing Up Database Files with RMAN
  • Backing Up CDBs and PDBs
  • Backing Up Archived Redo Logs with RMAN
  • Making and Updating RMAN Incremental Backups
  • Making Database Backups for Long-Term Storage
  • 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
  • Managing Stored Scripts
  • Maintaining & dropping the Recovery Catalog
  • Determine the need for performing recovery
  • Describe and use available options, such as Recovery Manager (RMAN) and the Data Recovery Advisor and Recovery datafiles
  • Overview of Complete Database Recovery
  • Performing Complete Database Recovery
  • Performing Complete Recovery of CDBs
  • Performing Recovery of Non-Critical datafiles
  • Performing Recovery of Critical datafiles
  • Incomplete Recovery scenarios Loss of Redologs
  • Incomplete Recovery scenarios Loss of Controlfiles
  • Incomplete Recovery scenarios Loss of All Files
  • Overview of RMAN Incremental Backups
  • Performing Incremental Backups & recovery scenario
  • Performing point-in-time Recovery (PITR) scenarios
  • Troubleshooting backups using RMAN
  • List, report, croscheck and delete maintenance commands
  • Understand and configure your database to use flashback technologies
  • Perform FB query, version query, transaction backout
  • Perform FB table, recyclebin, flashback data archive
  • Describe Flashback Database architecture
  • Configure your database to support Flashback Database
  • Describe the activities to manage database performance
  • Use Enterprise Manager, Performance views, AWR and ADDM to monitor database instance performance
  • Describe the Oracle performance tuning methodology
  • Describe the server statistics and metrics collected
  • Overview ASMM & Automatic Memory Management (AMM) concepts
  • Configure automatic Memory Management

  • Describe the SQL tuning methodology
  • Collect and Manage Optimizer statistics
  • Use SQL Tuning Advisor to identify and tune SQL statements
  • Use SQL Access Advisor to tune a workload
  • Understand Optimizer & Execution Plan
  • DB Tracing ( Services, trcsess, tkprof ), DBMS_XPLAN
  • List the purposes and create duplicate database with RMAN
  • Duplicate a database based on a running instance
  • Understand Hiigh Availability and the requirement of Data Guard
  • Configure and Manage Dataguard Setup
  • Dataguard Roles, Modes and perform Switchover & Failover
  • Installing Oracle Linux and Oracle database software
  • Creating database using DBCA
  • Understand Database Patching & Upgrade
Download Brochure

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.

Contact Us

Our Key Highlights

Unique Benefits included in this training

  • BEST TRAINER : OCM Certified, 24 Yrs exp and delivered more than 600 batches
  • QUALITY CONTENT : More content including advance features covered better in Industry
  • ONLINE LAB : Online Server access provided for doing your LAB practices
  • BEST PRICE : Affordable and best competitive price in the market
  • RECORDINGS : High-quality sessions recordings access for referring multiple times
  • REALTIME SCENARIOS : Training contains projects on Real-time Scenarios to gain more confidence
Key Benefits

Upcoming Batches

CLASSROOM TRAINING

This Course Includes:
  • Delivered by our experts having 24 yrs exp
  • 40 Live classroom sessions
  • Access for Recorded videos
  • 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
26-Dec

9:00am to 10:30am IST

35 Days (Mon-Fri)

30-Dec

9:00am to 10:30am IST

35 Days (Mon-Fri)

02-Jan

9:00am to 10:30am IST

35 Days (Mon-Fri)

₹20,000/- ₹15,000/- 25%OFF

ONLINE TRAINING

This Course Includes:
  • Delivered by our experts having 24 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
25-Dec

9:00am to 10:30am IST

35 Days (Mon-Fri)

31-Dec

9:00am to 10:30am IST

35 Days (Mon-Fri)

03-Jan

9:00am to 10:30am IST

35 Days (Mon-Fri)

20 % OFF ₹ 30,000/- $283 ₹24,000/-

SELF-PACED LEARNING

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

₹18,000/-

Our Instructor

Akal Singh

Oracle Certified Master
  • 4.5 Instructor Rating
  • 2,852 Reviews
Akal Singh stands at the forefront of the fastest moving technologies in IT Industry. He spent his past 24 yrs experience as Oracle DBA with skills into DBA Support, High Availability Design & Implementations, Technical Solutions, Automation using Scripting, Database Designing & as a Corporate Trainer too. With deep technical industry knowledge, Akal Singh has implemented many real time projects on advance Database areas.

His certification list includes many OCP, Oracle Certified Expert/Specialist (OCE) and Oracle Certified Master (OCM). He is an expertise in OS Administrations, Virtualizations/VMWare and Oracle Database 8i/9i/10g/11g & 12c, RAC, Data Guard, ASM, Oracle Exadata, Oracle Performance Tuning, Golden Gate, Streams, Oracle Security & many more advance technologies.

Akal Singh is also recognized as Senior Corporate Instructor and worked with Oracle University training division providing more than 300 corporate trainings into database advance concepts.

Certifications include :
  • Oracle Certified Professional (OCP) 9i, 10g, 11g and 12c
  • Oracle Certified RAC Expert (OCE)
  • Oracle RAC 11g Release 2 and Grid Infrastructure Administration
  • Oracle Database 12c: RAC and Grid Infrastructure Administrator
  • Oracle 11g Exadata Certified Implementation Specialist
  • Oracle Exadata X5 Administration
  • Oracle Database 12c: RAC and Grid Infrastructure Administrator
  • Oracle 10g Certified Master (OCM)
  • Oracle Cloud Autonomous Database Specialist
  • Oracle Cloud Infrastructure Certified Associate
  • Foundation Certificate in IT Service Management (ITIL Certificate)

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 online@akswave.com 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

Oracle 12C DBA

Enroll Now

Classroom

Oracle 12C DBA +
RAC Administration
(548 Reviews)

 22,000/-

save 8%

 24000/-
RAC Administration

Enroll Now

Classroom

RAC Administration +
12c Goldengate
(312 Reviews)

 21,000/-

save 13%

 24000/-
RAC Administration

Enroll Now

Online

RAC Administration +
Exadata X8
(130 Reviews)

 40,000/-

save 26%

 54000/-
Oracle 12C DBA

Enroll Now

Classroom

Oracle 12C DBA +
Apps DBA 12.2
(311 Reviews)

 20,000/-

save 29%

 28000/-

Related Courses

View All Courses

Testimonials

Jyoti
10 months ago

Nice training

Manoj Kumar
3 years 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
3 years 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.

Google Ratings

4.6

Facebook Ratings

4.9

Twitter Ratings

4.8