"Oracle DBA Training for you, would be a definite advantage to jumpstart your IT career immediately and effectively"
Located Near by CHROMPET Rly. Station - Chennai
Post Oracle DBA Training
1.While interacting with well-organized Oracle DBA efficients in any client discussion / interview, as a DBA / RAC DBA, you would be effectively presented like an experienced DBA professional in the DBA world. Therefore you would be definite appointed.
2. In working environment on any oracle DBA project, as a DBA, you would be fixed the DBA administration tasks confidently without anxieties or doubts. Hence it is enhancing your oracle DBA career and DBA knowledge rewardingly.
3.In addition, this DBA training gives hands to complete OCA or OCP significantly. It would be highly appreciated in your yearly appraisal.
Refer the complete details as cited below for Combined Oracle DBA 12c,11g,10g & 9i / Combined Oracle RAC DBA + ASM 11gR2 & 10gR2 / Oracle GoldenGate DBA 11gR2 / Oracle DataGuard DBA11gR2/10gR2.
Sabari - Chennai
Contact : 9994408197
Module - I
1. Combined Oracle DBA 12c,11gR2,10gR2, & 9iR2
Duration : 10 Weekends on (All Sataurdays AND Sundays)
Timing : Morning 10:00 AM to 2:00 PM
Venue : Near CHROMPET Railway Station, Chennai
DBA Perspective SQL Commands.
Connectivity between your laptop or desktop and the UNIX based Oracle Database servers.
DBA Perspective UNIX flavoured OS Commands and its OS Installation.
Imparting the tips, technic and trick of ir-respective of any version upto Oracle 11gR2 and specifically Oracle 11gR2/10gR2 and 9iR2 Database Installations (Both Manually Creating Database and During Oracle Software Installation) on UNIX flavoured OS.
Remote Oracle 12c/11g/10g / 9i Database Installations with using VNC Server.
Module-I - Segment - 1 - Architecture in 11g/10g/9i:-
The complete Oracle Architecture such as SGA, Background Process, Instance, Database like Logical Database Structure & Physical Database Structure, Parameter File, Password file, Startup/Shutting down the Database, Control Files, Redolog files, ArchiveLog files, Manual Creating Database in 12c/11gR2/10gR2/9iR2, Type of INDEXES, Type of CONSTRAINTS, Profile, Schema/User Management, Privileges, ROLE & PGA Management (APMM), etc.,
Strong Manual SQL Query Tuning in all version, SQL Tuning Advisor (Automatic), Memory Tuning, ASMM – Automatic Shared Memory Management, AMM - Automatic Memory Management, ADDM – Automatic Database Diagnostic Monitor, Statspack Analysis, AWR – Automatic Workload Repository, Disk I/O Contention, Handling Locking issue and Removing Locking, Monitoring Parallel Sessions / Inactive Sessions / Active Sessions, PGA Tuning, APMM – Automatic PGA Memory Management, ASH - Active Session History Tuning, UNDO Tablespace Tuning, UNDO_Retention Tuning, RedoLog Group Size Tuning, Arc backgroud process Tuning etc.,
Module-I - Segment - 3 - (Advanced higher end tasks and Backup and Recovery Strategies) :-
Oracle Connectivity between the oracle DB servers / Oracle client and server base technology
Back and Recovery – Physical Backups such as RMAN and its Configuration, Hot/Online Backup, Cold/Offline Backup and Logical Backup - Exp / Imp & DATAPUMP ).
Upgrading the Oracle Software from lower version to higher version.
Upgrading the Oracle Software from one version to another version.
Cross Platform migration of the Oracle Database from one OS platform to another OS.
Migrating the Oracle Database (from 9i to 10g, 10g to 11g and 9i to 11g, 9i to 12c).
Preparing the DBA purpose Testing Database in Testing Server
Preparing Mirroring Database in Mirroring Server (Before DataGuard concept).
Database Refresh Activities (from 9i to 12c).
Schema Refresh Activities with proper Tablespace Calculations (from 9i to 12c).
Table Refresh Activities with proper Tablespace Calculations (from 9i to 12c).
The Complete Overview of Database Link (DBLinks) and Materialized view.
Oracle Loader / External Tables
Space Managements (Segment Shrink Functionality, and Other Space Management Tools such as UNDO Advisor & Redo Log Advisor).
And Further Tablespace related topics since Oracle 11g/10g.
Preparing for an Interview and Group Discussions.
Preparing the Resume in required way for an Oracle DBA.
Sabari - 9994408197
Module - II
3 Nodes RAC - Step by Step configuration between OS and Oracle in both 11gR2/10gR2
3 Nodes RAC - Step by Step configuration in Automatic Storage Management (ASM) both in 11gR2/10gR2
3 Nodes RAC - Step by Step installation the Oracle software / ORACLE_HOME both in 11gR2/10gR2
Adding Additional Nodes in RAC environment
Removing existing Nodes from RAC environment
Migrating a Single DB'Instance into RAC environment including ASM both in 11gR2/10gR2
RAC Admin - RAC specified Initialization Parameters both in 11gR2/10gR2
RAC Admin - Managing DB config with SRVCTL both in 11gR2/10gR2
RAC Admin - Re-scripting the controlfile in RAC Environment both in 11gR2/10gR2
RAC Admin - Enabling ArchiveLogs in RAC Environment both in 11gR2/10gR2
RAC Admin - Enabling Flashback in RAC Environment both in 11gR2/10gR2
RAC Advanced Admin - Cluster Ready Services - CRS administration both in 11gR2/10gR2
RAC Advanced Admin - Oracle Local Repository - OLR administration in 11gR2
RAC Advanced Admin - VotingDisk administration both in 11gR2/10gR2
And the complete ASM deployments in RAC and NON-RACenvironment both in 11gR2/10gR2
Preparing for an Interview and Group Discussions
Preparing the Resume in required way for an Oracle RAC DBA
Sabari - 9994408197
Module - III
Oracle DataGuard - contents details, would be provided in person or after the discussion held.
Module - IV