Oracle DBA 12c | 19c Certification Training

Viswa Online Trainings is one of the world’s leading online IT training providers. We deliver a comprehensive catalog of courses and online training for freshers and working professionals to help them achieve their career goals and experience our best services.

4627 Reviews 4.9
4.7/5

Learners : 1080

Duration :  30 Days

About Course

Oracle DBA is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information. The database server is the key to solving the problems of information management. In general, a server reliably manages a large amount of data in a multiuser environment so that many users can concurrently access the same data. All this is accomplished while delivering high performance. A database server also prevents unauthorized access and provides efficient solutions for failure recovery. Enroll now and get certified in it.

Oracle DBA Training Course Syllabus

Exploring the 12c Oracle Database Architecture

✔ List the major architectural components of Oracle DBA

✔ Explain the memory structures

✔ Describe the background processes

✔ Understanding 12c multitenant architecture

✔ Exploring CDB and PDB databases

Installing 12c Oracle DBA Software

✔ Describe database administrator (DBA) role, explain typical tasks and tools
✔ Plan an Oracle software installation
✔ Install 12c Database software

Creating a Multitenant Oracle Database

✔ Plan database creation
✔ Create Multitenant Container and Pluggable Databases
✔ Create Oracle DBA using SQL Plus
✔ Understand database users & sample schemas

Managing the Oracle DBA Instance

✔ Managing database using Oracle Enterprise Manager & SQL*Plus
✔ Commonly used Initialization Parameters
✔ Manage database initialization parameters – SP file & P file
✔ Describe the stages of database startup
✔ Start and stop the Oracle database and components
✔ Viewing Alert log & manage Trace files
✔ Understand Data Dictionary Views
✔ Access dynamic performance views

Managing Database Storage Structures

✔ Storage Structures
✔ Segments, Extents & Oracle block
✔ Describe the storage of table row data in blocks
✔ Create and manage Tablespaces
✔ Tablespaces and Datafiles
✔ Managing Tablespaces in CDBs and PDBs
✔ Oracle Managed Files (OMF)
✔ Managing Temporary Tablespace

Oracle DBA User Security

✔ Create and manage database user accounts:

✔ Authenticate users
✔ Assign default storage areas (tablespaces)

✔ Grant and revoke privileges
✔ Create and manage roles
✔ Create and manage profiles

Managing Data Concurrency

✔ Describe locking mechanism and how Oracle manages data concurrency
✔ Monitor and resolve locking conflicts

Managing Undo Data

✔ Explain DML and undo data generation
✔ Monitor and administer undo data
✔ Difference between undo data and redo data
✔ Configure undo retention
✔ Guarantee undo retention
✔ Use the Undo Advisor

Configuring the Oracle Network Environment

✔ Oracle Net Services
✔ Configure Listener & Create Oracle Net Service aliases
✔ Configure connect-time failover
✔ Control the Oracle Net Listener
✔ Use tnsping to test Oracle Net connectivity
✔ Identify when to use shared servers and when to use dedicated servers
✔ Configuring Communication between Databases
✔ Connecting to another Database using DB Links

Backup and Recovery Concepts

✔ Identify the types of failure that can occur in an Oracle database
✔ Importance of checkpoints, redolog files, control files & archive log files
✔ Understanding what is COLD & HOT backup
✔ Configure ARCHIVELOG mode & Fast Recovery Area
✔ Invoke and configure Recovery Manager (RMAN)
✔ Specify Retention policy

Oracle DBA Use of RMAN Recovery Catalog & Configuring Backup Settings

✔ Usage of a Recovery Catalog over control file for the RMAN repository
✔ Create and configure a recovery catalog
✔ Register Database & Synchronize with recovery catalog
✔ Use RMAN stored scripts
✔ Enable control file autobackup
✔ Configure backup destinations
✔ Allocate channels for Disk & Tape destinations
✔ Configure backup optimization
✔ Create compressed & encrypted backups

Performing Database Backups with RMAN

✔ Create consistent database backups (offline/cold)
✔ Back up your database without shutting down (online/hot)
✔ Create image file backups
✔ Create a whole database backup
✔ Create a full database backup
✔ Enable fast incremental backup
✔ Create duplex backup sets
✔ Back up a backup set
✔ Create RMAN multi-section backup
✔ Create an archival backup for long-term retention
✔ Monitor Backup jobs, Manage backups and view backup reports
✔ Monitor the fast recovery area

Performing Database Recovery

✔ Determine the need for performing recovery
✔ Describe the causes of file loss and determine the appropriate action
✔ Describe major recovery operations

✔ Perform recovery:

