Revanth Technologies
9290971883, 9247461324
Menu
Toggle navigation
Home
Online Training
Corporate Training
Digital Marketing
Student Registration
Faculty Registration
Blog
Contact Us
Oracle 10g DBA Online Training
Duration 60 Hrs
1.Introduction.
Identify the oracle product
Describe the basic concept of a relational database
2.Installing oracle database 10g software.
System requirements.
Redhat Linux Installation
Install software with the Oracle Universal Installer on Linux Platform
3.Create an oracle database.
Oracle Database Architecture
Oracle instance architecture
Oracle Read Consistency and Concurrency
4.Controlling the database.
Start and stop the agent
Start and stop the enterprise manager database console
Start and stop the listener
Startup and shutdown the database
5.Database Creation.
Manual
Database Configuration Assistant(DBCA)
6.Storage Structures.
Defining the table spaces and data files
Create table spaces
Manage table spaces
Obtain table space information
7.File Management.
Control File Management
Redo Log File Management
Parameter File Management
Obtain table space information
8.Administering users.
Create and manage database user accounts
Create and manage roles
Grant and revoke privileges
Control resource usage by using Profiles
9.Oracle Net Services.
Understand Oracle Net concepts
Use Oracle Net Manager to create and configure listeners
Use the listener control utility to control the Oracle Net Listener
Use the Oracle Net Manager to configure client and middle-tier connection
Use TNSPING to test Oracle Net connectivity
10.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
11.Oracle Backup & Recovery (User Managed).
Introduction
Design, Testing, Implementation Strategies
Offline(cold)/Online(hot) backups
Performing Complete Recovery
Performing Incomplete Recovery
12.Oracle Backup & Recovery (System Managed: RMAN).
Introduction
RMAN Architecture
Configuration
Setting up Catalog
Online/Offline Backup using RMAN
Backups Options
Incremental Backups,
Scripts,
Complete Recovery
Incomplete Recovery
Table Space Point in Time Recovery (TSPITR)
Disaster Recovery
Recovery of Corrupted DB-Blocks
13.Cloning.
RMAN
Manual
14.Logical Backup & Restore.
Introduction Data pump (expdp, impdp) Utilities
Exporting/Importing Tables
Exporting/Importing Schemas
Exporting/Importing Table space
Exporting/Importing Database
Transportable Table space within & across the database and platforms
15.High Availability(HA).
Database Patch Management Introduction
Applying Interim and Patch set Patches
Patch History & Documentation
16.Log Miner.
Contents
Reading / Extracting the Content of Redo Logs (Online/archived) for recovery or auditing purpose
17.Flashback.
Introduction
Configuration
Flashback Query/Table/Drop/Database
Flashback Version Query
Creating Restore Points
18.Automatic Storage Management.
Introduction Data pump (expdp, impdp) Utilities
Exporting/Importing Tables
Exporting/Importing Schemas
Exporting/Importing Table space
Exporting/Importing Database
Transportable Table space within & across the database and platforms
19.Data Guard.
Introduction
Architecture
Configuring Standby database
Performing Switch Over and Fail Over
Monitoring & Troubleshooting
20.Oracle Performance Tuning.
Introduction
Proactive Vs Reactive Tuning
Tuning through effective DB Configurations
Health Management/Periodical Checkup
DB Defragmentation
Configuring and using Oracle Parallel Processing Feature
Tuning Memory, Disk I/O
Resource Intensive SQL
Managing the DB Statistics ( for CBO)
Managing the AWR Snapshots
Generating/ Interpreting the AWR Report
21.Oracle Grid Control.
Introduction
Architecture
Installation & Configuration
Managing the multiple database nodes using OEM grid control
Online Training Enquiry Form
Name :
Mobile :
Email :
Location :
Country :
--Select Country--
India
U.K
Australia
New Zealand
U.S
Others
Course Interested :
--Select Course--
Ab Initio
Android
AngularJS
Angular 2
Angular 4
Advanced Loadrunner
ASP.NET MVC
Cognos 10
Core Java
C Language
C++
Datastage
DevOps
Digital Marketing
Drupal
ETL Testing
Hadoop
Hibernate
Informatica
IBM-AIX
IBM DB2
IBM WebSphere MQ Admin
IIB
IIB Admin
Joomla
Javascript
Java
J2EE
jQuery
Linux Administration
Loadrunner
Magento
Magento2
MongoDB
NodeJS
OBIA
OBIEE 10g
OBIEE 11g
Oracle 11g DBA
Oracle RAC DBA
Oracle 9i
Oracle SOA 11g
Oracle 10g & D2K
Oracle 10g DBA
Oracle 11g RAC
Oracle Apps Technical
Oracle Weblogic Server
Pentaho
Perl Scripting
PHP
Python
QTP
ReactJS
RPA with Blue Prism
Salesforce
Seo
SAS
SAS Clinical
SAP ABAP
SAP Basis
SAP HR
SAP HANA Admin
SAP HANA
SAP BOBJ
SAP Business Objects
SAP BW
SAP EHS
SAP EP
SAP EWM
SAP FICO
SAP FIORI
SAP MM
SAP NetWeaver
SAP Netweaver Using OData
SAP SD
SAP Security
SAP SuccessFactors
SAP UI5
SAP WebDynpro ABAP
SAP WebDynpro Java
SAP Workflow
SAP XI/PI
Scala
Selenium
Servicenow
Splunk
Spring
Shell Scripting
Tableau
Talend
TIBCO BW
Teradata
Testing Tools
UI Development
Unix - Sun Solaris Admin
Veritas Volume Manager
Web Sphere
Web Designing
Websphere Commerce Server Administration
Websphere Portal
Wordpress
Security Code :
Please enter:
*
Submit
Reset
Online Software Courses
SEO Online Training
Digital Marketing Online Training
SEO Online Training
JAVA Online Training
Java Online Training
J2EE Online Training
Spring Online Training
Hibernate Online Training
Websphere Online Training
Websphere Admin Online Training
Websphere Portal Server Admin Online Training
Websphere MQ Online Training
Websphere Commerce Server Admin Training
Testing Tools Online Training
Testing Tools Online Training
Loadrunner Online Training
Advanced Loadrunner Online Training
Selenium Online Training
Design & Development
PHP Online Training
Joomla Online Training
Drupal Online Training
Java Script Online Training
Angular JS Online Training
jQuery Online Training
Magento Online Training
TYPO3 Online Training
Webdesigning Online Training
Scripting Languages
Perl Scripting Online Training
Shell Scripting Online Training
Python Online Training
C Language Online Training
C++ Online Training
Oracle Online Training
OBIA Online Training
OBIEE 11g Online Training
OBIEE 10g Online Training
Oracle 10g & D2K Online Training
Oracle 10g DBA Online Training
Oracle 11g RAC Online Training
Oracle SQL/PLSQL Online Training
Oracle SOA Online Training
Weblogic Server Admin Online Training
Dataware Housing Online Training
Datastage Online Training
Informatica Online Training
Teradata Online Training
SAP Online Training
SAP ABAP Online Training
SAP BO Online Training
SAP HANA Online Training
SAP HR/HCM Training
Other Courses
Cognos TM1 Online Training
Hadoop Online Training
HP UX Online Training
SAN Online Training
SAS Clinical Online Training
SAS Online Training
Tableau Online Training
Tibco BW Online Training
Unix-Sun Solaris Admin Online Training
Veritas Volume Manager Online Training
Android Online Training
Cognos Online Training
IBM-AIX Online Training
Linux Admin Online Training
Salesforce Online Training