CCNA training in Kochi | CCNP training in kochi www.emigonetworks.com | Emigo Networks | CCIE Training in Kochi, Cochin, Kerala | CCIE, CCNP, CCNA, MCSE, MCITP
 

Oracle DBA Training

Oracle DBA Training in Cochin at Emigo networks provides you the Best Oracle DBA Training. The Training will be fully hands-on and real-time project oriented.

Our Oracle Database Administration Course content is best suited for Absolute Beginners and Experienced Professionals. Oracle DBA Course content enablesyou to handle complex challenges and trouble shooting. The real time exposure to the Database administration tasks will actually help you to become an Expert in Oracle Database Administration (Oracle DBA).

  Role of Oracle Database Administrator?

A database administrator (DBA) is responsible for the performance, integrity and security of a database. They will also be involved in the planning and development of the database, as well as troubleshooting any issues on behalf of the users.

.

  Installation and Administration – 1Z0-062 (Workshop1)

  SECTION 1: INTRODUCTION

  • What is Database?
  • What is Oracle DBA?

  SECTION 2: EXPLORING THE ORACLE DATABASE ARCHITECTURE

  • Describe course objectives
  • Cloud computing
  • Explore the Oracle 12c database architecture
  • Container database Pluggable database

  SECTION 3: INSTALLING ORACLE DATABASE SOFTWARE

  • Explain core DBA tasks and tools
  • Install software with the Oracle Universal Installer (OUI)

  SECTION 4: CREATING A NEW DATABASE USING DBCA

  • Creating a database by using Database Configuration Assistant
  • Generating Database creation scripts and managing templates

  SECTION 5: MANAGING DATABASE STORAGE STRUCTURES

  • Creating and and managing tablespace
  • Viewing tablespace information
  • Oracle Managed Files (OMF)

  SECTION 6: MANAGING THE DATABASE INSTANCE

  • Start and stop the Oracle database and components
  • Use Enterprise Manager (EM)
  • Access a database with SQL*Plus and SQL Developer
  • Modify database initialization parameters
  • Understand the stages of database startup
  • View the Alert log
  • Use the Data Dictionary

SECTION 7: ORACLE NETWORKING

  • Managing Listeners
  • Naming methods
  • Tools for Configuring and Managing Oracle Net services
  • Advanced Connection options
  • Testing Oracle Net connectivity

  SECTION 8: ADMINISTERING USER SECURITY

  • Create and manage database user accounts
  • Authenticate users
  • Assign default storage areas (tablespaces)
  • Grant and revoke privileges
  • Create and manage roles
  • Create and manage profiles
  • Implement standard password security features
  • Control resource usage by users

  SECTION 9: MANAGING UNDO DATA

  • Explain DML and undo data generation
  • Monitor and administer undo
  • Describe the difference between undo and redo data
  • Configure undo retention
  • Guarantee undo retention
  • Use the undo advisor

  SECTION 10: IMPLEMENTING ORACLE DATABASE AUDITING

  • Restricting access to data and services
  • Authenticating users
  • Monitoring for suspicious activity

  SECTION 11: MANAGING DATA CONCURRENCY

  • Describe Locking mechanism and how Oracle manages Data Concurrency
  • Monitor and resolve Locking conflicts

  SECTION 12: BACKUP AND RECOVERY CONCEPTS

  • Categories of Failure
  • Flashback technology
  • Oracle Data protection solutions

   SECTION 13: BACKUP AND RECOVERY CONFIGURATION

  • Configuring the Fast Recovery Area
  • Multiplexing Control files and Redo Log files
  • Configuring Archivelog mode

   SECTION 14: PERFORMING DATABASE BACKUPS

  • Backup terminology – Backup strategy, Backup types, Backup mode
  • Image Copy and Backup Sets
  • Recovery Manager (RMAN)

   SECTION 15: PERFORMINGDATABASE RECOVERY

  • Introduction to High Availability (HA)
  • Introduction to Maximum Availability architecture (MAA)
  • Data Recovery Advisor
  • Managing different recovery scenarios

   SECTION 16: MOVING DATA

  • Describe available ways for moving data
  • Create and use directory objects
  • Use Data Pump Export and Import to move data between Oracle databases
  • Use SQL*Loader to load data from a non-Oracle database (or user files)

   SECTION 17: PERFORMING DATABASE MAINTENANCE

  • Managing Automatic Workload Repository (AWR)
  • Automatic Database Diagnostic Monitor (ADDM)
  • Advisory Framework

   SECTION 18: MANAGING PERFORMANCE

  • Performance monitoring
  • Instance tuning
  • Automatic memory management (AMM)
  • Automatic shared memory management (ASMM)

   SECTION 19: MANAGING PERFORMANCE: SQL TUNING

  • SQL Tuning advisor
  • SQL Optimizer
  • SQL Performance Analyzer

   SECTION 20: ORACLE UPGRADATION AND MIGRATION

  • Upgrade process – manual and using DBUA wizard
  • Migration process

  Key Features of our Oracle DBA Training in Cochin


RHCE training in kochi | CCIE training in kochi Emigo
All Rights Riserved @ 2017 Emigo Networks
Powerd byHost On Pdl.com