1000+ Unique Technologies Projects Delivered | 500+ Corporate Customers Worldwide | 50000+ Professionals Trained on 40+ Domains in Over 30 Countries | Just Launched B2I Offerings | Live, Instructor-led.

Oracle DBA

This web-based training course on Oracle DBA functionality, administration and development, is available online to all individuals, institutions, corporates and enterprises in India (New Delhi NCR, Bangalore, Chennai, Kolkatta), US, UK, Canada, Australia, Singapore, United Arab Emirates (UAE), China and South Africa. No matter where you are located, you can enroll for any training with us - because all our training sessions are delivered online by live instructors using interactive, intensive learning methods.

Oracle DBA or Oracle database is an object relational database management system which is distributed by Oracle corporations. The oracle database stores data logically in the form of table-spaces and also physically in the form of files. Oracle also offers a partitioning option of tables on the basis of different set of keys. Typically, Oracle makes use of a group of processes running simultaneously in the background and interacting with the monitor and expedites database operations.


Reviews , Learners(390)



Course Details

Oracle database corporate learning solutions offered by Aurelius are the perfect amalgam of theory and practice wherein the students gain a deep understanding of the most important and essential elements of DBA and the responsibilities involved. Completing this Oracle DBA learning solutions, the participants will be able to diagnose and repair data failures using flashback technologies and also be able to manage space while optimizing database storage. This is a customizable learning track for corporate and can be modified to suit the exact needs of the clients.


INTRODUCTION TO ORACLE DBA

  • Oracle Architecture
  • Physical and Logical Phase of Database
  • Different types of Datafiles
  • SGA(System Global Area) and Background Process

DATABASE CREATION

  • Different Startup Modes
  • Different Shutdown Modes
  • Types of Database Creation
  • Manual Method of Creation

TABLESPACE MANAGEMENT

  • Introduction to Table space
  • Types of Table space(BIG & SMALL)
  • Altering/Renaming a Table space
  • Renaming a data file
  • Table space Encryption(11g)

STORAGE PARAMETERS

  • What are segments?
  • What are extents?
  • What is Blocks?
  • Estimation of Extents
  • Dictionary Managed Table space
  • Locally Managed Table space
  • Storage Parameters(Initial, Next, Min Extents, Xtents, Pctincrease)

USER MANAGEMENT

  • Who are Database Users?
  • Creation of Users
  • Allocating table space Quotas to Users
  • Assigning default table space for the Users
  • Setting Profiles for the Users
  • Levels of Authentication
  • Schema Management(11g)
  • Security(11g)

UNDO MANAGEMENT

  • What is Undo?
  • Pending offline status
  • Brief idea about Rollback segments
  • Flashback Features

What is spfile?

  • Difference between spfile and pfile
  • Advantages of spfile
  • What is OMF?
  • Advantages of OMF
  • Files conventions of OMF

NETWORKING IN ORACLE

  • Introduction to Oracle Networking
  • Network default location
  • Editing Network file

Tnsnames.ora

  • Introduction to Database Links
  • Types of Database Links
  • Introduction to Materialized views
  • Refresh Modes

REDO-LOG & CONTROLFILE MANAGEMENT

  • Introduction to Redo log
  • Status of Redo logs
  • Multiplexing the Redo log files
  • Re-creation of Control file
  • Renaming the Database
  • Multiplexing the Control file

LOGICAL BACKUP

  • What is a logical backup
  • Export/import Utility
  • Data Pump
  • Difference between Data Pump and Traditional Export/import
  • Impdp/expdp

PHYSICAL BACKUP

  • Introduction to Physical backup
  • Cold & Hot backup
  • Recovery scenarios
  • RMAN backup
  • RMAN Point in time recovery
  • RMAN 11g new features

PEFORMANCE TUNING

  • What is Performance Tuning?
  • Types of Tuning
  • Database Tuning
  • SQL Tuning
  • Memory Tuning
  • Network Tuning
  • Partitioning and Indexes
  • Partitioning Enhancements
  • AWR/ASH/ASMM/ADDM
  • RAT(Real Application Testing)(11g)
  • SQL Performance Analyses (11g)
  • Resemble Table spaces

Our Clients

B2B Technical Trainings Projects Delivered


Read More