Good Oracle DBA Training Near Ayyappa Temple in Jalahalli Cross || Bangalore

oracle dba 1

Good Oracle DBA Training Near Ayyappa Temple in Jalahalli Cross || Bangalore

SYSTEMS DOMAIN

Systems Domain an ISO 9001:2008 company head quartered in Bangalore “The Silicon Valley of India ” IS promoted & managed by a group of highly experienced & skilled IT professionals.

Our main objective is to train the aspiring IT and ITES professional on various software technologies to meet the industry’s expectation.

Formed on 1997, we have partnership with Oracle Corporation.

ORACLE DATABASE

An Oracle database is a collection of data treated as a unit. The purpose of a database is to store and retrieve related information.

database server is the key to solving the problems of information management.
Oracle 10g DBA Course Content :-

1.Introduction.

  • Identify the oracle product
  • Describe the basic concept of a relational database

2.Installing oracle database 10g software.

  • System requirements.
  • Redhat Linux Installation
  • Install software with the Oracle Universal Installer on Linux Platform

3.Create an oracle database.

  • Oracle Database Architecture
  • Oracle instance architecture
  • Oracle Read Consistency and Concurrency

4.Controlling the database.

  • Start and stop the agent
  • Start and stop the enterprise manager database console
  • Start and stop the listener
  • Startup and shutdown the database

5.Database Creation.

  • Manual
  • Database Configuration Assistant(DBCA)

6.Storage Structures.

  • Defining the table spaces and data files
  • Create table spaces
  • Manage table spaces
  • Obtain table space information

7.File Management.

  • Control File Management
  • Redo Log File Management
  • Parameter File Management
  • Obtain table space information

8.Administering users .

  • Create and manage database user accounts
  • Create and manage roles
  • Grant and revoke privileges
  • Control resource usage by using Profiles

9.Oracle Net Services.

  • Understand Oracle Net concepts
  • Use Oracle Net Manager to create and configure listeners
  • Use the listener control utility to control the Oracle Net Listener
  • Use the Oracle Net Manager to configure client and middle-tier connection
  • Use TNSPING to test Oracle Net connectivity

10.Managing schema objects.

  • Create and modify tables
  • Define constraints
  • View the attributes of a table
  • View the contents of a table
  • Create indexes and views

11.Oracle Backup & Recovery (User Managed).

  • Introduction
  • Design, Testing, Implementation Strategies
  • Offline(cold)/Online(hot) backups
  • Performing Complete Recovery
  • Performing Incomplete Recovery

12.Oracle Backup & Recovery (System  Managed: RMAN).

  • Introduction
  • RMAN Architecture
  • Configuration
  • Setting up Catalog
  • Online/Offline Backup using RMAN
  • Backups Options
  • Incremental Backups,
  • Scripts,
  • Complete Recovery
  • Incomplete Recovery
  • Table Space Point in Time Recovery (TSPITR)
  • Disaster Recovery
  • Recovery of Corrupted DB-Blocks

Overview

13.Cloning.

  • RMAN
  • Manual

14.Logical Backup & Restore.

  • Introduction Data pump (expdp, impdp)  Utilities
  • Exporting/Importing Tables
  • Exporting/Importing Schemas
  • Exporting/Importing Table space
  • Exporting/Importing Database
  • Transportable Table space within & across the database and platforms

15.High Availability(HA).

  • Database Patch Management Introduction
  • Applying Interim and Patch set Patches
  • Patch History & Documentation

16.Log Miner.

  • Contents
  • Reading / Extracting the Content of Redo Logs (Online/archived) for recovery or auditing purpose

17.Flashback.

  • Introduction
  • Configuration
  • Flashback Query/Table/Drop/Database
  • Flashback Version Query
  • Creating Restore Points

18.Automatic Storage Management.

  • Introduction Data pump (expdp, impdp)  Utilities
  • Exporting/Importing Tables
  • Exporting/Importing Schemas
  • Exporting/Importing Table space
  • Exporting/Importing Database
  • Transportable Table space within & across the database and platforms

19.Data Guard.

  • Introduction
  • Architecture
  • Configuring Standby database
  • Performing Switch Over and Fail Over
  • Monitoring & Troubleshooting

20.Oracle Performance Tuning.

  • Introduction
  • Proactive Vs Reactive Tuning
  • Tuning through effective DB Configurations
  •  Health Management/Periodical Checkup
  • DB Defragmentation
  • Configuring and using Oracle Parallel Processing Feature
  • Tuning Memory, Disk I/O
  • Resource Intensive SQL
  • Managing the DB Statistics ( for CBO)
  • Managing the AWR Snapshots
  • Generating/ Interpreting the AWR Report

21.Oracle Grid Control.

  • Introduction
  • Architecture
  • Installation & Configuration
  • Managing the multiple database nodes using OEM grid control

REASONS TO JOIN SYSTEMS DOMAIN

  • Weekend Batches if required
  • Frequent events like Group discussion, Personality Development , Interview Tips, Presentation on Saturdays for an overall grooming.
  • Study Materials
  • Placement Assistance Systems Domain centralized placement cell provides placement opportunity for students on various courses and domain
  • Well-Equipped Lab with Computers to practice selenium after Class.
  • We are available for your Doubts/clarifications after the training course
  •   Instructor has 10+ years of experience in Selenium, Software Testing & Test Automation
  • Fast Track training 
       : Available as per your training dates and timings

 

CONTACT

 

ANJALI

Systems Domain Pvt.Ltd
#12, 3rd Floor, Shabari Complex,
Above Reliance Fresh, Near Ayyappa Temple,
Jalahalli Cross, Bangalore -560057

Land line  : 28372214/15

Mobile :  9986234938

Email : sdjl@systemsdomain.net

 

 

 

Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s