Training Content
Placement Whatsapp
ONLINE ADVANCE ORACLE 11G DBA TRAINING IN MALAYSIA

Oracle 11g dba online training we provide online Training for IT technologies by well intimate with professionals operating in real time Environment. Well liked for maintaining quality in training we offer online classes for all IT technologies Oracle 11g dba online training This Oracle Database 11g: Administration Workshop I Release 2 course explores the fundamentals of basic database administration. Expert Oracle University instructors will reinforce topics with structured hands-on practices that will prepare you for the corresponding Oracle Certified Associate exam.

web designer malaysia is a freelance online advance oracle 11g dba training in malaysia, advance oracle 11g dba training in malaysia, advance oracle 11g dba training institute in malaysia, advance oracle 11g dba training course in malaysia, advance oracle 11g dba training with live project in malaysia, best advance oracle 11g dba training institute in malaysia, online oracle 11g dba training in malaysia.

Please contact on my mobile/Whatsapp +91 - 9032803895 for any advance oracle 11g dba training and online oracle 11g dba training work. Email me at info@webdesignersmalaysia.com to Know course and support. Add my Skype id (purnendu_ranjan) to discuss further.

oracle11gdba Course Modules

Essential UNIX (and Linux) for the Oracle DBA

  • Understanding the UNIX Shell(s)
  • Overview of Basic UNIX Commands
  • Navigating Files and Directories in UNIX

 

  • Writing and Editing Files with the vi Editor
  • Extracting and Sorting Text
  • Shell Scripting

 

  • Dealing with UNIX Processes
  • UNIX System Administration and the Oracle DBA
  • Disks and Storage in UNIX

 

Tasks of a Database Administrator

  • To plan and create databases
  • To manage database availability
  • Database tuning
  • To manage physical and logical structures
  • To manage security
  • Network administration
  • Backup and recovery

Oracle 11g Architectural Components

  • Oracle Database Server
  • Oracle Database Instance,
  • Memory Architecture
  • Process Architecture

Database Creation

  • Understanding required init parameters for DB Creation.

 

  • Creating Database using OMF
  • Creating a Database with DBCA

 

  • Setting up Listener and TNS
  • Executing post database creation scripts

 

Managing Databases

  • Database Start up / Shutdown process and options
  • Monitoring Alert and Trace files for trouble shooting
  • Configuring various memory structures
  • Overview of DB Background processes
  • Overview of Logical storage structures like Blocks, Extents and Segment.
  • Overview of Data Dictionary Views

Managing Tablespaces and Datafiles

  • Overview of tablespaces and datafiles.
  • Create / Alter of tablespaces

 

  • Adding / Resising of datafiles
  • Overview of Oracle Managed Files (OMF)

 

  • Big file Tablespaces& Temporary Tablespaces

 

User Management

  • Overview of Users / Schemas
  • Understanding Role and Privileges

 

  • Creation and Managing Users
  • Managing Resources / Profiles
  • Dictionary Views for User Management

Oracle Data Loads

  • Overview of various data load operations
  • Working with SQL Loader
  • Working with classic Export / Import utilities
  • Understanding and Working with Data Pump

 

  • Overview of Transportable Tablespaces

 

Backup and Recovery of Databases

  • Backing Up Oracle Databases
  • The Recovery Manager (RMAN)
  • User-Managed Backups
  • The Oracle Recovery Process
  • Performing Recovery with RMAN
  • The Oracle Backup Tool

Automatic Storage Management

  • Creating ASM instance.
  • Creating ASM devices using ASMLIB.
  • Configuring ASM Disk Groups.
  • Configuring ASM rebalance with variable power limits.
  • ASMCMD.
  • File management in ASM

Oracle High Availability

  • Configuring Physical Standby
  • Switchover and failover
  • Flashback Database / Query / transaction
  • Recycle Bin
 
Why Training With Us

Our Training

  • magento
  • PHP
  • wordpress
  • phpMysql
  • drupal
  • magento
  • PHP
  • wordpress
  • phpMysql
  • drupal
  • magento
  • PHP
  • wordpress
  • phpMysql
  • drupal
  • magento
  • PHP
  • wordpress
  • phpMysql
  • drupal