Database Administration on Oracle Database 11g

Database Administration on Oracle Database 11g

SQL Administration Workshop I Administration Workshop II

course at a glance

  • Date : 16 Oct - 15 Jan 2018
  • No. of Classes/ Sessions : 40
  • Total Hours : 120
  • Last Date of Registration : 15 Oct 2017
  • Class Schedule :
    • Saturday - 06:00pm - 09:00pm
    • Monday - 06:00pm - 09:00pm
    • Wednesday - 06:00pm - 09:00pm
  • venue : Netsoft Solution Ltd.

Price: TK. 30,000

  • 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

Oracle Database Administration 11g Database Administration (DBA) 120 Hrs

Tentative Class Start

16th October, 2017

Available Seat

10 / 15

who can join

B.Sc in (CSE,ECE,EEE,IT) or any Engineering  and General Student

Meet the Instructor