Oracle DBA Training in Electronic City
Let eMexo Technologies Best Oracle DBA Training in Electronic City, Bangalore take you from the fundamentals of Oracle DBA to Advance Oracle DBA and make you an expert in developing real time Oracle DBA applications. Here are the major topics we cover under this Oracle DBA course Syllabus Introduction, Installing the Oracle Database Software, Creating an Oracle Database, Managing the Oracle Instance, Managing Database Storage Structures, Administering User Security, Managing Schema Objects, Managing Undo Data, Implementing Oracle Database Security. Each topic will be covered in practical way with examples for our Oracle DBA Course in Electronic City.
All the topics will be covered with Practical and hands on training. Our trainers have industry experience with live project experience in cutting edge technologies which they teach. We hire only Best Oracle DBA industry specialists as trainer for our Oracle DBA training in Electronic City, Bangalore.
If you are looking for Oracle DBA Training in Electronic City eMexo Technologies is the Best Oracle DBA Training Institute in Electronic City.Come over to our training institute for a free demo class. Let our trainer give you a demo on Oracle DBA and only then you take the decision to enroll into the Oracle DBA Training in Electronic City.
Oracle DBA Training Institute in Electronic City Features
<h2>Training Features</h2>
FAQs
Book Your Free Demo Class For Oracle DBA Course in Electronic City
-
Introduction (Database Architecture)
-
Installing the Oracle Database Software
-
Creating an Oracle Database
-
Managing the Oracle Instance
-
Managing Database Storage Structures
-
Administering User Security
-
Managing Schema Objects
-
Managing Undo Data
-
Implementing Oracle Database Security
-
Oracle DBA Training Syllabus – Part 2 - Configuring the Oracle Network Environment
-
Backup and Recovery Concepts
-
Performing Database Backups
-
Performing Database Recovery
-
Performing Flashback
- Describe Flashback database
- Restore the table content to a specific point in the past with Flashback Table
- Recover from a dropped table
- View the contents of the database as of any single point in time with Flashback Query
- See versions of a row over time with Flashback Versions Query
- View the transaction history of a row with Flashback Transaction Query
-
Moving Data
- Describe available ways for moving data
- Create and use directory objects
- Use SQL*Loader to load data from a non-Oracle database (or user files)
- Explain the general architecture of Data Pump
- Use Data Pump Export and Import to move data between Oracle databases
- Use external tables to move data via platform-independent files
-
Configuring Recovery Manager
- Recovery Manager Features and Components
- Using a Flash Recovery Area with RMAN
- Configuring RMAN
- Control File Autobackups
- Retention Policies and Channel Allocation
- Using Recovery Manager to connect to a target database in default NOCATALOG mode
- Displaying the current RMAN configuration settings
- Altering the backup retention policy for a database
-
Using Recovery Manager
-
Recovering from Non-critical Losses
- Recovery of Non-Critical Files
- Creating New Temporary Tablespace
- Recreating Redo Log Files, Index Tablespaces, and Indexes
- Read-Only Tablespace Recovery
- Authentication Methods for Database Administrators
- Loss of Password Authentication File
- Creating a new temporary tablespace
- Altering the default temporary tablespace for a database
-
Incomplete Recovery
-
Flashback
- Flashback Database Architecture
- Configuring and Monitoring Flashback Database
- Backing Up the Flash Recovery Area
- Using V$FLASH_RECOVERY_AREA_USAGE
- Flashback Database Considerations
- Using the Flashback Database RMAN interface
- Using Flashback Database EM Interface
- Managing and monitoring Flashback Database operations
-
Dealing with Database Corruption
-
Monitoring and Managing Storage I
-
Monitoring and Managing Storage II
-
VLDB Support
-
Automating Tasks with the Scheduler
- Scheduler Concepts
- Creating a Job Class and a Window
- Managing Jobs, Programs, Chains, Events, Schedules, priority
- Viewing and Purging Job Logs
- Creating a program and a schedule
- Creating a job that uses a program and a schedule
- Altering the program and schedule for the job and observing the behavior change of the job
- Monitoring job runs
-
Workshop
- Workshop Methodology, requirements, and setup
- Scenario 1: Database performance
- Scenario 2: Finding and Tuning Inefficient SQL
- Scenario 3: SGA Management – REDO
- Scenario 4: Running out of Undo Space
- Scenario 5: Missing datafile
- Scenario 6: Managing space in a tablespace – REDO
- Scenario 7: Missing TEMP data file