Setup Menus in Admin Panel

Compu21

Setup Menus in Admin Panel

Advanced Oracle DBA

Advanced Oracle DBA Summary: This course is designed for the participants who already have basic Oracle knowledge and experience and …

0 STUDENTS ENROLLED

    Advanced Oracle DBA

    Summary:

    This course is designed for the participants who already have basic Oracle knowledge and experience and want to enhance or extend their administration skills to a higher level in the new millennium. This class will give a hand on experience as a senior database administrator.

    Week 1:  Oracle installation and migration

    • Oracle env variable setup
    • Install Oracle in Sun-Solaris
    • Applying patches to Oracle
    • Migration oracle database from 8i to 9i
    • Oracle using shares memory and how to setup system parameters.
    • Setup daily oracle cron job for the backup & other maintenance.  

    Week 2: Tuning and implement Oracle

    • Capacity planning
    • Physical design RAID (Disk Manager)
    • Tuning I/O & memory
    • Advance SQL tuning 

    Week 3:  Copy database and distribute data

    • Change database name
    • Copy database from one server to others using cold/hot backup.
    • Distributed data using oracle tool (snapshot, db_link, copy and so on)
    • Standby database setup

    Week 4:  Oracle 9I and 10 G new features.

    • Data transports by tablespaces
    • Choose different block size within singe database
    • Partition table and partition index.
    • The Pros & Cons of Partition
    • Other new features 

    Week 5:  Monitoring of Oracle

    • Oracle daily monitoring
    • Reversing DDL using Log Miner
    • Benchmarking (stress test on various physical designs)
    • Oracle Data Warehouse
    • Oracle DBA interview tips & techniques with useful administration scripts 

    Week 6:  Microsoft SQL Server

    • Architectures compare with Oracle
    • Create database, create table space, create user, setup securities.
    • Tuning database
    • Loading data using tool (export, import, loader)
    • Backup and recovery.
    • Integration and interface with other vendor products

    Course Reviews

    No Reviews found for this course.

    PRIVATE COURSE
    • PRIVATE
    • 10 Days

    Advanced Course Search Widget

    Popular Courses

    Recent Posts