CARE TECHNOLOGIES is one of the leading top Training and Consulting Company in Bangalore, with a good placement track record. We have certified trainers. We will provide Classroom/Online Training, Fast Track

training, with job assistance.

We are providing Exclusive Training on all Software tools. Faculty from top MNC's with highly skilled domain expertise will train & guide you with real time examples, project explanation. We also help you in resume preparation and provide job assistance till you get job

Oracle Database Administration (Rs.25,000 )

• Concepts and Administration
• Oracle installation in linux and solaris
• Configuration kernel parameters
• Oracle architecture
• 10G Automatic management
• Program Global Area
• Startup and shutdown options
• Creating database
• Managing control files
• Managing log file
• Managing tablespaces
• Managing datafiles
• 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 datapump
• 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
• RMAN PITTR
• Maintaining Recovery Catalog
• Workshop with Scenarios
• Assessments

• Network Administrator
• Client server configuration
• Tnsnames
• Listener 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
• Oradebug
• Workshop with Scenarios
• Assessments

• Performance Tuning
• SQL Tuning
• Application Tuning
• Tuning Sorts
• Resizing SGA/PGA
• Detecting I/O Issues
• Latch Contention
• DBMS_STATS
• Configuration Statspack and AWR
• Levels Of Tracing
• Active Session Histroy
• SQL tuning Advisor
• SQL Access Advisor
• 10046 and 10053 trace events
• Using TKPROF
• Interpreting AWR And Statspack
• Optimizer Modes And Paramaters
• Network Tuning
• OS Tuning
• Workshop with Scenarios
• Assessments

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

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

• Other Utilities
• Using Quest Toad
• Using putty
• Workshop with Scenarios
• Assessments

Oracle Database Advanced Administration (Rs.20,000 )

• Dataguard
• Dataguard Architecture
• Protection Modes
• Configuration Physical Standby
• Configuration Logical Standby
• Switchcover and Failover
• Cascaded Standby Database
• Oracle Database Advance Administration

• Automatic Storage Management
• ASM Architecture
• Configuring ASM
• Configuring Raw Device
• Configuring ASM Disks
• Start and Shutdown ASM
• Maintaining Disk groups
• Migrating from and to ASM
• ASMCMD command Line
• Workshop withscenariors
• Assessment

• Oracle Real Application Clusters(RAC)
• RAC components

1.    Oracle Clusterware

• Background processes in RAC
• Database files in RAC

1.    Server parameter file

2.    Datafiles

3.    Control files

4.    Online redo log files

5.    Archived redo log files

6.    Other files

• Maintaining read consistency in RAC
• Cache Coherency
• Cache fusion
• Global Resource Directory
• Mastering of resources
• Lock management
• Multi-instance transaction behavior
• Recovery

1.    Cache recovery

2.    Transaction recovery

3.    Online block recovery

• Storage Management
• Disk fundamentals

1.    RAID concepts

• Storage options for RAC

1.    RAW devices

2.    Clustered file system

3.    ASM

• Configuring RAW Devices
• Configuring OCFS cluster file system
• Mounting devices on all nodes
• Configuring Network file system

 Number of Views :