Best Training institutes ,Computer education and Coaching classes in Kalkaji as of September 18, 2018

DBALOUNGE institute located at kalkaji in delhi-ncr offers 60 Day(s) of Oracle 11g DBA training course in Delhi-NCR with 100% Placement Assistance.

All our trainings are exclusively delivered by Hemant Fulfagar who : Has over 15 years of Experience as a Consultant on Oracle Database , Applications & Middleware Has over 5 years of Online , C

Oracle 11g DBA:: SQL Requirements - Select,DDL,DML,DCL,TCL � Unix/Linux commands used by DBA : ls , cp ,mv , rm , mkdir , rmdir , which , ls , grep , ps , ln , id , man , head , tail , env , echo , pi ng , kill , wc , export df, du ,tar , gzip , top , free , vmstat , netstat , ifconfig vi editor ORACLE DATABASE ADMINISTRATION 11G TRAINING COURSE CONTENT Reviewing tools and Support Sites � Introduction to Commonly used Tools : Putty, VNC, Winscp, VPN , telnet . ssh � Introduction to Online DBA Support Sites : DBALounge Forum , Oracle Support Sites Oracle Database 11G Architecture � Instance vs. Oracle Database 11G � Components of an Oracle Database 11G Instance � Components of an Oracle Database 11G � Datafiles, Controlfiles and Redo Logs � Checkpoints , Roll Forward and Rollback � Redo log concepts, Instance and Media recovery � Buffer Cache Block Management - LRU List � SGA vs. PGA � Background processes Software and Database Installation � Unix Kernel Parameters Setup � Important configuration files - sysctl.conf, limits.conf, meminfo ,cpuinfo � Installation of Oracle Software � Installation Oracle Database 11G using DBCA � Setting up of Environment � Startup and Shutdown of the Oracle Database 11G Oracle Database 11G Init Parameters � Init parameters � Displaying init.ora values with v$parameter � Sizing SGA components � Shared pool concepts and components � Overview of PGA for sorting and pga_aggregate_target � Alteration of Modifiable and Non Modifiable Init parameters vs. Spfile � Explaining the use of control files � File locations for control Files � Obtaining Control File Information � Multiplexing Control Files � Convert Oracle Database 11G to Archivelog Mode � Archiving the Oracle Redo Logs Oracle Database 11G Tablespace Management � Managing Tablespaces - Create, alter, drop, rename, offline, online, read only, read write � Creating, Resizing, Renaming, offline Datafiles � Creating and Managing Temporary Tablespaces and Tempfiles � Creating and Managing Undo Tablespaces � Understanding Undo Retention � Free Space / Used Space in Tablespace � Troubleshooting Undo � snapshot too old � Online redo log (log_buffer) � Dictionary queries Oracle Database 11G Redo Management , Management of Database Segments � Redo log switch � Multiplexing the Online Redo Log Files � Dictionary and v$ views � The dba_, all_ and user_ structures � Querying the tables, indexes, and segments views � Monitoring the alert log � Oracle Database trace/dump files � Oracle Database tables : Creation and Maintenance Operations � Oracle Database Indexes : Creating B*-Tree, bitmap and function-based Indexes � Oracle Database Views Oracle Database 11G Reorg, Users , Roles , Profiles , Privileges � Reorganize Tables � Index rebuilding � Creating New Database Users � Managing Profiles � Identifying System and Object Privileges � Granting and Revoking Privileges � Creating and Modifying Roles � Displaying user security Information from the Data Dictionary Oracle Database 11G*Net configuration � Understanding the Listener and how connection takes place from Client to Server � Use Netca � Creating the listener.ora file � Creating the tnsnames.ora file � Verifying network connectivity with ping and tnsping � Testing Oracle Database 11G connection via Listener Oracle Database 11G Backup & Recovery � Hot vs. Cold backups � Backup in Archivelog vs. Noarchivelog Mode � Taking Cold Backups � Taking Hot Backups � Concepts of Hot Backup � Complete and Incomplete Recovery � Restoration from cold Backup with complete data loss � Restoring and Recovering from loss of Datafiles - System and non system ,loss of Read Only Tablespaces � Loss of Controlfiles � Loss of Redo Logs - Inactive and Active � Complete and Incomplete Recovery Oracle Database 11G Backup and Recovery management using RMAN � Advantages of RMAN � Advantages of Catalog over Nocatalog � Catalog Creation � RMAN Closed Database and Hot Backups � RMAN Backup Management (Backup Database , tablespace , Datafile ,controlfile ,archivelogs , spfile) � Viewing Backups using List � Configure RMAN(Configure channels , autobackup , tape / disk ,retention Policies) � Reporting Bacukups � Restoring and Recovering from loss of Datafiles - System and non system ,loss of Read Only Tablespaces � Loss of Controlfiles � Loss of Redo Logs - Inactive and Active � Complete and Incomplete Recovery Oracle Database 11G DBA Utilities � Imp and exp utilities � Data pump (impdp and expdp) Oracle Database 11G DBA Utilities � DBVerify for Corruptions � Flashback Oracle Database, Flashback Drop , Flashback Query � Using Opatch for Oracle Database Patching Cloning Of Oracle Database � Cloning using Hot Backup � Cloning Using RMAN Duplicate Database Performance Management : Understand Problem , Check OS and Automated Reports � Understand the Performance Problem Scope � Discuss with the affected Users � Check dynamic performance views useful in tuning � Use dynamic performance views to view statistics and wait events � Create and manage AWR snapshots � Generate AWR reports � Generate ADDM reports � Log a performance Service Request with Oracle Support Performance Management : Tuning the Oracle Database 11G Instance � Tuning SGA � Tuning the Shared Pool � Tuning the Buffer Cache � Checkpoint and Redo Tuning � Diagnose checkpoint and redo issues � Size the redo log file � Size the redo log buffer � Diagnose PGA memory issues � Size the PGA memory � Diagnose temporary space issues � Understanding Locks � Detect enqueue contention Oracle Database 11G Performance Management : DBMS_STATS, Detect Fragmentation , SQL Tuning � Cost Based Optimizer � Using EXPLAIN PLAN � Using �set autotrace� � Interpreting EXPLAIN PLAN Output � Collecting Schema , table and index statistics (dbms_stats) � Checking Statistics � Tracing a Database Session � Using TKPROF to analyze a trace File Oracle Database 11G Maintenance & Job Scheduling and Processes � Monitoring Systems � Commonly configured Oracle Database Alerts and Actions to be taken � Common Monitoring Problems Encountered and Resolution � Change Management Process , Approval Process � Ticket Management Process (Severity , Priority , SLAs,Communication Protocol)