Core DBA 10g – Course Contents

Core DBA 10g – Course Contents

DBA online training from india, online dba training

DBA online training from india, online dba training

Course Duration : 30 Sessions (Each session is 2 Hr)

Objectives

At the end of  Core DBA course training course, the student will be able to :

  • Understand the Oracle Database Overview & Database architecture.
  • Use built-in functions of Oracle database.
  • Use of Automatic Storage Management (ASM).
  • Develop the Database Upgrade & Patching.

Benefits to you:

  • 100% student satisfaction guaranteed, if NOT fee will be returned back to student
  • Hands-on practices
  • Teaching with real-time examples
  • Introduction of various tools to be used by core DBA developers/administrators

Course Contents

Prerequisites

  • Linux 5.5 (Basics)
  • Structure Query Language (SQL)

Oracle Database & DBA

  • Oracle Database Overview
  • Oracle Database version History
  • Database Editions
  • Who is a DBA?
  • Tools for Administering an Oracle Database
  • Oracle Certifications

Oracle Database Architecture

  • Database server components
  • Logical and Physical structure of a Database
  • Oracle Instance, System Global Area (SGA) and its components
  • Database process and role of each process
  • Optimizer (CBO & RBO), Parsing (Hard parsing and soft Parsing)
  • Program Global Area (PGA) , User UGA and server process
  • Shared Memory and semaphores
  • Oracle Read Consistency and concurrency
  • Three tier Architecture

Oracle Software Installation & Database Creation

  • Optimal Fixable architecture
  • Installation of Oracle 11g on Linux & windows
  • Oracle Database Creation using DBCA (Database Configuration Assistant)
  • Creating the Database Manually
  • Changing DBID, changing Database Name
  • Enterprise Manager Configurations (OEM)
  • Deleting a Database
  • Installing client software

Managing an Oracle Instance

  • Parameter file , Pfile & SPfile
  • Instance startup & shutdown phases
  • Starting the Instance and Opening the Database
  • Shutting Down an Oracle Database Instance
  • Viewing and Modifying Initialization Parameters (Show parameter)
  • Viewing the Alert Log file
  • Dynamic performance views : V$ views, GV$ views

                                   Storage structure & managing storage 

control files & Redo log file

  • Understanding control file and its importance
  • Redo log files architecture
  • Multiplexing & Recreating control files
  • Multiplexing, Resizing & dropping log groups and members in Redo log file

Datafiles

  • What is a Datafile in database, Insides of a Datafile
  • Adding new datafiles
  • Resizing & Renaming the datafiles

Tablespace Management

  • Using appropriate Storage settings, Types of segments.
  • Automatic segment space management, Extents and Block
  • Creating, Modifying, and Dropping Tablespaces
  • Reclaiming Space in Your Tablespace
  • Big file tablespace
  • Temp tablespace
  • LMT and DMT managed tablespaces
  • Altering tablespace status

Managing Undo data

  • Understanding undo segments
  • Automatic undo management
  • Retention policy
  • Switching undo tablespaces and flashback queries

Administering Users & Security

  • Overview of Users and Security
  • Oracle-Defined Users
  • Creating, Modifying, and Dropping Users
  • Assigning and modifying tablespaces and quota
  • Locking and Unlocking Accounts
  • Unlocking a User Account and Resetting the Password
  • Setting the Password Policy
  • Modifying the Default Password Policy
  • Administering Privileges and Roles

Oracle Networking

  • Oracle NET architecture
  • Understanding CLIENT/SERVER connectivity
  • Oracle NET Listener Configuration
  • Tools for Network configuration
  • Viewing listener configuration
  • Starting and stopping the Listener
  • Dynamic and static listener registration
  • TNS clients configuration
  • Monitoring and troubleshooting oracle network
  • Creating DB Links

Backup and Recovery Overview

  • Understanding backup and recovery in oracle
  • Types of failures and backups in Oracle
  • Design, test and implementing backup and recovery strategies
  • Instance & Media Recovery Structures
  • Understanding Background  processes,  Memory  structures  and  Files  related  to recovery, Phases for instance recovery.
  • 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

Types of Backup

User Managed backup or Physical backup

Recovery manager (RMAN) backup

Logical Backup

User Managed backup

  • Online & Offline backup of full database and partial backup
  • Performing incomplete and complete recovery scenarios
  • Recovery manager (RMAN) backup
    • What is Oracle Recovery manager (RMAN)
    • Manual VS RMAN Backups
    • Archive log / NO archive log mode of a Database
    • Understanding RMAN architecture
    • Configuring RMAN with catalog and nocatalog
    • Taking backup with RMAN
    • Working with RMAN commands
    • Cumulative and Incremental backup with RMAN
    • Creating RMAN script to automate the backup
  • Logical Backup
    • Overview of Logical backup and Oracle DATA PUMP utility
    • Privileges and packages required for export/Import of objects
    • Export Full database, schema export and table level exports
    • Import Full database, schema import and table level imports
    • Transportable tablespaces for cross platform migration

Data Guard (Disaster Recovery)

  • Understanding Dataguard (DG) architecture
  • Modes of Dataguard and DG processes
  • Understanding Physical and Logical standby, Dataguard Parameters
  • Implementing physical and logical standby, performing switch over & Fail over
  • Configuring Active Dataguard
  • Monitoring and troubleshooting DG

Automatic Storage Management (ASM)

  • Overview of Automatic Storage Management (ASM)
  • Initialization parameters and ASM Instance Creation
  • Statrup and Shutdown of ASM Instances
  • Administering ASM Disk Groups
  • Adding and removing disk from disk group
  • ASM Filenames
  • ASM Views
  • SQL and ASM
  • Migrating to ASM Using RMAN

Database Upgrade & Patching

  • Understanding need for upgrade, tools and methods of up gradation
  • Upgrading oracle DB from 10g to 11g on Linux platform
  • Introduction to patches and types of patches
  • Downloading patches and applying interim patches and patchset patches
  • Patch history and documentation

Performance Tuning

  • Performance Tuning Overview
  • Proactive and reactive tuning
  • Performance tuning pack by oracle
  • Optimizer Statistics gathering, Validating invalid objects, rebuilding indexes
  • Generating and interpreting AWR, ADDM & ASH reports
  • SQL performance tuning Advisor, Explain plan
  • Parameter tuning and resource tuning

Auditing in oracle

  • Overview of auditing in Oracle, About Auditing
  • Auditing Database Activity
  • Auditing general activities using standard auditing
  • Creating a Standard Audit trail
  • Initialization parameters for auditing and audit trail views

Oracle 12c

  • New features in 12c
  • Enhancement’s in RMAN, DG, ASM etc
  • Installation of Oracle 12c on Linux

Miscellaneous

  • Interview preparation
  • TOAD and SQL developer installation and using TOAD to administer the DB
  • Resume preparation
  • Book references

DBA online training from india, online dba training

Contact Us

5th Floor, T-Hub Building
IIIT Campus, Gachibowli Circle,
Hyderabad, Telangana 500032.
Phone: +91-9966465202 (India)
+1-415-935-5884 (USA) rajuonlinetraining@gmail.com
www.rajutechnologies.com
Skype: rajutechnologies

Raju Technologies

Raju Technologies is founded and operated by real-time EXPERTS. We'll assure that, training will be delivered with 100% quality. We always reachable after the training as well.