Oracle DBA Certification Online Training

 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

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

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

 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

 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

✔ 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

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

 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

 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

 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

 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

 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

✔ 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

 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

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

✔ 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

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

 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

✔ 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

✔ 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

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

 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

 Use transportable tablespaces
 Describe the concepts of transportable databases

 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

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

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

 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

 12 Types of Triggers
 Triggering events
 Usage of Old & New reference
 View Trigger instead of Trigger Cascading /firing
 Table mutation error
 Bind variable support
 Special clauses of Triggers
 Statement Level Triggers
 Row Level Triggers

 Object Types
 Create Object Tables

 Create Nested Tables
 Index By Tables / Associative Array
 Varray

 New enhancements in oracle 10g,11g, And 12c
 New clauses in joining of tables
 Inner join/left outer join /right outer join
 Full outer join/natural full outer join
 Using clause/cross join
 Multi-table inserts
 Insert all command
 Merge command (UpSert)
 NVL ( ) enhancements
 Case statement of select command
 Searched CASE expression
 Heap tables
 Index Organized Tables (IOT)
 Temporary tables/global tables
 Multi-column updates
 Multiple Row subqueries
 New function EXTRACT( )
 Usage of subquery in the select list
 Autonomous Transaction
 Flashback Concepts
 Purge Concepts