Hurry Up!!      Call Now... +91 86687 70390      Admission Open      Best Training Institute in Pune (Digital Marketing Training, Python, JAVA, Dot Net, Testing)          Free Seminar of Digital Marketing For More Details Call Now On +91 86687 70390

Best Oracle DBA Training Institute

  • Home
  • Best Oracle DBA Training Institute

Oracle DBA Training in Pune by Industry Experts

Online / Offline Weekdays / Weekend Batches Availble
Duration of Training: 12 weekends

Oracle DBA
    Why Oracle DBA?

    Dba are the highest paid professional in IT industry. As major Database share in industry is Oracle, picking up Oracle DBA carrier would be lucrative today and in future

  • ASM
  • Patching
  • Data Guard
  • Database Upgrade
  • Performance Tuning
  • SQL tuning.
  • SQL loader.
  • Basic SQL and Shell Scripting.
    What We Offers?
  • We cover Linux installation in the course.
  • Entire training is conducted on Linux environment.
  • We have our own course designed considering the industry requirements
  • We teach more than the books, entirely industry based knowledge
  • Regular assessment and Dummy project at the end of the course
  • Exposure to Database Performance tuning and SQL tuning is given in the course.
  • Once a Student always a Student. At the Launch of any batch we create a Whatsapp Group and which is used to circulate document / topics / Career opportunities.
  • For any Clarification, you can contact trainer anytime after course completion.
    • Understand HDD partitioning
    • Primary Verses Extended Partitioning
    • Physical Volumes / Logical Volumes / Luns
  • Different levels of Raid
  • Installation of configuration of DNS.
  • Installation and configuration of DHCP
  • tgtd and iscsi utilities
  • Install and configure 11g and 12c Oracle Database Software
  • Creating 11g Database and 12c Database manually
  • Thorough understanding of 11g and 12c architecture
  • starting databases
  • understanding control files / redo log files / archive files
  • understanding Server parameter file and password files
  • Automatic memory management
  • Different components in SGA and PGA .
  • Dictionary managed versed locally managed tablespaces.
  • Automatic Segment space management
  • Understanding Segments / extents and blocks
  • Block utilization parameters
  • Understanding row chaining and migration
  • Different block Sizes
  • Understanding multitenant architecture
  • Overviews of Pluggable databases
  • Configuring and maintaining listeners
  • Configured Dispatchers and Shared servers
  • Understanding tnsnames.ora / sqlnet.ora and Ez Connect
  • Complete Overview of ASM
  • Understand the need of ASM
  • ASM instance parameters
  • Defining backup strategy
  • Complete understanding of RMAN and conventional backups
  • Cloning database using conventional methods
  • Cloning database using rman
  • Different types of Patches
  • How to apply patch to database
  • Upgrade Database from 11g to 12c
  • Coverting 12c noncdb to 12c pluggable database
  • Configure physical standby database
  • Understanding logical and snapshot standby database
  • understanding cronjob
  • writing basic scripts
  • Understand how to read the AWR / ADDM / ASH reports
  • Using sql loader to load data into tables
  • External tables and its benefits
  • Understanding different types of partitioning
  • Creating and altering partitions
  • Taking logical backups using expdp
  • Data pump usage and scenarios
  • Using utilities for tracing
  • How to read SQL explain plan
  • SQL performance considerations
  • Loss of a Control File
  • Loss of a Redo Log File
  • Loss of a Data File in NOARCHIVELOG Mode
  • Loss of a Noncritical Data File in ARCHIVELOG Mode
  • Loss of a System-Critical Data File in ARCHIVELOG Mode
  • Oracle Recovery Manager
  • Oracle Recovery Catalog maintenance
  • Backups using Oracle Recovery Manager
  • Recovery using Oracle recovery manager
  • Database Cloning using RMAN
  • Tablespace Point in time recovery
  • Incomplete recovery
  • Locks
  • Locking Mechanism
  • Data Concurrency
  • DML Locks
  • Enqueue Mechanism
  • Lock Conflicts
  • Possible Causes of Lock Conflicts
  • Detecting Lock Conflicts
  • Resolving Lock Conflicts
  • Deadlocks
  • Performance Monitoring
  • Performance Monitoring
  • Monitoring Methodologies
  • Database and Instance Metrics
  • Data Dictionary Metrics
  • Optimizer Statistics
  • Schedule Optimizer Statistics Collection
  • Dynamic Performance Views
  • Viewing Metric Information
  • Reacting to Performance Issues
  • Reacting to Performance Issues
  • Server Generated Alerts
  • Thresholds
  • Setting Thresholds
  • Baseline Measurements
  • Tuning and Diagnostic Advisors
  • SQL Tuning and Access Advisors
  • Memory Advisors
  • Segment Advisor
  • Automatic Workload Repository (AWR)
  • Managing the AWR
  • Automatic Database Diagnostic Monitor (ADDM)
REGISTER NOW

IT Training