ONLINE TRAINING

 

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. He needs to have the knowledge of the core components of the Oracle Software, and solve any issues related to the companies database.Our Oracle DBA Online Training in Hyderabad courses are designed for the professionals who are looking forward to increase their market value through knowledge upgradation and for the working professionals who want to explore their career.

Course Content: Concepts and Administration

  • Oracle installation in linux and solaris
  • Configuration kernel parameters
  • Oracle architecture
  • 10G 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
  • Workshop with Scenarios
  • Assessments

Backup and recovery

  • Export
  • Import and Datapump
  • RAID
  • SAN
  • NAS
  • NFS Storage
  • User Managed backup(UMB)
  • UMB Cloning User Managed Recovery
  • Point in time to recover(PITTR)
  • Configuration RMAN
  • RMAN Backups
  • RMAN Cloning
  • Merge Backups
  • RMAN PITTR
  • Maintaining Recovery Catalog
  • Workshop with Scenarios
  • Assessments

Network Administrator

  • Client server configuration
  • Tnsnames
  • LDAP and Naming Servers
  • Listiner Control utility
  • Unix tools:FTP,SFTP,SCP,WINSCP
  • Workshop with Scenarios
  • Assessments

Oracle Utilities

  • NID
  • CSSCAN,CSALTER
  • Oerr
  • Dbverify
  • Oraenv
  • Orapwd
  • Sqldr
  • Tnsping
  • Wrap
  • Workshop with Scenarios
  • Assessments

Performance Tuning

  • Why Tuning?
  • SQL Tuning
  • Application Tuning
  • Tuning Sorts
  • Resizing SGA/PGA
  • Detecting I/O Issues
  • Latch Contention
  • DBMS_STATS
  • Configuration Statspack and AWR
  • Levels Of Tracing
  • Active Session Histroy
  • SQL tuning Advisor
  • SQL Access Advisor
  • 10046 and 10053 trace events
  • Using TKPROF
  • Interpreting AWR And Statspack
  • Optimizer Modes And Paramaters
  • Network Tuning
  • OS Tuning
  • Workshop with Scenarios
  • Assessments 

Patching And Upgradation

  • Oracle 9i To 10g to 11g Upgradation
  • Version migration(10.2.0.1 to 10.2.0.4)
  • Implementing Opatch
  • Workshop with Scenarios
  • Assessments

Oracle Security

  • Db Vault
  • Fine Grain Access Control (FGA)
  • VPD Policies
  • Workshop with Scenarios
  • Assessments

Dataguard

  • Dataguard Architecture
  • Protection modes
  • Configuration physical standby
  • Configuration logical standby
  • Switchover and failover
  • Cascaded standby Database
Other Utilities

  • Using Quest Toad
  • Using ERWIN (Data modeling)
  • Using putty and Xmanager tolls
  • Workshop with Scenarios
  • Assessments
Real Time Environmental Training

  • Seminars/Tips from Corporate DBAs
  • Various DBA Environment Discussion
  • Resume Preparation
  • Mock Inverviews from Corporate DBAs
  • OCP - Online Simulation Exams
  •  

     

     

Online Training Courses Online Training Courses

   support@khamuritsolutions.com