Sakthi Software Solutions, Anna Nagar 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.
No comments:
Post a Comment