info@takeoffprojects.com
takeoff projects
CORPORATE TRANING ON ORACLE
Topic Covered: RDBMS PROGRAMMING ORACLE SQL, PL SQL, DATABASE TRIGGERS...ETC.

TRAINING CONTENTS:
Oracle Concepts & Architecture
  • History of Oracle RDBMS Why Java?
  • Oracle 10g/11g product editions
  • Understanding physical structure, memory structure, process structure, logical structure.
  • Oracle instance
  • System Global Area (SGA),
  • Background processes,
  • Program Global Area (PGA),
  • Shared memory and semaphores, Oracle Read consistency and concurrency.
Project Practical’s: Lab programs

Creating and Managing Database
  • Managing the database
  • Managing the table spaces and data files/temp files
  • Managing control files and online/offline Redo log files
  • Creating and managing parameter file
  • Managing database users and sessions
Project Practical’s: Lab programs

Oracle Networking
  • Oracle NET architecture
  • TNS Listener using NETCA
  • TNS Client using NETCA
  • Monitoring & Trouble shooting
  • Oracle shared server architecture
  • creating DB links
Project practical’s: lab programs

Oracle Backup & Recovery
  • User managed offline (cold) /online (hot) backup through manual and using scripts.
Project practical’s: lab programs

Oracle Backup & Recovery (System Managed - RMAN)
  • Introduction
  • RMAN architecture
  • Configuration
  • Online/offline backup using RMAN
  • Complete & incomplete Recovery
  • Full backup, incremental backups
  • Table space-point-in-time recovery (TSPITR) Disaster recovery
  • Recovery of corrupted DB-Blocks
  • Cloning the database
  • Creating standby database.
Project practical’s: lab programs

Logical Backup & Restore
  • Introduction Data pump(expdp, impdp)
  • Exporting/importing tables
  • schemas
  • Table space
  • Database
  • Transportable within and across the database and platforms.
Project practical’s: lab programs

High Availability
  • Introduction
  • Downloading and applying interim and patch set Patches
Project practical’s: lab programs

Data Guard
  • Introduction
  • Architecture
  • Configuring
  • Standby database
  • Performing switchover and failover
Project practical’s: lab programs

Log Miner
  • Reading / Extracting the content of Redo logs (online/archived) for recovery and auditing purpose
Project practical’s: lab programs

Flashback
  • Introduction
  • Configuration
  • Flashback query/ table drop/database
  • Flashback version query
Project practical’s: lab programs

Oracle database Upgradation/Migration
  • Introduction
  • Upgradation Vs Migration
  • Upgradation of database Manual/ Automated
  • Migrating the Oracle DB
Project practical’s: lab programs

Automatic Storage Management(ASM)
  • Introduction
  • Configuring ASM Instance
  • ASM processes and parameters
  • Managing ASM Disk groups using ASMCMD utility
Project practical’s: lab programs

Oracle Streams
  • Introduction
  • Oracle streams for data replication
  • Administration and troubleshooting
Project practical’s: lab programs

Oracle Grid Control
  • Introduction
  • Architecture
  • Installation and configuration
  • Managing the multiple database nodes using OEM grid control
Project practical’s: lab programs

Oracle Performance Tuning
  • Introduction
  • Proactive Vs Reactive tuning thru effective db
  • configurations and Health management / Periodic health checkup
  • DB fragmentation
  • Managing DB diagnostics for CBO
  • AWR snapshots
  • Generating / interpretation of AWR report
Project practical’s: lab programs

Troubleshooting
  • Introduction
  • Troubleshooting
  • DB Corruption/ Hanging issues Re-linking of oracle executables using Remote Diagnostics Assistant RDA to gather diagnostic data Checking for bugs and error
  • Working with oracle support Raising SR (Service Request)
Project practical’s: lab programs

Call us : (+91) 9030333433 / 08772261612
Mail us : takeoffstudentprojects@gmail.com
Mail us : info@takeoffprojects.com
Call us : (+91) 9030333433 / 08772261612
Mail us : takeoffstudentprojects@gmail.com