Oracle DBA Training in Hyderabad - PowerPoint PPT Presentation

View by Category
About This Presentation
Title:

Oracle DBA Training in Hyderabad

Description:

Getting a job in ORACLE DBA is not an easy task, as companies requirements and targets can only be fulfilled by experienced people therefore nowadays companies are looking more over projects rather than experience.experience may be one of the reasons to hit a job but survival with a minimal knowledge can put you down a bit to exist in your professional life.We are best at giving live project for every trainer which will define your success in your interview and your professional life as well. Get certified with best ORACLE DBA training centre with latest online training and classroom training(recommended).More than 10+ years experienced trainer and Finally at what we are best at 100% placement assistance.. so grab your seats for best future experiences. – PowerPoint PPT presentation

Number of Views:53

less

Write a Comment
User Comments (0)
Transcript and Presenter's Notes

Title: Oracle DBA Training in Hyderabad


1
(No Transcript)
2
Things to learn
  • This course provides students with
    comprehensive understanding of Oracle Database
    Architechture and Administraton. It provides
    hands on exposure to all aspects of Database
    Administration like Installing, Administering,
    Backing up, Securing,Tuning Oracle Database and
    provides Knowledge and skills required to
    transform individuals in to a complete DBA
    Professional.

best Oracle dba training in Hyderabad
3
Who can Attened
  • IT beginners and professionals
  • System Administrators
  • Support Engineers
  • Developers

Oracle training
Hyderabad
4
Training Highlights
  • Training on latest versions
  • In-depth coverage along with real scenarios
  • Server access for practice.
  • Interviews question and Guidance on Oracle
    certification
  • 100 Placement assistance.

Oracle certification Hyderabad
5
Course Content
  • Module-1
  • Introduction to DBA
  • What is Database? Why Database?
  • Major Database and Database Vendors ?
  • Roles and responsibilities of DBA?

Oracle dba course in Hyderabad
6
  • Oracle Database Architecture
  • Database and Instance
  • Memory Structures
  • Background Processes
  • Database files
  • Physical Logical Structures

best Oracle dba
training in Hyderabad
7
  • Installing Oracle 12c Database Server
  • Requirements for Installation
  • Oracle Universal Installer (OUI)
  • Installing Oracle Software

Oracle dba training in
Hyderabad
8
  • Creating Oracle Database
  • Planning the Database
  • Creating Database
  • Exploring the seed database
  • Starting Stopping Database
  • Startup Shutdown modes
  • Starting Stopping the database
  • Read-only Restricted modes


Oracle server dba training in Hyderabad
9
  • Starting Stopping Database
  • Startup Shutdown modes
  • Starting Stopping the database
  • Read-only Restricted modes

Oracle training
Hyderabad
10
  • Parameters Parameter Files
  • Initialization Parameters
  • Static and Dynamic parameters
  • Parameter Files
  • Text Server Parameter Files
  • System Session Level Parameters
  • Changing Parameter values

Oracle certification Hyderabad
11
  • Data Dictionary
  • Understanding Data Dictionary
  • Static Dynamic Performance Views
  • Using Data Dictionary

Oracle server dba training in
Hyderabad
12
  • Managing Diagnostic data
  • Diagnostic files
  • Automatic Diagnostic Repository (ADR)
  • Viewing Diagnostic data

Oracle dba training in Hyderabad
13
Module 2
  • Managing Data Files Tablespaces
  • Tablespace and Data Files Concepts
  • Blocks, Extents, Segments
  • Understanding Space Management
  • Creating Managing Tablespaces
  • Big file Tablespaces
  • Tablespace Quotas
  • Configuring Multi-Block Support

14
  • Managing Undo Data
  • Transactions and Undo Data
  • Managing Undo data
  • Creating Undo Tablespaces
  • Configuring Undo Retention

15
  • Managing Temporary Tablespaces
  • Understanding Temporary Tablespaces
  • Managing Temporary Tablespaces
  • Temporary Tablespace Groups

