Setup Menus in Admin Panel


GOTINFOS provide the best ORACLE DBA ONLINE TRAINING in by real time professionals with an in-depth understanding of the DBA features.

    • DBA is a database administrator, and this is the most common job that you find a database specialist doing. A data base administrator (DBA) directs or performs all activities related to maintaining a successful database environment.In other words a database administrator, database analyst or database developer is the person responsible for managing the information within an organization. The DBA has many different responsibilities, but the overall goal of the DBA is to keep the server up at all times and to provide users with access to the required information when they need it.

      Prerequisite to learn ORACLE DBA :

      •  Basic knowledge of data processing concepts and techniques would be helpful.
    • Introduction

      •  Introduction
      •  Identify the oracle product
      •  Describe the basic concept of a relational database

      Installing oracle database 10g software

      •  System requirements
      •  Use Oracle Optimal Flexible Architecture (OFA)
      •  Install software with the Oracle Universal Installer

      Create an oracle database

      •  Oracle Database Architecture
      •  Oracle instance architecture
      •  Use the Database Creation Assistant

      Controlling the database

      •  Manually configure the Oracle 10g EM dbconsole
      •  Start and stop the agent
      •  Start and stop the enterprise manager database console
      •  Start and stop the listener
      •  Startup and shutdown the database

      Storage Structures

      •  Defining the tablespaces and data files
      •  Create tablespaces
      •  Manage tablespaces
      •  Obtain tablespace information
      •  Create and manage tablespace using oracle enterprises manager

      Administering users

      •  Create and manage database user accounts
      •  Create and manage roles
      •  Grant and revoke privileges

      Oracle Database Security — Only Theory

      •  Apply the principal of least privilege
      •  Manage default user accounts
      •  Implement standard password security features

      Oracle Net Services

      •  Understand Oracle Net concepts
      •  Use Oracle Net Manager to create and configure listeners
      •  Use the Oracle Net Manager to configure client and middle-tier connection
      •  Use TNSPING to test Oracle Net connectivity

      Performance Monitoring

      •  Gather optimizer statistics
      •  View performance metrics

      Monitoring and Managing Memory

      •  Oracle Memory Structures
      •  Automatic PGA Memory Management
      •  Using the Memory Advisor
      •  Using Automatic Shared Memory Management to avoid long running query issues

      Monitoring and Resolving Lock Conflicts

      •  Detect and resolve lock conflicts
      •  Manage deadlocks

      Diagnostic Sources

      •  The Alert Log
      •  Viewing Alerts with EM
      •  Alerts Notification —– Only Theory
      •  Editing Thresholds —– Only Theory
      •  Trace Files

      Proactive Maintenance: Objectives — Only Theory

      •  Set warning and critical alert thresholds
      •  Collect and use baseline metrics
      •  Use tuning and diagnostic advisors
      •  Use the Automatic Database Diagnostic Monitor (ADDM)

      Automatic Storage Management Only Theory

      •  ASM Concepts
      •  ASM General Architecture
      •  Creating an ASM instance
      •  Creating tablespaces that use ASM storage
      •  Viewing ASM information
      •  Migrating a tablespace to use ASM storage.

      Undo Management — Only Theory

      •  Monitor and administer undo
      •  Configure undo retention
      •  Guarantee undo retention
      •  Use the undo advisor

      Backup and Recovery — Only Theory

      •  Describe the basics of database backup, restore and recovery
      •  List the types of failure that may occur in an Oracle Database
      •  Describe ways to tune instance recovery
      •  Identify the importance of checkpoints, redo log files, and archived log file

      Managing Data

      •  Manipulating data through SQL
      •  Using Import
      •  Using Export

      Database backups

      •  Configure ARCHIVELOG mode
      •  Create consistent database backups
      •  Back your database up without shutting it down
      •  Create incremental backups
      •  Automate database backups
      •  Monitor the flash recovery area

      Managing schema objects

      •  Create and modify tables
      •  Define constraints
      •  View the attributes of a table
      •  View the contents of a table
      •  Create indexes and views

      Database Recovery

      •  Recover from loss of a control file
      •  Recover from loss of a redo log file
      •  Recover from loss of a data file
      • 8+ years of experience in Oracle PLSQL Development.
      • 5+ yrs of exp as an ORACLE trainer.
      • Working as Manager for DBA operations.
      • Entirely customized to your level.
      • Superior training experience skills
      • Practical experience with theoretical topics.
      • Very approachable and well experienced.
      • Empowering students with best conceptual & practical skills
      • Providing the Projects on emerging Technologies with Real-time scenarios.

    Course Reviews


    94 ratings
    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    Apply for Course
    • 30 Hours



    Design © GOTINFOS. All rights reserved.