✔ Control file
✔ Redo log file
✔ Data file

✔ Perform complete recovery when a critical or non-critical data file is lost
✔ Recover using incrementally updated backups
✔ Switch to image copies for fast recovery
✔ Recover using a backup control file

Oracle DBA Moving Data

✔ Describe ways to move data
✔ Create and use directory objects
✔ Use SQL*Loader to load data from a non-Oracle database (or user files)
✔ Use external tables to move data via platform-independent files
✔ Explain the general architecture of Oracle Data Pump
✔ Use Data Pump Export and Import to move data between Oracle databases

Using Flashback Technology I

✔ Describe Flashback technology
✔ Perform Flashback Query
✔ Use Flashback Version Query
✔ Perform Flashback Table operations
✔ Use Flashback Transaction Query

Using Flashback Technology II

✔ Describe and use Oracle Total Recall

✔ Creating and Managing Flashback Data Archive (FDA)

✔ Describe and use flashback recycle bins
✔ Configure Flashback Database
✔ Perform Flashback Database operations
✔ Monitor Flashback Database

Implementing Oracle DBA Auditing

✔ Describe DBA responsibilities for security and auditing
✔ Enable standard database auditing
✔ Specify audit options
✔ Review audit information
✔ Maintain the audit trail

Oracle DBA Maintenance

✔ Optimizer overview
✔ Manage optimizer statistics
✔ Manage the Automatic Workload Repository (AWR)
✔ Use the Automatic Database Diagnostic Monitor (ADDM)
✔ Describe and use the advisory framework
✔ Accessing & analyzing Active Session History data

Oracle DBA Performance Management

✔ Use performance-related dynamic view & EM to monitor performance

✔ Managing Memory:

✔ Describe the memory components in the SGA
✔ Implement Automatic Memory Management
✔ Manually configure SGA parameters
✔ Configure automatic PGA memory management

✔ Maintaining different types of Indexes
✔ Managing Partition Tables

Managing Performance by SQL Tuning

✔ SQL Tuning
✔ Row chaining & migration
✔ SQL trace, Tkprof, Explain plan
✔ Use the SQL Tuning Advisor to:

✔ Identify SQL statements that are using the most resources
✔ Tune SQL statements that are using the most resources

✔ Use the SQL Access Advisor to tune a workload

Diagnosing the Database

✔ Detect and repair database corruption
✔ Handle block corruption
✔ Set up Automatic Diagnostic Repository (ADR) & Run health checks

Managing Space

✔ 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
✔ Use the Segment Advisor
✔ Reclaim wasted space from tables and indexes by using segment shrink
✔ Manage resumable space allocation

Managing Space for the Database

✔ Use transportable tablespaces
✔ Describe the concepts of transportable databases

Managing the ASM Instance

✔ Describe the benefits of using ASM
✔ Manage the ASM instance
✔ Create and drop ASM disk groups
✔ Extend ASM disk groups
✔ Retrieve ASM metadata by using various utilities

Duplicating a Database / Cloning Database

✔ List the purposes of creating a duplicate database
✔ Choose a technique for duplicating a database
✔ Duplicate a database with RMAN

Data Guard

✔ Dataguard Architecture & background processes
✔ Configuring & Managing Dataguard
✔ Configuring Dataguard failover
✔ Managing switchover

Oracle DBA 12c New Features

✔ Multitenant Container Database and Pluggable Databases
✔ Managing Tablespaces and Users in CDB and PDBs
✔ Backup, Recovery, and Flashback CDBs and PDBs
✔ Automatic Data Optimization and Storage Enhancements
✔ In-Database Archiving and Temporal
✔ Privilege Analysis new feature and new administrative privileges
✔ ADR and Network enhancements
✔ Oracle Data Redaction
✔ High Availability using RMAN
✔ Tables, Indexes, and Online Operations enhancements
✔ Major enhancements in Data Pump, SQL Loader & External tables

Live Instructor Based Training With Software
Lifetime access and 24×7 support
Certification Oriented content
Hands-On complete Real-time training
Get a certificate on course completion
Flexible Schedules
Live Recorded Videos Access
Study Material Provided

Oracle DBA Training - Upcoming Batches

7th NOV 2022

8 AM IST

Weekday

Coming Soon

AM IST

Weekday

5th NOV 2022

8 AM IST

Weekend

Coming Soon

AM IST

Weekend

Don't find suitable time ?

CHOOSE YOUR OWN COMFORTABLE LEARNING EXPERIENCE

Live Virtual Training

  • Schedule your sessions at your comfortable timings.
  • Instructor-led training, Real-time projects
  • Certification Guidance.
