Oracle DBA Training

Oracle DBA Training

 

Sr.TopicHoursDays
                 Part I: Basic Database Administration
1.Getting Started with Database Administration13
2.Creating and Configuring an Oracle Database2
3.Starting Up and Shutting Down0.5
4Configuring Automatic Restart of an Oracle Database0.5
5Managing Processes2
6Managing Memory
7Managing Users and Securing the Database
8Monitoring the Database
9Managing Diagnostic Data
                 Part II Oracle Database Structure and Storage
10Managing Control Files23.5
11Managing the Redo Log
12Managing Archived Redo Log Files
13Managing Tablespaces2
14Managing Data Files and Temp Files
15Transporting Data1
16Managing Undo1
17Using Oracle Managed Files1
                 Part III Schema Objects
18Managing Schema Objects52.5
19Managing Space for Schema Objects
20Managing Tables
21Managing Indexes
22Managing Clusters
23Managing Hash Clusters
24Managing Views, Sequences, and Synonyms
25Repairing Corrupted Data
                 Part IV Database Resource Management and Task Scheduling
26 Managing Automated Database Maintenance Tasks42
27 Managing Resources with Oracle Database Resource Manager
28Oracle Scheduler Concepts
29Scheduling Jobs with Oracle Scheduler
30Administering Oracle Scheduler
                 Part V Managing a Multitenant Environment
31Overview of Managing a Multitenant Environment42
32Creating and Configuring a CDB
33Creating and Removing PDBs with SQL*Plus
34Creating and Removing PDBs with Cloud Control
35Administering a CDB with SQL*Plus
36Administering CDBs and PDBs with Cloud Control
37Administering PDBs with SQL*Plus
38Viewing Information About CDBs and PDBs with SQL*Plus
39Using Oracle Resource Manager for PDBs with SQL*Plus
40Using Oracle Resource Manager for PDBs with Cloud Control
41Using Oracle Scheduler with a CDB
                 Part VI Managing Oracle Net Service
42Configuring Listener21
43Configuring Naming methods
44Testing and verifying database connection
                 Part VII Backup and recovery
45Types of failures86
46Backup and Recovery tools, RMAN
47Physical backup of the database
 – Archive log mode and No archivelog mode
 – Hot backup and cold backup
48Database Recovery scenarios
 – Full database recovery
 – Incomplete database recovery
 – Recovering from the loss of a control file
 – Recovering from the loss of database files
49Logical backup 
 – Export and Import2
50Doubt clearing – concluding the session2
           Total4020

Training Details

Training Fees:K.D 350 (Including Original Material)
Training Days:20 days (2 days per week)
TrainingDate:Flexible
TrainingTiming:Flexible
TrainingLanguage:English
Material Language:English
Enquiry & Registration:For inquiry and registration please:
Call:22204171
Whatsapp:65701004
Email:info@bia.edu.kw