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

Views:
 
Category: Education
     
 

Presentation 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. FEATURES OF SRYIT: Course Duration: 60 Hours Access: With 2 months server access Trainer Details: 8+ Years Real Time Consultant Training: We train people ONLINE/OFFLINE on Oracle Database 9i, 10g, 11g and Oracle Apps Technical, Functional Modules. Prerequisites: Any Graduate and Software professional can learn this course. Material: Soft Copy of Training Course Materials, Session Video Recordings will be provided. After Training: Resume preparation, Interview Questions Career Support will be provided. Support: we will give direct access to our server to each trainee with individual login 24×7 support. Offered Other Modules: SAP: SAP BPC, BASIS, ABAP, BO, ADMIN, FICO, MDM, CRM, HANA, FSCM, IS UTILITIES, BO DATA SERVICES, APO.,etc. Data Warehouse: AB INITIO, AJAX, INFORMATICA, DATA STAGE, HADOOP, WEBSPHERE Oracle &Hyperion: ESSBASE, PLANING, DQM, FM….and more For More details Contact us at: USA: +1-319-804-4998 India: +91-9948030675 (Available 24/7) Email: info@sryitsolutions.com Website:http://www.sryitsolutions.com/oracle-dba-online-training-in-hyderabad/

Comments

Presentation Transcript

ORACLE DBA ONLINE TRAINING:

ORACLE DBA ONLINE TRAINING www.sryitsolutions.com USA: +1-319-804-4998 India:+91-9948030675 Email id: info@sryitsolutions.com

INTRODUCTION:

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

INSTALLING ORACLE DATABASE 10G SOFTWARE:

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

CREATE AN ORACLE DATABASE:

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

CONTROLLING THE DATABASE:

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:

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

ADMINISTERING USERS:

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

ORACLE NET SERVICES:

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:

PERFORMANCE MONITORING Gather optimizer statistics   View performance metrics

MONITORING AND MANAGING MEMORY:

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

MANAGING DATA:

MANAGING DATA  Manipulating data through SQL  Using Import  Using Export

DATABASE BACKUPS:

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:

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:

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

Offered Other Modules:

Offered Other Modules SAP: SAP BPC, BASIS, ABAP, BO, ADMIN, FICO, MDM,CRM TRAINING,HANA TRAININGFSCM, IS UTILITIES, BO DATA SERVICES, APO…etc DWH: AB INITIO, AJAX, INFORMATICA TRAINING, DATA STAGE, HANDOOP, WEBSPHERE …and more

Contact Us for more details and Session Schedules at USA: +1-319-804-4998 INDIA:+91-9948030675 Email : info@sryitsolutions.com Web : www.sryitsolutions.com:

Contact Us for more details and Session Schedules at USA: +1-319-804-4998 INDIA:+91-9948030675 Email : info@sryitsolutions.com Web : www.sryitsolutions.com

authorStream Live Help