Hands-on Oracle DBA Workshop by experienced professional

Hands-on Oracle DBA Workshop by experienced professional


  • Course Fees

    Last Date: 30-09-2018

    INR 10000
  • Demo Class

    Last Date: 02-06-2018


Invite friends

Contact Us

Page Views : 32

About The Event

Learn the intricacies of database management from an expert who knows the subject and does it in front of you, full handson! No ppt , No Theory .. only practical!!!

Due to popular demand, weekend batches start every month.

1. Installing the Oracle Database Software
* Explain core DBA tasks and tools
* Plan an Oracle installation
* Use optimal flexible architecture
* Install software with Oracle Universal Installer (OUI)

2. Creating an Oracle Database
* Create a database with the Database Configuration Assistant (DBCA)
* Create a database design template with the DBCA
* Generate database creation s with the DBCA

3. Managing the Oracle Instance
* Start and stop the Oracle database & components
* Use Enterprise Manager (EM)
* Access database with SQL*Plus & iSQL*Plus
* Modify database initialization parameters
* Understand the stages of database startup
* View the log
* Use the Data Dictionary

4. Managing Database Storage Structures
* Describe table data storage (in blocks)
* Define the purpose of tablespaces & data files
* Understand & utilize Oracle Managed Files (OMF)
* Create and manage tablespaces
* Obtain tablespace information
* Describe the main concepts and functionality of Automatic Storage Management (ASM)

5. Administering User Security
* Create and manage database user accounts
* Authenticate users
* Assign default storage areas (tablespaces)
* Grant and revoke privileges
* Create and manage roles
* Create and manage profiles
* Implement standard password security features
* Control resource usage by users

6. Managing Schema Objects
* Define schema objects and data types
* Create and modify tables
* Define constraints
* View the columns and contents of a table
* Create indexes, views and sequences
* Explain the use of temporary tables
* Use the Data Dictionary

7. Managing Data and Concurrency
* Manage data through SQL
* Identify and administer PL/SQL Objects
* Describe triggers and triggering events
* Monitor and resolve locking conflicts

8. Managing Undo Data
* Explain DML and undo data generation
* Monitor and administer undo
* Describe the difference between undo & redo data
* Configure undo retention
* Guarantee undo retention
* Use the undo advisor

9. Implementing Oracle Database Security
* Describe DBA responsibilities for security
* Apply the principal of least privilege
* Enable standard database auditing
* Specify audit options
* Review audit information
* Maintain the audit trail

10. Configuring the Oracle Network Environment
* Use Enterprise Manager for configuring the Oracle network environment
* Create additional listeners
* Create Net Service aliases
* Configure connect-time failover
* Control the Oracle Net Listener
* Test Oracle Net connectivity
* Identify when to use shared vs dedicated servers

11. Proactive Maintenance
* Use statistics
* Manage Automatic Workload Repository (AWR)
* Use Automatic Database Diagnostic Monitor (ADDM)
* Describe advisory framework
* Set thresholds
* Use server-generated s
* Use automated tasks

12. Performance Management
* Use Enterprise Manager pages to monitor performance
* Use the SQL Tuning Advisor
* Use the SQL Access Advisor
* Use Automatic Shared Memory Management
* Use the Memory Advisor to size memory buffers
* Use performance related dynamic views
* Troubleshoot invalid or unusable objects

13. Backup and Recovery Concepts
* Identify the types of failure that may occur in an Oracle Database
* Describe ways to tune instance recovery
* Identify the importance of checkpoints, redo log files, and archived log files
* Configure ARCHIVELOG mode

14. Performing Database Backups
* Create consistent database backups
* Back your database up without shutting down
* Create incremental backups
* Automate database backups
* Monitor the flash recovery area

15. Performing Database Recovery
* Recover from loss of a control file
* Recover from loss of a redo log file
* Perform complete recovery following the loss of a data file

16. Performing Flashback
* Describe Flashback database
* Restore the table content to a specific point in the past with Flashback Table
* Recover from a dropped table
* View the contents of the database as of any single point in time with Flashback Query
* See versions of a row over time with Flashback Versions Query
* View the transaction history of a row with Flashback Transaction Query

Duration: 30hrs

What you get:
1) Hands-on practice of concepts discussed in class
2) Participation certificate from Oracle
3) Courseware from Oracle
4) Option to appear for Oracle Certification exam

About the Trainer:
The trainer is a IT Professional with vast experience of working in the Oracle DBA in large MNC company. 

Venue: South City Mall; Prince Anwarsah Road & Salt Lake
Cost: Call us

Shrabana@84205 94969



Venue Map