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