• This training is jointly organzied by BITM & Netsoft Solution's Ltd
  

  Training will be held in Netsoft Solution's Ltd
  
  This Database 11g Administration training gives you a firm foundation in basic database administration, including how to install and maintain an Oracle database. Learn about architecture and how the database components work and interact.
  
  As an advanced curriculum course. It builds on the Introduction to Performance Tuning in the Administration Workshop I and II courses, focusing on the tuning tasks expected of a DBA. It teaches you to perform backup and recovery, and diagnose and repair data failures. Manage major database components like memory, performance and resources using Oracle Database
  
  By investing in Oracle Database Training, learn how this technology enables your business to consolidate onto database clouds and engineering systems. Deep dive into Oracle Exadata and Oracle Database Appliance courses led by Oracle University's expert instructors. Explore Oracle Database categories below to expand your skill set.
  
  Course Outline :

• SQL

  1. Introduction to Oracle: SQL
  2.  Writing Basic SQL SELECT Statements
  3.  Restricting and Sorting Data
  4.  Single-Row Functions
  5.  Displaying Data from Multiple Tables
  6.  Aggregating Data Using Group Functions
  7.  Sub queries
  8.  Manipulating Data
  9.  Creating and Managing Tables
  10.  Including Constraints
  11.  Creating Views
  12.  Other Database Objects
  13.  Controlling User Access
  14.  SQL Workshop Overview
  15.  Controlling User Access
       
• Administration Workshop I

1.  Exploring the Oracle Database Architecture

2.  Installing your Oracle Software

3.  Creating an Oracle Database Using DBCA

4.  Managing the Database Instance

5.  Managing the ASM Instance

6.  Configuring the Oracle Network Environment

7.  Managing Database Storage Structures

8.  Administering User Security

9.  Managing Data Concurrency

10.  Managing Undo Data

11.  Implementing Oracle Database Auditing

12.  Database Maintenance

13.  Performance Management

14.  Backup and Recovery Concepts

15. Performing Database Backups

16. Performing Database Recovery

17. Moving Data

18. Working with Support

• Administration Workshop II

1. Core Concepts and Tools of the Oracle Database

2. Configuring for Recoverability

3. Using the RMAN Recovery Catalog

4. Configuring Backup Settings

5. Creating Backups with RMAN

6. Restore and Recovery Tasks

7. Using RMAN to Perform Recovery

8. Monitoring and Tuning RMAN

9. Diagnosing the Database

10. Using Flashback Technology I

11. Using Flashback Technology II

12. Performing Flashback Database

13. Managing Memory

14. Managing Database Performance

15.  Managing Performance by SQL Tuning

16.  Managing Resources

17.  Automating Tasks with the Scheduler

18.  Managing Space

19.  Managing Space for the Database

20. Duplicating a Database

 

 

Curriculum