It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change The Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change The Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change The Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change The Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change The Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change the Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change the Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change the Way of Your Life
It's all to do with the training: you can do a lot if you're properly trained.
An Institution That Can Change the Way of Your Life

Database Administration on Oracle Database 11g

This training is jointly organzied by BITM & 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.

Training will be held in Netsoft Solution's Ltd

FEE - Tk 30000( 5000 tk Discount valid till 10 July, 2017)

Prerequisite

Any one who have basic Computer fundamentals.

Project Oriented Course

Yes, Database Administration Projects

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 Function
  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 DataWorking 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

Used Tools

SQL

COURSE SUMMARY

Course Duration : 40 Days
Total Hour : 120 Hours
Number of Batch : 1 Batch

Class Starting Tentative Date 17 July, 2017
Application Last Date : 15 July, 2017

Class Schedule

Day & Time : Saturday 6:00 pm - 9:00 pm
: Monday 6:00 pm - 9:00 pm
: Wednesday 6:00 pm - 9:00 pm
Duration : 3 hours per class

Project:

Oracle DBA Proejct


Certificate:

Certificate will be provided during the session.