Oracle DBA Online Training

Oracle DBA Online Training

Category:
Oracle /
Rated 0 out of 5
ORACLE DBA Online Training Zenfotec

Course Overview

Oracle is an object-relational database management system created and marketed by Oracle Corporation.

Oracle 11g course is the latest and most refined Oracle database. It permits high-speed transactions, sophisticated applications and higher business selections. These capabilities offer users the practicality to make high-quality and economical info applications.In most relative databases, information is accessed through SQL, or Structured query language, and Oracle is not any exception. PL/SQL is that the procedural language extension to SQL. PL/SQL could be a programming language like C, Java or Pascal. Within the Oracle world, there are no higher thanks to access your information from within a program. SQL are often natively embedded in PL/SQL programs.

Oracle Courses (for DBA training) or oracle online training at Zenfotec, is aimed towards people WHO wish to make their career in IT infrastructure field. Anyone can be a part of these oracle courses, be it the scholars, individuals operating in another IT/ non IT areas who need to move into IT infrastructure or individuals operating in IT Infrastructure (or even with Oracle Database) WHO need to boost their skills.

Who can learn?

  • Software developers and IT professionals
  • Database analysts and administrators
  • SQL programmers and architects
  • Project Managers
  • Those aspiring for a career in Oracle DBA

Pre-requisite

  • Anybody can take this Training Course. A basic knowledge of database can be helpful.

Why Zenfotec

  • Join Zenfotec Solutions, the best institute near HSR Layout, Silkboard, Bannerghata, Electronic City, Bangalore.
  • Get trained from top industry experts.
  • Pocket friendly course fee.
  • Get real time hands on experience on case studies.
  • Get course completion certificate with placement assistance.
  • For batch timings, demos (Online & Offline), and more, contact us or visit our office.

Enroll our through Oracle DBA Online Training in Bangalore and get all the Oracle DBA skills with project-based Oracle DBA training.

Oracle DBA 10g & 11g

  • Prerequisites
  • Unix/Linux, SQL (FREE)

Oracle DBA

  • Oracle database Overview, Introduction to DBA, DBA Responsibilities.

Oracle Architecture

  • Understanding Oracle Architectural components, Instance, Database, Logical Structures and User & Server Processes.
    • Managing an Oracle Instance
      • Database Admin Tools, Database Administration users.
      • Authentication Methods for DBAs.
      • Understanding Data Dictionary Contents, Initialization Parameter files, Understanding Options of Startup & Shutdown Monitoring Alert Log files, Background trace files and User Trace files.

Oracle Installation and Database Creation

  • Installation of 10g, 11g on Linux
  • De-installing Oracle
  • Oracle Database Creation using DBCA (Database Configuration Assistant)
  • Creating the Database Manually
  • Enterprise Manager Configurations
  • Deleting Database
  • Changing DBID, changing Database Name
  • Installing client software

Tablespace Management

  • Managing Tablespaces & Datafiles
    • Managing Tablespaces, Datafiles, Understanding Dictionary & Locally Managed Tablespaces,Temporary Tablespaces, Big File Tablespaces.
    • Configuring OMF for tablespace creation.
    • Altering Tablespace status.

Storage Structures

  • Using appropriate Storage settings, Types of segments.
  • Automatic segment space management, Extents and Blocks
  • Creating & Maintaining Indexes, Rebuilding Indexes.
  • Managing Undo Data
  • Understanding undo segments, Automatic undo management, Retention policy, Switching Undo tablespaces and Flashback queries.
  • Managing Controlfiles & Redo Log Files
  • Managing Controlfiles, Multiplexing & Recreating Control Files. Understanding Redo Log files, Adding and Dropping Redo Log groups and members.

User Management

  • Managing Users
  • Tablespace quota
  • Managing Resources with profiles
  • Managing Privileges & Roles

Networking Overview

  • Understanding client/server, Oracle net Architecture & key components, Oracle net services server side configuration, Configuring the Listener, Understanding Static & Dynamic service registrations, Listener control utility, Oracle client software installations Oracle net services client side configurations, Dedicated & Shared servers, Configuring Shared servers & Dispatchers Creating DB Links, Materialized views.

