Oracle DBA Training

Oracle DBA Training

 

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

Training Details

Training Fees : K.D 350 (Including Original Material)
Training Days : 20 days (2 days per week)
TrainingDate : March 2019-
TrainingTiming : 6:00 PM– 9:00 PM
TrainingLanguage : English
Material Language : English
Enquiry & Registration : For inquiry and registration please:
    Call us : 22204171
    Fax us :
    Email us : info@bia.edu.kw

Ms. Laila Batool