Friday , August 18 2017
Home / Oracle DBA Training in Hyderabad

Oracle DBA Training in Hyderabad

ORACLE 11g / 12C DBA ( REAL TIME )

Many companies across the world hire Oracle DBA with good knowledge.In this course, students will gain thorough knowledge about Oracle DBA training Concepts & Architecture.Students will also have hands-on exposure to Oracle Installation, Configuration and Administration.

Oracle dba training in hyderabad

The focus is more on practical setup and configuration so that students will gain thorough hands-on Knowledge required to manage Oracle databases in real time. Students will also be exposed to Real time scenarios that will be implemented in typical Database Projects. The course will be implemented on Linux operating system platform.

Oracle DBA training in Hyderabad one to one

Course Pre-requisites

 Prior knowledge on BASIC SQL

 Basic Linux commands

DBA Centre Highlights

  • Technology Training
  • Lab Practice with Internet Facility
  • Real Time Scenarios and solutions
  • DBA Tools
  • ITIL Infrastructure
  • Real Time Project Concepts
  • Sample DBA Project
  • Interview Questions
  • Interview Preparation Sessions
  • Guidance on Resume preparation
  • Guidance on Oracle Certification
  • One Year Support

Oracle DBA training 11g / 12c Topics

  1. Introduction to DBA
  • What is Database? Why Database?
  • Major Databases and Database Vendors, Editions
  • Roles and Responsibilities of DBA
  1. Installing Oracle Linux
  • Installing Oracle 11g Database Server
  • Requirements for Installation
  • Installing Oracle Software
  1. Creating Oracle Database
  • Planning the Database
  • Creating Database
  • Database & Instance
  1. Oracle Database Architecture (General Overview)
  • Memory Structures – SGA, PGA
  • Background Processes
  • Server Processes
  • Database Files
  • Physical & Logical Structures
  1. Starting & Stopping Database
  • Startup & Shutdown modes
  • Starting & Stopping the database
  • Read-only & Restricted modes
  1. Parameters & Parameter Files
  • Initialization Parameters
  • Static and Dynamic parameters
  • Parameter Files
  • Text & Server Parameter Files
  • System & Session Level Parameters
  • Changing Parameter values
  1. Data Dictionary
  • Understanding Data Dictionary
  • Static & Dynamic Performance Views
  • Using Data Dictionary
  1. Managing Diagnostic data
  • Diagnostic files
  • Automatic Diagnostic Repository (ADR)
  • Viewing Diagnostic data
  1. A)Oracle Database Architecture (In Details, All Components will explain in depth)
  1. B)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
  1. Oracle Managed Files (OMF)
  • File Naming Conventions using OMF
  • Creating Tablespaces with OMF
  1. Managing Temporary Tablespaces
  • Understanding Temporary Tablespaces
  • Managing Temporary Tablespaces
  • Temporary Tablespace Groups
  1. Managing Security for Users
  • Creating Users Accounts
  • Account management
  • Schema , Session
  • Using profiles to implement complex
  • passwords and resource limits
  1. Privileges & Roles
  • Understanding Privileges , Managing Privileges
  • Understanding Roles, Managing Roles
  1. Managing Undo Data
  • Transactions and Undo Data ,Configuring Undo Retention
  • Managing Undo data , Creating Undo Tablespaces
  1. Managing Control Files
  • Understanding Control Files
  • Multiplexing Control Files
  • Backing up Control Files
  1. Redo Log Files & Archiving
  • Online & Archived Redo Log Files
  • Managing Online Redo Log Files
  • Fast Recovery Area (FRA)
  • Configuring Database Archive mode
  1. 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
  • Distributed Databases, Database Links
  1. Oracle Data Pump
  • Concepts of Logical backups & Refresh
  • Data Pump Exports & Imports
  1. Backup and Recovery
  • 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
  1. Transportable Tablespaces
  • Concepts of Transportable Tablespaces
  • Transporting Tablespaces across Databases
  1. Flashback Technologies
  • Flashback Database
  • Flashback Table
  • Flashback Drop Table
  1. Database Performance Tuning
  • Oracle Tools for Performance Tuning
  • AWR, ADDM, ASH
  • Execution Plans, using EXPLAIN PLAN
  • Application Tracing, TKPROF
  • Constraints and Partitioned Tables and Indexes
  1. Data Guard
  • Overview of Data Guard
  • Benefits of Implementing Data Guard
  • Standby Database Concepts
  • RMAN CLONE
  • Implementing Physical Standby Database
  1. Database Upgrade
  • Oracle 11g to Oracle 12C
  1. Oracle 12 C Installation and Create Database
  • Oracle Multitenant Architecture
  • Exploring the seed database
  • Multitenant Container Database Architecture
  • Databases (PDB)
  • Creating CDBs & PDBs
  • Managing CDBs & PDBs

MSSQL DBA Training with real time