Oracle Database Administration 11g

Oracle Database Administration 11g

Database Administrators (DBAs) are responsible for the design, implementation, support and maintenance of computerized databases in today's organizations.

course at a glance

  • Date : 24 Feb - 2 Jun 2018
  • No. of Classes/ Sessions : 40
  • Total Hours : 120
  • Last Date of Registration : 20 Feb 2018
  • Class Schedule :
    • Saturday - 9:00 AM - 12:00 PM
    • Friday - 9:00 AM - 12:00 PM
  • venue : 151/7, Good Luck Center (7th Floor), Panthopath Signal, Green Road, Dhaka 1205

Price: TK. 30,000
(including VAT & TAX)

Early Bird Registration Going on Valid Until 2nd March, 2018 Taka @27,000

This Training is jointly organized by BITM & PeopleNTech
Training will be held in PeopleNTech

Course Outline :

Introduction, Retrieving Data Using the SQL SELECT Statement, Restricting and Sorting data, Using Single Row Functions to Customize Reports, Reporting Aggregated Data Using the Group Functions, Displaying Data From Multiple Tables, Using Sub queries to Solve Queries, Using the SET Operators, Manipulating Data, Using DML Statements to Create and Manage Tables, Creating Other Schema Objects, Managing Objects with Data Dictionary Views, Controlling User Access, Manage Schema Objects, Manipulating Large Data Sets, Generating Reports by Grouping Related data, Managing Data in Different Time Zones, Searching Data Using Advanced Sub queries, Hierarchical Data Retrieval, Performing Regular Expression Support and Case Insensitive.

Course out line for Oracle 11G Administrator Workshops 1:

Exploring the Oracle Database Architecture, Preparing the Database Environment Creating an Oracle Database, Managing the Oracle Instance, Configuring the Oracle Network Environment, Managing Database Storage Structures, Administering User Security, Managing Schema Objects, Managing Data and Concurrency, Managing Undo Data, Implementing Oracle Database Security, Database Maintenance, Performance Management, Backup and Recovery Concepts, Performing Database Backups, Performing Database Recovery, Moving Data, Enhancing Database Capabilities, Workshop Hands-on .

Course Outline of Oracle 11G Administration Workshop 2:

Database Architecture and ASM, Configuring for Recoverability, Using the RMAN Recovery Catalog, Configuring Backup Specifications, Using RMAN to Create Backups, Performing User-Managed Backup and Recovery, Using RMAN to Perform Recovery, Using RMAN to Duplicate a Database, Performing Table space Point-in-Time Recovery, Monitoring and Tuning RMAN, Using Flashback Technology.

Curriculum

SQL SQL Query 40 Hrs
Admin1 Oracle Administration 1 40 Hrs
Admin2 Oracle Administration 2 40 Hrs

Tentative Class Start

24th February, 2018

Available Seat

10 / 15

who can join

Many students taking this course who have familiarity with system administration and administration of other non-Oracle databases, and this is helpful though not mandatory.

Meet the Instructor