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

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.

websitedesigningsingapore is a freelance online advance oracle 11g dba training in singapore, advance oracle 11g dba training in singapore, advance oracle 11g dba training institute in singapore, advance oracle 11g dba training course in singapore, advance oracle 11g dba training with live project in singapore, best advance oracle 11g dba training institute in singapore, online oracle 11g dba training in singapore.

Please contact on my mobile/Whatsapp 91-9347045052 for any web designing , ui designing, logo design, banner design and website upgrade work. Email me at info@websitedesigningsingapore.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
GET IN TOUCH
Trending training
main Training
Students Placement
Placement
Placement Assistent
Live Project Training
Placement in MNC
100% Job Assistance

Our Training

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