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

Oracle Database Administration 11g

This Training is Jointly organized by BITM & Pepole NTech limited

 

Database Administrators (DBAs) are responsible for the design, implementation, support and maintenance of computerized databases in today's organizations. The role also includes architecting, building and scaling databases for future data growth and capacity. They are also responsible for security, performance and availability of data to users and customers. .

All the above tasks are performed with the help of a Database Management System (DBMS) and the leading and most widely used DBMS across the world today are the Oracle Database, Microsoft SQL Server, MySQL database etc. Out of the three DBMS technologies, Oracle Database is the most popular and widely used database in the world today.

 

Training will be held on Pepole NTech limited Premises

 

FEE - Tk 30000

Prerequisite

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

Project Oriented Course

One will practically learn all mentioned tools and techniques by completing a project through this practical training course

Course Outline

Course Outline for SQL:

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.

Used Tools

  • Oracle SQL Query
  • Create and manage users.
  • Install and configure an Oracle Database.
  • Create and manage storage structures.
  • Administer the Oracle Database.
  • Understand the Oracle database architecture and how its components work and interact with one another.
  • Perform backup and recovery.
  • Admin 1
  • Admin 2

COURSE SUMMARY

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

Class Starting Tentative Date 21 January, 2017
Application Last Date : 21 January, 2017

Class Schedule

Day & Time : Friday 9:00 am - 12:00 pm
: Saturday 9:00 am - 12:00 pm
Duration : 3 hours per class

Project:

Oracle Database Administration 11g


Certificate:

Certificate will be provided after the completion of the course.