Setup Menus in Admin Panel

ORACLE DBA ONLINE TRAINING

652 STUDENTS ENROLLED
  • 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

4.2

4.2
234 ratings
  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

Apply for Course
  • 60 Hours

APPLY FOR COURSE



captcha

INFORMATION

About US
Why GOTINFOS
Pay Methods
FAQ

SERVICES

Online Training
Corporate Training
Staffing
Consulting

SUPPORT

Project Support
Technical Support
System Access
Placement Assistance

Trainer registration

A QUALITY EDUCATION

Our accredited online programs are designed to accommodate adult learners who want to advance their education without compromising quality. Our online programs offer the same curriculum as on-campus equivalents, but are flexible enough to fit into your busy schedule.

FOLLOW US...

Facebook  Twitter Linkedin

CONTACT US

Call +1 512 518 9366

info@gotinfos.com

 

top
Design © GOTINFOS. All rights reserved.