16
  • Managing Control Files
  • Understanding Control Files
  • Multiplexing Control Files
  • Backing up Control Files

17
  • Redo Log Files Archiving
  • Online Archived Redo Log Files
  • Managing Online Redo Log Files
  • Fast Recovery Area (FRA)
  • Configuring Database Archive mode

18
  • Oracle Managed Files (OMF)
  • OMF Concepts and Use
  • File Naming Conventions using OMF
  • Creating Tablespaces with OMF

19
  • User Administration
  • Creating Users Accounts
  • Account management
  • Schema , Session, Killing Sessions
  • Using profiles to implement complex passwords
    and resource limits

20
  • Privileges Roles
  • Understanding Privileges
  • Managing Privileges
  • Understanding Roles
  • Managing Roles

21
  • Oracle Net Services
  • Understanding Oracle Net Services
  • Net Listener, Naming Methods
  • Net configuration tools- NETCA, NETMGR
  • Configuring Listener Naming methods
  • Establishing Database connectivity from
    Oracle Database Clients
  • Configuring Shared Servers and Dispatchers

22
  • Database Links
  • Distributed Databases
  • Creating Database Links
  • Managing Database Links

23
Module 3
  • Backup and Recovery using RMAN
  • Backup Recovery Concepts
  • Recovery Catalog
  • Full Incremental Backups
  • Image Copy Backup Set backups
  • Backup Recovery using RMAN
  • Hot Cold backups using RMAN
  • Complete In-Complete Recovery
  • SQL DESCRIBE commands in RMAN

24
  • Flashback Technologies
  • Oracle Flashback Technologies
  • Flashback Database
  • Flashback Table
  • Flashback Drop Table

25
  • Oracle Data Pump
  • Concepts of Logical backups Refresh
  • Data Pump Exports Imports

26
  • Transportable Tablespaces
  • Concepts of Transportable Tablespaces
  • Transporting Tablespaces across Databases

27
  • Database Cloning
  • Cloning Concepts and Considerations
  • Cloning Techniques
  • Cloning Oracle Home and Database
  • Manual Cloning
  • Cloning using RMAN

28
  • Data Guard
  • Overview of Data Guard
  • Benefits of Implementing Data Guard
  • Standby Database Concepts
  • Implementing Physical Standby database

Oracle dba training in
Hyderabad
29
  • Database Patching
  • Patching Concepts
  • Interim Patches, CPU, PSU patches
  • Patch Sets
  • Downloading Analysing Patches
  • Applying Patches

best Oracle server dba training in
Hyderabad
30
  • Database Upgrade
  • Understanding the upgrade process
  • Upgrade methods
  • Upgrading Oracle11g to Oracle 12c

best Oracle dba training in Hyderabad
31
  • Database Performance Tuning
  • Oracle Tools for Performance Tuning
  • Instance Database Tuning
  • Execution Plans, using EXPLAIN PLAN
  • Application Tracing, TKPROF
  • AWR, ADDM, ASH

Oracle dba course in Hyderabad
32
  • Oracle Multitenant Architecture
  • Multitenant Architecture
  • Pluggable Databases (PDB) Container
    Database (CDB)
  • Creating Managing CDBs PDBs
  • Users, Roles, Privileges in CDB
  • Parameters in CDB
  • Backup, Recovery of CDBs PDBs

Oracle certification Hyderabad
33
Our faculty ?
  • Training by a professional employee real
    time with 10 years experience
  • Training on Real Time scenarios and case
    studies
  • Most in-depth and comprehensive training on
    every topic of the course
  • Training on Latest Versions Oracle 12c
  • Individual attention, one to one training
  • Dedicated systems for Lab practice
  • Unlimited Lab Access till you get job
  • 100 Placement Assistance
  • 100 Satisfaction guaranteed

Oracle training Hyderabad
About PowerShow.com