Preferred

Self-Paced Learning

  • Complete set of live-online training sessions recorded videos.
  • Learn technology at your own pace.
  • Get access for lifetime.

Corporate Training

  • Learn As A Full Day Schedule With Discussions, Exercises,
  • Practical Use Cases
  • Design Your Own Syllabus Based
For Business

Oracle DBA Online Training FAQ'S

What constitutes an Oracle Instance?

  • The SGA is a distributed memory that several programs can use. This section contains data that the instance needs to function.
  • System Global Area (SGA), a distributed memory space on RAM, and applications running make up an instance.
  • The running processes are OS processes, and every program in the instance has a specific role to play.
  • When an instance is "started," it creates the GAS and runs processes

What is the distinction between a data block, an extent, and a segment?

  • A data block is a database object's basic logical storage unit. As objects expand in size, they require extra storage in the form of continuous data blocks.
  • Extents are collections of consecutive data chunks.

What is the Oracle Grid Architecture?

Oracle's grid design combines a huge database server, memory, and connections to create a customized, as per requirement computing resource for business computing demands. The grid computing architecture constantly evaluates the consumption of resources and changes supply accordingly.

You might, for example, run several programs on a grid of numerous connected database servers. If monthly reports are pending, the database administrator might automatically supply a dedicated server to that program to manage the growing demands.

Grid computing employs advanced workload management, enabling programs to work cooperatively across several servers. As per requirement data processing ability may be added or deleted, and resources within a region can be provided flexibly. Web services enable the rapid integration of apps to establish a business.

Get ahead in your career by learning Oracle DBA through VISWA Online Trainings

What is the definition of normalization? What do the various types of normalization entail?

It is the process of structuring a relational database's fields and tables to reduce complexity and dependence. It guarantees that our data is consistent by saving the memory.

  1. First normal form - Only single (atomic) valued attributes or columns should be used. A column's values must all belong to a certain domain.
  2. Second normal form - It must be written in First Normal. It should also not be partially dependent.
  3. Third normal form - It's in the shape of the Second Normal. It also lacks transitive dependencies.
  4. Boyce and Codd Normal Form - Boyce and Codd is a more advanced variation of the Third Normal Form. This form is used to deal with anomalies that aren't addressed by 3NF. BCNF refers to a 3NF table that does not contain several identical candidate keys

Why Are Bind Variables Important?

Bind variables are crucial because most database suppliers provide an execution plan cache, which stores recently processed SQL statements and planning processes for again use.

Reviews

vishal meda
vishal meda
2023-04-15
They give trainings properly and trainers are well versed with them where i recommend to all viswa trainings are good!!
Ntr fan
Ntr fan
2023-04-01
I just finished sap bods training in Hyderabad. Excellent course and curriculum 100% doubt clarification sessions. Thanks Chaitanya
Shiva Krishna
Shiva Krishna
2023-04-01
I recently completed informatica online training with Chaitanya. Course was built by excellent trainer. And process of learning was streamlined. Thanks
Mohammad ali syed
Mohammad ali syed
2023-03-27
It was great and smooth understandable training. You can learn lots.
Govinda Bhatia
Govinda Bhatia
2023-03-19
Not recommended as there will be no server access working to do practical after training. Also there will be no fix for the same. So it's wastage of money. If server access not at all working then no meaning to provide server access. Also it not working for single day properly. Need to followup daily but in response you told will fix that sir at home once he will back will fix. After he came back again it's not working and not able to fix for single day also Every time new excuse it's wastage of money.
M Leela mohan
M Leela mohan
2023-03-15
I took SQL Server and MSBI Online training with Murali Krishna. I must say the course content was highly qualitative and the trainer covered all concepts. Overall it was a good experience with VISWA Online Trainings.
HARIKRISHNA BANDLA
HARIKRISHNA BANDLA
2023-03-13
Attended live Virtual training for IoT Trainer was very good. He had excellent knowledge of IoT and was very good at explaining concepts in detail.…
Lakshmi Lakshmi
Lakshmi Lakshmi
2023-01-18
Best sap commerce cloud and Spartacus training institute in india. He provides a great mix of listening, speaking, and practical learning activities and a very safe, supportive learning environment. He maintains a friendly relationship with the students during class. He not only teaches but also monitors our practice status on daily basis.
Ch Chandranath
Ch Chandranath
2023-01-18
I have undergone Oracle Tuning training. I can proudly say that this is one of the best training institutes available in the market. The way Mr. Kumar teaches the concepts and makes them understandable is very commendable and unique. Even a novice can clearly understand the concepts clearly after attending his classes.

Quick Links