Oracle

Training Overview:

Forscher Solutions provides the Oracle Database administrator training program that focuses the delivery of the modules to perform day‐to‐day management operations on Oracle databases that are deployed on the landscapes within your own or your customer’s organization. The training is delivered by Subject Matter Experts currently managing, Oracle Databases and Oracle RAC landscapes in real time environments. The course and its contents are developed by subject matter experts and solution Architects, who deliver the solutions to Fortune 500 and Top‐Notch MNCs around the globe.

Target Audience and Prerequisites:

The training course is designed for candidates with no prior Database or Unix management experience to experienced System and Storage Managers. All trainings are designed and developed from the ground up by training experts, specifically to cater, candidates from all technical back grounds.

Course Duration:

Fast Track – 5 Days

Normal Track – 10 to 12 weekends

Corporates – Custom configured per Client requirements and modules required

Module 1: Servers, Network, Storage and Databases:

  • Overview of Servers, their processors and memory
  • Overview of Networking concepts
  • Storage Architecture from the window of a Database administrator
  • What are databases, data warehousing and Big Data ?
  • Understanding the need for a database and its applications in enterprise environments
  • Hard Disks and their architecture

Module 2: Unix and Linux Management

  • Overview of Solaris OS, its servers, processors and architecture
  • Managing a Solaris server from a DBA perspective
  • overview of IBM AIX Os, its servers, processor and its architecture
  • Managing a AIX OS
  • Overview of Linux and its distro variations
  • Using Linux OS:‐ Installation, management and navigation

Module 3: Networking and Storage

  • Understanding the Networks: Ethernet and Fiber channel
  • Networking protocols in an Enterprise environment: NFS, CIFS, iSCSI, FC and FCoE
  • Understanding SAN and NAS.
  • Advantages of SAN over NAS and vice versa.
  • Basics of Netapp management

Module 4: Understanding SQL

  • SQL Architecture and its components
  • Concepts in relational DB management
  • Creating and Managing a SQL databases
  • Create and View Schema Objects
  • Create reports from aggregated data
  • Create manage and retrieving data from multiple tables
  • Database management to access specific objects
  • Subqueries and functions
  • Writing Subqueries on a SQL database

Module 5: Oracle and its Databases: An Overview

  • Oracle Database Architecture
  • Automated Storage management and managing Disks from a Oracle DB perspective
  • Oracle Processes architecture and Memory Structures
  • Database startup and shutdown phases
  • Understanding Clustering from an Operating system end
  • Clustering and Grid technologies in Oracle explained
  • What is a Database Block
  • Understanding Tablespaces
  • Data Storage architecture on the DB table
  • ASM and disk groups
  • Databases and Listeners
  • Understanding OMF
  • Overview of Oracle Enterprise Manager ‐ OEM
  • Functionalities of OEM
  • Networking in a Oracle Environment

Module 6: Design, Plan and Installation of Oracle Software and DB

  • Understanding the system, network and storage requirements for a Oracle Software installation
  • What is OUI ‐ Oracle Universal Installer
  • Installing the Oracle Database Software on a Linux server
  • Understanding the Oracle parameters for deployment in a Unix environment
  • Understanding memory management for DBs on the UNIX platforms
  • Automatic Memory Management Mechanism ‐ AMM in Oracle
  • Planning memory management using memory advisors
  • Designing and planning a DB for an enterprise environment
  • Understanding DB deployment using the DBCA
  • Creating your First Oracle DB
  • Managing the Oracle DB Instance
  • Using SQLplus to manage the DB data
  • Starting and stopping the Oracle DB and it components
  • ASM: Initialization, Startup and shutdown
  • SQL and Oracle DB
  • Deleting the DBs Using the DBCA
  • Upgradation and patch management in Enterprise Oracle DB environment

Module 7: Managing the Oracle DBs

  • Create and Manage DB Design Templates
  • Data management in a DB
  • Data Concurrency and Enqueue Mechanism
  • Undo Data Vs. Redo Data
  • Undo Data management
  • Maintaining DBs
  • Auditing in a Oracle DB environment
  • Common errors in everyday DB management
  • Automation in Oracle DB environment

Module 8: Security from Oracle DB Perspective:

  • User Management in a Oracle DB management
  • Tools to manage the database security and password management
  • Predefined Administrative Accounts in Oracle
  • Roles of the pre‐defined account
  • Profile management for each role

Module 9: Error Logging and Monitoring

  • Viewing the Alert Logs
  • Error log capturing, monitoring and troubleshooting
  • Automatic DB Diagnostic Monitor
  • Performance monitoring tools in Oracle DB management
  • Troubleshooting and Tuning the parameters for enhancing performance in an Enterprise Environment
  • Accessing Dynamic Performance Views

Module 10: Backups and Recovery in Oracle DB

  • Overview of backups and recovery solutions in Oracle DB environment
  • Concepts of secure backups and user‐managed backups: Demystified
  • Designing, planning and implementing a backup strategy using storage technologies
  • configuring the backups in an Oracle environment
  • RMAN and backups
  • configuring and monitoring via the MTTR Advisor
  • Using Data recovery advisor
  • performing a DB recovery
  • Data pumps in DB
  • Performing a DB backup and restoration operation in an Enterprise environment