Oracle DBA Online training Offered by SRY IT | DBA Course Details| Database Administration training - PowerPoint PPT Presentation

Loading...

PPT – Oracle DBA Online training Offered by SRY IT | DBA Course Details| Database Administration training PowerPoint presentation | free to download - id: 5e4120-YWVlN



Loading


The Adobe Flash plugin is needed to view this content

Get the plugin now

View by Category
About This Presentation
Title:

Oracle DBA Online training Offered by SRY IT | DBA Course Details| Database Administration training

Description:

Online Oracle Apps DBA Training by SRY IT Solutions strongly determined to provide Real-time, Practical and Project based knowledge transfer on Oracle Apps DBA Activities. We have nearly a 10 Years of experience in Online Training of Oracle Apps Database Administration and Corporate Training on Oracle technologies in Hyderabad. SRY IT provides both Offline and Online Trainings. For More details Contact us at: USA: +1-319-804-4998 India: +91-9948030675 (Available 24/7) Email: info@sryitsolutions.com Website: – PowerPoint PPT presentation

Number of Views:301

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Oracle DBA Online training Offered by SRY IT | DBA Course Details| Database Administration training


1
ORACLE DBAONLINE TRAINING
  • www.sryitsolutions.com
  • USA 1-319-804-4998 India91-9948030675
  • Email id info_at_sryitsolutions.com

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

3
INSTALLING ORACLE DATABASE 10G SOFTWARE
  •   System requirements
  •   Use Oracle Optimal Flexible Architecture (OFA)
  •   Install software with the Oracle Universal
    Installer

4
CREATE AN ORACLE DATABASE
  • Oracle Database Architecture
  •  Oracle instance architecture
  • Use the Database Creation Assistant

5
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

6
STORAGE STRUCTURES
  • Defining the table spaces and data files
  •  Create table spaces
  •  Manage table spaces
  •  Obtain table space information
  •  Create and manage table space using oracle
    enterprises manager

7
ADMINISTERING USERS
  •  Create and manage database user accounts
  •  Create and manage roles
  •  Grant and revoke privileges

8
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

9
PERFORMANCE MONITORING
  • Gather optimizer statistics
  •   View performance metrics

10
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

11
MANAGING DATA
  •  Manipulating data through SQL
  •  Using Import
  •  Using Export

12
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

13
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

14
DATABASE RECOVERY
  • Recover from loss of a control file
  •   Recover from loss of a redo log file
  •   Recover from loss of a data

15
Offered Other Modules
  • SAP SAP BPC, BASIS, ABAP, BO, ADMIN, FICO,
    MDM,CRM TRAINING,HANA TRAININGFSCM, IS UTILITIES,
    BO DATA SERVICES, APOetc
  • DWH AB INITIO, AJAX, INFORMATICA TRAINING, DATA
    STAGE, HANDOOP, WEBSPHEREand more

16
Contact Us for more details and Session Schedules
atUSA 1-319-804-4998 INDIA91-9948030675Emai
l info_at_sryitsolutions.comWeb
www.sryitsolutions.com
About PowerShow.com