Computer Courses

Oracle-DBA

Oracle Database is a object-relational database management system used to store and manage huge amounts of data. It is based on the relational model as introduced by E.F. Codd. A Database Administrator is a person, who is responsible for the design, implementation, maintenance and repair of an organization's database.

Oracle DBA course is designed for the professionals who are looking forward to increase their market value through knowledge up gradation and for the working professionals who want to explore their career.

Duration:
Programs Hours
ORACLE DBA 10g/11g 40

Oracle DBA Courses

Course Content:
Concepts and Administration
  • Oracle installation
  • Configuration kernel parameters
  • Oracle architecture
  • Automatic management
  • Program Global Area
  • Startup and shutdown options
  • Creating database
  • Managing control files
  • Managing log file
  • Managing tablespaces
  • Managing datafiles
  • Managing tables and indexes
  • Materialized views
  • Partitions
  • Locks
  • Data integrity
  • Space and storage parameters
  • Undo
  • temp management
  • Temporary database
  • Users
  • Roles and privilages
  • Profiles
  • Scheduler
  • DBMS_JOBS
Database Management
  • Using the Insert, Delete, and Update statement
  • Type of Triggers and Creating Triggers
Backup and recovery
  • Types of Database Failure (Media Failure, Statement Failure, Process failure, Instance and user Failure.
  • Types of Database Backup
  • Configuration RMAN
  • RMAN Recovery of Data
  • Recovery using SQL commands
  • Maintaining Recovery Catalog
  • Creating Full Backup
  • Creating incremental Backup
  • Monitoring the Flash Recovery Area
  • Data file
  • Control files
  • Archived Redo log
Network Administrator
  • Client server configuration
  • Tnsnames
  • Naming Method
  • Using Oracle Enterprise Manager
  • Listiner Control utility
Monitoring and Tuning
  • Why Tuning?
  • SQL Tuning
  • Application Tuning
  • ADR command interpreter
  • Tuning Database area
  • Monitoring using the ADDM
  • Resizing SGA/PGA
  • Detecting I/O Issues
  • Managing AWR
  • Levels Of Tracing
  • SQL tuning Advisor
  • SQL Access Advisor
  • Accessing AWR
  • Network Tuning
  • OS Tuning
Securing the Database
  • Managing Database with users and Privileges
    • Creating users
    • Creating Roles
    • Creating Revoking Database Privileges
    • Controlling the Resources Area
  • Working with the Default user account
  • Implementing the Password Policy
    • Default profile
    • Password complexity
    • Password Case sensitivity
    • Default password.
  • Inspecting the Database
Data Consistency and Concurrency
  • Undo Management
  • Working with Lock Controls
Other Utilities
  • Using Quest Toad