Best training centre in chennai

Sakthi Software Solutions in Chennai is a Dynamic Training Institution with a Vision to Impart focused and flexible Educational Services and Projects to raise the employment opportunities in the IT Industry since 2005. We target in focusing our expertise as Placement Consultancy in Chennai in providing quality IT solutions through Oracle DBA Training in Chennai and Recruitment Services & provide technology-based learning solutions to leading corporate across the world

Tuesday, 7 May 2013

Oracle Database Administration Training in Chennai

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

oracle dba training in chennai

Course Content:

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 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 / http://www.sssedu.in

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)