Oracle DBA

Highlights:

Students can first take up the Oracle 11g DBA then move on to become Advanced DBA by doing 11g RAC DBA, which will include Data guard Concepts and Implementations as well. Oracle Apps DBA course is designed keeping practical focused for those DBA’s who would like to go for Oracle Apps DBA career path, which is in great demand today. Students have an option to reach out to the faculty over a phone call for 1 month support to get them established in their new job as DBA.Mock Interview Sessions for all the courses at the end of the course Guidance to students for Books References, Obtain Support, Work with Oracle Corp & Right material reference to become an Expert DBA eventually – today we lack this in industry. Students can avail extra practice hours for implementations.

Duration of Training: 10 weekends

Oracle 11g Training Syllabus

Setting up VMware:

    • Introduction to VMWARE
      • Benefits of VMWARE
      • Usage of VMWARE
      • Create a VM machine (Linux / Windows)
      • Create Virtual disks
      • NAT
      • Mount ISO’s
      • Install Applications at VMWARE
      • Linux Install
      • Port forwarding (NAT)
    • Introduction to DBA
      • Relational Database Systems
      • Integrity Constraints
      • Structured Query Language
      • Tasks of an Oracle Database Administrator
    • Installation of Oracle Database Software
      • Optimal Flexible Architecture (OFA)
      • Oracle Universal Installer
      • Prerequisite Checks
      • Installation
      • Configuration Assistants
    • Creating an Oracle Database
      • Database Architecture
      • Exploring the Storage Structure
      • Control Files
      • Redo Log Files
      • Tablespaces and Datafiles
      • Segments, Extents, and Blocks
      • Oracle Instance Management
      • Oracle Memory Structures
      • Oracle Processes
      • Using Hierarchies
      • Data Dictionary
      • Database Control
      • Grid Control
      • Database Configuration Assistant (DBCA) Overview
      • Creating a Database
      • Passwords and Storage
      • File Locations and Backup Recovery
      • Content and Initialization Parameters
      • Other Actions with DBCA
    • Managing the Database
      • Starting and Stopping iSQL*Plus
      • Starting and Stopping Database Control
      • Accessing Database Control
      • SYSOPER and SYSDBA
      • Database Home Page
      • Changing the Listener Status
      • NOMOUNT MOUNT OPEN States
      • SHUTDOWN Options
      • Initialization Parameter Files
      • Viewing the Alert Log
      • Net Services
      • Oracle Net Services
      • Oracle Net Listener
      • Monitoring the Listener
      • Listening Addresses
      • Static Database Registration
      • Listener Control Utility
      • Oracle Net Connections
      • Directory Naming
      • Advanced Connections
      • Oracle Net Manager
      • Configuring Service Aliases with Net Manager
  1. Managing Schema Objects
    • Schemas
    • Accessing Schema Objects
    • Schema Object Namespaces
    • Specifying Data Types in Tables
    • Other Data Types
    • Creating and Modifying Tables
    • Understanding Data Integrity
    • Defining Constraints
    • Viewing the Attributes of a Table
    • Viewing the Contents of a Table
    • Net Services
    • Creating Indexes
    • Creating Views
    • Using a Sequence
  2. Storage Structures
      • Tablespaces and Data Files
      • Space Management in Tablespaces
      • Storage for Locally Managed Tablespaces
      • Altering a Tablespace
      • Actions with Tablespaces
      • Dropping Tablespaces
      • Viewing Tablespace Information
      • Administering Users
      • Database User Accounts
      • Creating a User
      • Profiles and Users
      • Authenticating Users
  1. Managing Data
    • Objectives
    • Manipulating Data Through SQL
    • The INSERT Command
    • Assigning Roles to Users
    • The UPDATE Command
    • The DELETE Command
    • The COMMIT and ROLLBACK Commands
    • Integrity Constraints and DML
    • Data Pump Export
    • Data Pump Import
    • DIRECTORY Objects
    • SQL*Loader
    • The SQL*Loader Control File
    • Control File Syntax Considerations
    • Input Data and Data Files
    • Loading Methods
    • Comparing Direct and Conventional Path Loads
    • External Tables
    • Transportable tablespace
    • Undo Management
    • Undo Data
    • Transactions and Undo Data
    • Storing Undo Information
    • Monitoring Undo
    • Undo Management
    • Administering Undo
    • Configuring Undo Retention
    • Guaranteeing Undo Retention
    • Sizing the Undo Tablespace
    • Using the Undo Advisor
    • Backup and Recovery Concepts
    • Backup and Recovery Issues
    • Categories of Failures
    • ARCHIVELOG Mode
    • Configuring Backup Strategy
    • Scheduling Backups: Review
    • Backup Control File to Trace
    • Manage Backups
    • Database Recovery
    • Opening a Database
    • Keeping a Database Open
  2. Scenarios:
    • Loss of a Control File
    • Loss of a Redo Log File
    • Loss of a Data File in NOARCHIVELOG Mode
    • Loss of a Noncritical Data File in ARCHIVELOG Mode
    • Loss of a System-Critical Data File in ARCHIVELOG Mode
    • Oracle Recovery Manager
    • Oracle Recovery Catalog maintenance
    • Backups using Oracle Recovery Manager
    • Recovery using Oracle recovery manager
    • Database Cloning using RMAN
    • Tablespace Point in time recovery
    • Incomplete recovery
    • Monitoring and Resolving Lock Conflicts
    • Locks
    • Locking Mechanism
    • Data Concurrency
    • DML Locks
    • Enqueue Mechanism
    • Lock Conflicts
    • Possible Causes of Lock Conflicts
    • Detecting Lock Conflicts
    • Resolving Lock Conflicts
    • Deadlocks
    • Performance Monitoring
    • Performance Monitoring
    • Monitoring Methodologies
    • Database and Instance Metrics
    • Data Dictionary Metrics
    • Optimizer Statistics
    • Schedule Optimizer Statistics Collection
    • Dynamic Performance Views
    • Viewing Metric Information
    • Reacting to Performance Issues
    • Reacting to Performance Issues
    • Proactive Maintenance
    • Server Generated Alerts
    • Thresholds
    • Setting Thresholds
    • Baseline Measurements
    • Tuning and Diagnostic Advisors
    • SQL Tuning and Access Advisors
    • Memory Advisors
    • Segment Advisor
    • Automatic Workload Repository (AWR)
    • Managing the AWR
    • Automatic Database Diagnostic Monitor (ADDM)