Oracle DBA Basic Course

This Training course is designed to provide candidates a strong foundation on Administration of Oracle Database, Basic SQL and Oracle Database Architecture Concept,Logical and physical Database objects,User &Role Management,Backup and Recovery using RMAN,Basic of ITIL process and Basic Unix Commands.

Purpose of this Course is to help Fresher,Any Graduate and Post Graduate. This course begins by assuming that you have no experience with Oracle Database. ,After completion of this course,Candidate/Student will be able to perform L1 and L2 task easily in Company Plus, you will get a great foundation when preparing for the Oracle DBA Certification exam

BASIC SQL

  1. Introduction to SQL
  2. Working with DDL,DML,TCL an DCL Commands
  3. SQL DataType
  4. SQL Operators and Aggregate Function
  5. Basic SQL Query
  6. Grouping the Result of a Query
  7. Working with Integrity Constraints
  8. Querying Multiple Tables (Joins)
  9. Working with Sub Queries
  10. VIEWS in Oracle

Database Administration

  1. Oracle Database Architecture
    ( Memory Structure and Background Process)
  2. Physical and Logical Structure of Database
  3. Database startup and shutdown stage
  4. Manual and DBCA Database creation in 12c
  5. Indexes and Types of indexes and Its importance
  6. User and Role Management
  7. Checking Logs and Trace Files
  8. Health Check of Database

Backup and Recovery

  1. Basics concept of Backup & Recovery.
  2. Logical Backup(Exp/Imp and Expdp and Impdp).
  3. Importance and Enabling database in Archiving Mode.
  4. Physical Traditional Backup and Recovery.
  5. full/incremental and whole/partial backups using RMAN.
  6. Report and Monitor RMAN Backups and Jobs
  7. RMAN Troubleshooting and Performance Tuning
  8. Perform all supported cross-platform transportation techniques
  9. Manage RMAN Recovery Catalog
  10. Use RMAN in a multitenant environment

Basic ITIL Process

  1. Concept of ITIL Process
  2. Incident and Change Management

Basic Unix Command

  1. Introduction of UNIX/Linux
  2. Basic Unix Commands
  3. File and folder Permissions
  4. Redirect ,Append and Pipe
  5. Unix text Editors and Cron Job
  6. User Management

Quick Enquiry