Best Training institutes ,Computer education and Coaching classes in Palayam as of October 23, 2018

Pinnacle Trivandrum institute located at palayam in trivandrum offers 2 Months of Oracle DBA training course in Trivandrum with Basic Placement Support.

Our Oracle DBA trainer is well qualified, has completed M.E.and they are student friendly. More than 150 students are executed by our Trainers. Our Trainers worked for MNC companies priviously. So t

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 And more ��.