Backup and Recovery Overview

  • Backup & Recovery issues, categories of failures, Backup & Recovery strategies
  • Instance & Media Recovery Structures
  • Understanding Background processes, Memory structures and Files related to recovery, Phases for instance recovery.
  • Database Utilities (Data Migration or Logical Backups) Using Export & Import, Using Data Pump, Using SQL Loader
  • Configuring Archive Log mode
  • Configuring the Database Archive Log mode, changing the Archive mode, Enabling Automatic Archiving, Manually Archiving Redo Log files.
  • Configuring Flashback Database
  • Understanding Flashback Database, Configuring Flashback Database and Recovery using Flashback Database.

Data Guard Setup

  • Expdp & Impdp of tables, schemas and full database and also using network link
  • Transportable tablespaces

Exports & Imports

  • Export & Import tables, schemas and full databases

RMAN (Recovery Manager) Overview & Configuration

  • Understanding RMAN, Features & Components, Repository, Configuring the environment, Maintenance commands.
  • Backup & Recovery Using RMAN
  • Backups using RMAN, Differential Incremental & Cumulative Incremental backups, compressed backups. Complete & Incomplete Recovery using RMAN. Recovery Scenarios
  • Recovery Catalog Creation & Maintenance
  • Advantages of using Recovery Catalog, Creating & Managing the Recovery Catalog.

User Managed Backup & Recovery

  • User managed Closed & Open Database (Cold & Hot) backups, Complete & Incomplete Recovery. Recovery Scenarios
  • Database Cloning
  • Cloning Using Cold Backup Cloning Using Hot Backup Advanced Cloning Techniques
  • Recover datafile, tablespace and block corruption using RMAN.
  • Differences between 10G & 11G RMAN features.

ASM

  • Configuring ASM (ASM libs and raw devices)
  • Creating ASM Instance using DBCA
  • Creating ASM Instance Manually
  • Creating Database on ASM diskgroup
  • Managing ASM Disk Groups
  • Migrating Database to ASM using RMAN

Transportable Tablespaces

  • Transporting Tablespaces Transporting Tablespace across platforms (Migration between cross platforms)

Performance Tuning

  • Gather Optimizer statistics View performance metrics Manage the automatic workload repository (AWR) Using ADDM (Automatic Database Diagnostic Monitor) Set warning and critical alert thresholds. Using TKPROF, SQL trace, Explain Plan SQL tuning adviser, ASMM, Memory adviser Row Migration and row chaining Global temporary tables, External tables OS Tuning.

Implementing Dataguard (stand by)

  • Understanding Physical and Logical standby Implementing physical and logical standby switch over, fail over Patching and upgrading Data Guard

Trainer Information

  • 16+ Years of experience in IT Industry as Oracle DBA Trainer.
  • Expert in Oracle Architecture, Backup & Recoveries, RMAN Performance tuning and UNIX operating system & utilities.
  • Hands on experience in Oracle DBA and SQL right from installation, granting access, troubleshooting, etc.
  • 10+ years experience as Corporate trainer, Class room and Online .
  • Taught Overall 150+ Batches .

What are the various modes of training that Zenfotec offers?

We offer four types of Modes:

  • Instructor-led Online Training
  • Recorded Video Training
  • Corporate Training
  • Project Support

Do you provide placement assistance?

Toggle content goes Apart from technical training & hands-on project work Zenfotec will guide the students to get placed in there dream roles and we would be happy to assist students with the process of preparing yourself for the interview and the job.here, click edit button to change this text.

Can I request for a support session If I find difficulty in grasping topics?

We provides you email support to your queries. If the query is not resolved by email we can arrange for a one-on-one session with our trainers. The best part is that you can contact Zenfotec even after completion of training to get support and assistance.

Reviews

Average Rating

0
Rated 0 out of 5
0 Ratings

Detailed Rating

Stars 5
0
Stars 4
0
Stars 3
0
Stars 2
0
Stars 1
0

There are no reviews yet.

Only logged in customers who have purchased this product may leave a review.