Location
Location

Uppal Hyderabad

Location
Phone

+91 70934 77157

Oracle DBA



Course Content:

  • Learn the fundamentals of database to set the stage for Oracle Architecture
  • Understand the Process and Memory Architecture (This is important as understanding this will help you solve lot of critical performance issues).
  • Install Oracle Database 11g & 12c (Manual method and using DBCA)
  • Tablespace management to manage space to store the data.
  • UNDO Tablespace management to manage undo space.
  • REDO Log file management to manage redo space.
  • Manage users and security
  • Networking (Configuring Listeners and TNS entries)
  • Understand various Data dictionary tables/views
  • Diagnose issues using Diagnose data and generate packages for Oracle Support.
  • Backup and Recovery (User Managed)
  • Backup and Recovery (RMAN)
  • Materialized Views
  • Table Partitioning
  • Project Work

  • Oracle 12C Database Administration With Hands on Experience.

  • Database instance and storage
  • Instance memory pools
  • Instance background processes
  • Client connections
  • Database storage file types
  • Control files and backup files
  • Multitenant databases
  • Starting and stopping the database
  • Installing Oracle 12c software
  • Using the developer tools
  • Database management