Oracle Database Administration Training in Chennai

Sakthi Software Solutions, Anna Nagar, Chennai Offers Best Oracle DBA Training in Chennai.

Concepts and Administration
•Oracle installation in Linux and Solaris
•Configuration kernel parameters
•Oracle architecture
•10G Automatic management
•Program Global Area
•Start-up and shutdown options
•Creating database
•Managing control files
•Managing log file
•Managing table spaces
•Managing data files
•Managing tables and indexes
•Materialized views
•Partitions
•Locks
•Data integrity
•Space and storage parameters
•Undo
•Temp management
•Temporary database
•Users
•Roles and privileges
•Profiles
•Scheduler
•DBMS_JOBS
•Workshop with Scenarios
•Assessments

Backup and recovery
•Export
•Import and Data pump
•RAID
•SAN
•NAS
•NFS Storage
•User Managed backup (UMB)
•UMB Cloning
•User Managed Recovery
•Point in time to recover (PITTR)
•Configuration RMAN
•RMAN Backups
•RMAN Cloning
•Merge Backups
•RMAN PITTR
•Maintaining Recovery Catalog
•Workshop with Scenarios
•Assessments

Network Administrator
•Client server configuration
•Tnsnames
•LDAP and Naming Servers
•Listiner Control utility
•Unix Tools: FTP, SFTP, SCP, WINSCP
•Workshop with Scenarios
•Assessments
Oracle Utilities
•Exp/imp, Expdp, impdp
•NID
•CSSCAN,CSALTER
•Oerr
•Dbverify
•Oraenv
•Orapwd
•Spidr
•Tnsping
•Wrap
•Workshop with Scenarios
•Assessments

Performance Tuning
•Why Tuning?
•SQL Tuning
•Application Tuning
•Tuning Sorts
•Resizing SGA/PGA
•Detecting I/O Issues
•Latch Contention
•DBMS_STATS

Configuration Stats pack and AWR
•Levels of Tracing
•Active Session History
•SQL tuning Advisor
•SQL Access Advisor
•10046 and 10053 trace events
•Using TKPROF
•Interpreting AWR and Stats pack
•Optimizer Modes and Parameters
•Network Tuning
•OS Tuning
•Workshop with Scenarios
•Assessments

Patching And Up gradation
•Oracle 9i to 10g to 11g Up gradation
•Version migration (10.2.0.1 to 10.2.0.4)
•Implementing Opatch
•Workshop with Scenarios
•Assessments

Oracle Security
•Db Vault
•Fine Grain Access Control (FGA)
•VPD Policies
•Workshop with Scenarios
•Assessments

Data guard
•Data guard Architecture
•Protection modes
•Configuration physical standby
•Configuration logical standby
•Switchover and failover
•Cascaded standby Database

Other Utilities
•Using Quest Toad
•Using ERWLN (Data Modeling)
•Using putty and Xmanager tolls
•Workshop with Scenarios
•Assessments

Contact:
Sakthi Software Solutions Pvt Ltd,
RVR Towers, 1st Street, 3rd Main Road,
Anna Nagar, Behind Nalli Silks,
Chennai-600 040.
044-43016888 / www.sssedu.in