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,
|
|
|
|
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
|
|
|
Why Training With Us