Oracle DBA 12c | 19c Certification Training

One of the top providers of online IT training worldwide is VISWA Online Trainings. To assist beginners and working professionals in achieving their career objectives and taking advantage of our best services, We provide a wide range of courses and online training.

4627 Reviews 4.9
4.7/5

Learners : 1080

Duration :  30 Days

About Course

Oracle DBA is a group of data that is handled as a whole. A database’s main function is to store and retrieve relevant data. The database server holds the key to resolving information management issues. In a multiuser scenario, a server often manages a lot of data reliably so that multiple users can access the same material at once. Delivering excellent performance while accomplishing all of this. Additionally, Oracle DBA server offers effective solutions for failure recovery and guards against unauthorized access. Enrol today to earn your certification.

Oracle DBA Training Course Syllabus

Exploring the 12c Oracle DBA 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 In Oracle DBA

✔ 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 Database Administration 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?

For the needs of business computing, Oracle’s grid design combines a sizable database server, memory, and connectivity to produce a tailored, as-needed computing resource. The grid computing architecture continuously assesses resource consumption and modifies supply as necessary.

A grid of various connected database servers, for instance, might be used to run multiple programmes simultaneously. The database administrator might automatically assign a dedicated server to that programme to handle the escalating demands if monthly reports are overdue.

Advanced workload management techniques used in grid computing allow programmes to collaborate across multiple servers. Resources within a region can be offered dynamically and data processing capacity can be increased or eliminated as needed. Web services make it possible to quickly integrate apps to launch 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

Quick Links